does anybody knows if it can be that JBOSS 3.2.2 doesn't support finder
method with two parameters in EJB-QL? like that:
<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>
10x ahead,
netanel
----- Original Message -----
From: "Gary S. Cuozzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 14, 2003 6:58 PM
Subject: Re: [JBoss-user] problem with EJB-QL
> I think the <jboss_dir>/<config>/log/server.log file should default to
> DEBUG log level and should have the SQL queries in it. If not, you can
> edit the <jboss_dir>/<config>/conf/log4j.xml file and set either the
> CONSOLE or FILE appenders to DEBUG mode. I think you have to restart
> JBoss to see the effect.
>
>
> On Sun, 2003-12-14 at 10:33, netanel weinberg wrote:
> > 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
> --
> 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
