Hi, what errors do you get? We use lots of finders with more than one parameter and didn't have problems with them so far.
Heiko > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > netanel weinberg > Sent: Monday, December 15, 2003 12:17 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] problem with EJB-QL > > > 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 > ------------------------------------------------------- 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_id78&alloc_id371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
