Thomas, Thanks for your help!
How do you use this SqlGeneratorFactory. This class doesn't seem to be in OJB 0.9.5. I think that I could migrate to 1.0 but I don't know what exactly I will have to change in my code. Best. Sylvain -----Message d'origine----- De: Mahler Thomas [mailto:[EMAIL PROTECTED] Date: lundi, 17. mars 2003 16:12 �: 'OJB Users List' Objet: RE: how to obtain the SQL code from a Query object? Hi Sylvain, I think so! But you can use the SqlGeneratorFactory to obtain a SqlGenerator instance instead! cheers, Thomas > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, March 17, 2003 3:59 PM > To: [EMAIL PROTECTED] > Subject: RE: how to obtain the SQL code from a Query object? > > > Hi Thomas, > > I can't find the broker.serviceSqlGenerator() method. > > I'm using OJB 0.9.5. > Is it the problem? > > Thanks > Sylvain > > > > -----Message d'origine----- > De: Mahler Thomas [mailto:[EMAIL PROTECTED] > Date: lundi, 17. mars 2003 10:59 > �: 'OJB Users List' > Objet: RE: how to obtain the SQL code from a Query object? > > > The Query object is not able to return SQL code, as it does > not have any > platform specific know how. > You have to ask the OJB SqlGenerator component to generate SQL: > > PersistenceBroker broker = ... > Query query = ...; > ClassDescriptor cld = ...; > > // obtain prepared stmt sql: > String sql = > broker.serviceSqlGenerator().getPreparedSelectStatement(query, > cld); > > // obtain no prepared sql: > sql = broker.serviceSqlGenerator().getSelectStatementDep(query, cld); > > cheers, > thomas > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 17, 2003 10:32 AM > > To: [EMAIL PROTECTED] > > Subject: how to obtain the SQL code from a Query object? > > > > > > Hello, > > > > I have this query: > > > > ----code---- > > Criteria crit = new Criteria(); > > crit.addEqualTo("workstationName", "U68111"); > > > > Query query = new QueryByCriteria(Workstation.class, crit, true); > > ----code---- > > > > Is there a way to obtain the SQL query (select * from > > Workstation where....) from the query object? > > > > Thanks > > Sylvain > > > > > --------------------------------------------------------------------- > > 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] > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
