Hi Thomas, I tried it out with several several quotes. The DEBUG Level for the SqlGenerator doesn't say anything.
Isn't there a documentation for the OQL implementated in OJB? Because it it is not standard conform! Otherwise some other things like "select allObject from ServerVOExtent as allObjects" would work, etc. So from where should I know what is supported and how the syntax is? Julia. -----Urspr�ngliche Nachricht----- Von: Mahler Thomas [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 27. Juni 2003 15:18 An: 'OJB Users List' Betreff: RE: OQL Query Hi Julia, I think it has to do with the extra quotes. You should have a look at the generated SQL statements (either by enabling log level DEBUG for SqlGenerator or by using the P6Spy tracer (as documented in the FAQ)) another option would be to use oql parameter binding. cheers, Thomas > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 2:28 PM > To: [EMAIL PROTECTED] > Subject: OQL Query > > > Hello, > > I have a Value Object called ServerVO with a corresponding > table. The table > contains two entries. The primary key is composed of the fields: > protected String locale; > protected int entryId; > > It is no problem to select all entries contained in the table with the > following query: > query.create("select allObjects from " + ServerVO.class.getName()); > > It is also no problem to select by a specific id: > query.create("select allObjects from " + > ServerVO.class.getName() + " where > entryId=" + primaryKey); > > But I'm not able to select by the locale: > query.create("select allObjects from " + > ServerVO.class.getName() + " where > locale = \"EN\""); > > I dont get a exception or something like this. It simply > returns no result. > I checked the spelling of the columns and attributs over and > over again. And > i swear that the entries in the database exist and that > locale is "EN"! ;-) > > So what else could be wrong? > > Where can I find an OQL reference instead (because the odmg > site is down). > > Julia. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
