I don't have javadocs for the org.apache.ojb.broker.accesslayer.sql package. Have I gotten mine from the wrong place? Thanks - MOD
--- Mahler Thomas <[EMAIL PROTECTED]> wrote: > 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] > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
