This is fixed now in JBoss-3.2.4RC1. Thanks. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stephane Nicoll > Sent: Friday, January 23, 2004 12:47 PM > To: JBoss user (E-mail) > Subject: [JBoss-user] IS (NOT) EMPTY EJBQL supported in JBoss > for mysql ? > > Hello, > > I've seen people complaining about this but not a message > saying whether it's a bug or not. > > We use JBoss 3.2.3 with a mySQL database 4.0.16 and the > latest JDBC driver. > We noticed that IS EMPTY or IS NOT EMPTY ejb ql are badly > translated by JBoss. Here's an example: > > > * @ejb.finder > * signature="java.util.Collection > findByCountryIdAndHasScanner(java.lang.String countryId)" > * result-type-mapping="Local" > * method-intf="LocalHome" > * query="SELECT OBJECT(o) FROM KP o WHERE o.country.countryId > = ?1 AND o.scanners IS NOT EMPTY" > > JBoss translates this to the following SQL: > > SELECT DISTINCT t0_o.kp_id FROM kp t0_o, country t1_o_country > WHERE (t1_o_country.country_id = ? AND > t2_o_scanners.scanner_id IS NOT NULL AND > t0_o.country_id=t1_o_country.country_id) > > t2_o_scanners is never defined. > > Is it a bug? How can we manage to define this query without > the IS (NOT) EMPTY clause? > > Regards, > > Stephane > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 Premiere > Conference on Open Tools Development and Integration See the > breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > >
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
