Hi, I use P6Spy to see generated sql at runtime.
Houar -----Message d'origine----- De : Mahler Thomas [mailto:[EMAIL PROTECTED] Envoyé : lundi 17 mars 2003 17:46 À : 'OJB Users List' Objet : RE: how to obtain the SQL code from a Query object? Mhh, I don't know all API changes since 0.9.5 by heart, but the SqlGeneratorFactory is really a very old piece of code. have a look in the org.apache.ojb.broker.accesslayer.sql package Maybe you can also instaiate SqlGenerator directly?! cheers, Thomas > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, March 17, 2003 4:30 PM > To: [EMAIL PROTECTED] > Subject: RE: how to obtain the SQL code from a Query object? > > > 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] > > --------------------------------------------------------------------- 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]