How can i see the sql jboss is using to see what is generated?

----- Original Message ----- 
From: "Gary S. Cuozzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 14, 2003 4:35 PM
Subject: Re: [JBoss-user] problem with EJB-QL


> I misread your first message and thought you had switched to CMP2.
> Sorry about that.
>
> Have you looked at the SQL JBoss is using to see what is generated?  Is
> it correct?
>
>
> On Sun, 2003-12-14 at 09:14, netanel weinberg wrote:
> > but i'm using cmp 1.1
> > 'cause when i tried to move to cmp 2.0
> > JBOSS 3.2.2 gve me some erros about the JDBCFactory and etc...
> > can it be that JBOSS 3.2.2 doesn't support finder method in CMP with two
> > parameters??
> >
> > ----- Original Message ----- 
> > From: "Gary S. Cuozzo" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, December 14, 2003 3:39 PM
> > Subject: Re: [JBoss-user] problem with EJB-QL
> >
> >
> > > Looks like you are using ejb1.1 dtd.  If you are using CMP2, try:
> > > <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise
> > > JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd";>
> > >
> > > Hope that helps,
> > > Gary.
> > >
> > > On Sun, 2003-12-14 at 03:24, netanel weinberg wrote:
> > > > Hi!
> > > >     my application is deployed w/o any errors.
> > > >    my dtd is :
> > > >    <?xml version="1.0"?>
> > > >    <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD
Enterprise
> > > > JavaBeans 1.1//EN"
> > > >
> > "http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd";>
> > > >   i don't know what is wrong! can it be that JBOSS doesn't support
that
> > kind
> > > > of EJB-QL methods?
> > > >
> > > > 10x ahead.
> > > >
> > > > ----- Original Message ----- 
> > > > From: "Alexey Loubyansky" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Friday, December 12, 2003 12:13 PM
> > > > Subject: Re: [JBoss-user] problem with EJB-QL
> > > >
> > > >
> > > > > First of all, get your application deployed w/o errors. Perhaps,
the
> > DDs
> > > > > do not match their DTDs. What are the stacktraces?
> > > > >
> > > > > netanel weinberg wrote:
> > > > >
> > > > > > Hello!
> > > > > >
> > > > > >  i have a web application i built using EJB and i'm trying to
make
> > an
> > > > ejb-ql
> > > > > > according to two parameters:
> > > > > >       <query>
> > > > > >         <query-method>
> > > > > >           <method-name>findByCompanycode</method-name>
> > > > > >           <method-params>
> > > > > >             <method-param>java.lang.String</method-param>
> > > > > >             <method-param>java.lang.String</method-param>
> > > > > >           </method-params>
> > > > > >         </query-method>
> > > > > >         <ejb-ql>
> > > > > >           <![CDATA[SELECT OBJECT(a) FROM Supplier AS a WHERE
> > > > (a.companycode
> > > > > > = ?1) AND (a.suppliertype = ?2)]]>
> > > > > >         </ejb-ql>
> > > > > >       </query>
> > > > > >
> > > > > > but JBOSS 3.2.2 with Tomcat 4.1.27 embedded is returning me the
> > > > collection
> > > > > > accoding to the first parameter only!
> > > > > >  what is wrong? is it a problem with the implemention in JBOSS?
> > > > > >
> > > > > > And Something else i'm been trying to move to CMP 2.0 and
changed
> > all my
> > > > > > classes that been needed to abstract and changed my ejb-jar.xml
to
> > use
> > > > the
> > > > > > dtd of cmp 2.0 but i get an error on deploying with JBOSS on
deploy
> > > > > > something about the JDBC factory and i don't know what is it
> > problem!
> > > > it's
> > > > > > the same problem i got when i tried to use lomboz to generate an
ejb
> > > > for
> > > > > > testing.
> > > > > >
> > > > > > 10x ahead,
> > > > > >  netanel.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > -------------------------------------------------------
> > > > > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > > > > Become an expert in LINUX or just sharpen your skills.  Sign up
for
> > > > IBM's
> > > > > > Free Linux Tutorials.  Learn everything from the bash shell to
sys
> > > > admin.
> > > > > > Click now!
http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > > > > _______________________________________________
> > > > > > JBoss-user mailing list
> > > > > > [EMAIL PROTECTED]
> > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > > > Become an expert in LINUX or just sharpen your skills.  Sign up
for
> > IBM's
> > > > > Free Linux Tutorials.  Learn everything from the bash shell to sys
> > admin.
> > > > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > > > _______________________________________________
> > > > > JBoss-user mailing list
> > > > > [EMAIL PROTECTED]
> > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > > >
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > > Become an expert in LINUX or just sharpen your skills.  Sign up for
> > IBM's
> > > > Free Linux Tutorials.  Learn everything from the bash shell to sys
> > admin.
> > > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > > _______________________________________________
> > > > JBoss-user mailing list
> > > > [EMAIL PROTECTED]
> > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > > -- 
> > > Gary S. Cuozzo <[EMAIL PROTECTED]>
> > > Innovation Software Group, LLC
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > Become an expert in LINUX or just sharpen your skills.  Sign up for
IBM's
> > > Free Linux Tutorials.  Learn everything from the bash shell to sys
admin.
> > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > _______________________________________________
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: IBM Linux Tutorials.
> > Become an expert in LINUX or just sharpen your skills.  Sign up for
IBM's
> > Free Linux Tutorials.  Learn everything from the bash shell to sys
admin.
> > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> -- 
> Gary S. Cuozzo <[EMAIL PROTECTED]>
> Innovation Software Group, LLC
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user




-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to