Jaideep -- Just specify the procedure that you want to call in a nested "attribute" tag within the appropriate class-descriptor. All of the methods that you would be implementing to create statements include the class descriptor of the object that's being persisted. When your SqlGenerator is asked to create a statement, retrieve the name of the procedure from the ClassDescriptor that's passed in via the getAttribute method. Once you have the procedure name, you can generate whatever statement you waht. This is exactly what we're doing on our project and it works great.
Ron Gallagher Atlanta, GA [EMAIL PROTECTED] > > From: "Ganguli Jaideep" <[EMAIL PROTECTED]> > Date: 2003/01/14 Tue PM 01:35:13 EST > To: OJB Users List <[EMAIL PROTECTED]> > Subject: Re: AW: SQL Optimization/Stored Procedure > > Thanks Thomas > > If I implement my own SqlGenerator plug in would it then be used for all > my domain objects? > OR > (This is more likely what i'm looking for) > Is it possible for me to localize the SQL optimizations for a particular > domain object (with which the data access has been identified as a > bottleneck). For the others I would want to just let the default OJB > SQlGenerator handle sql generation. > > Thanks again. > > Jaideep > Mahler Thomas wrote: > > > > Yes! You can implement your own SqlGenerator an plug it into the OJB > > PersistenceBroker. > > There have been users doing this for STored procedures! > > > > cheers, > > Thomas > > > > > -----Urspr�ngliche Nachricht----- > > > Von: Ganguli Jaideep [mailto:[EMAIL PROTECTED]] > > > Gesendet: Dienstag, 14. Januar 2003 16:43 > > > An: OJB Users List > > > Betreff: SQL Optimization/Stored Procedure > > > > > > > > > Hi, > > > > > > Is there some way of making the Persistence Broker API (or > > > JDO or ODMG) > > > call an optimized SQL (or stored procedure) instead of using > > > the default > > > SQL it will use? > > > > > > Thanks > > > > > > Jaideep > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
