Hi again, Jason Mihalick wrote: > Thomas ... please correct me if I'm wrong here, but can't SPs be called by > the following: > > PersistenceBrokerFactory.createPersistenceBroker().getConnectionManager().ge > tConnection() > > And once you have the JDBC connection, then you can call whatever you want? > y/n? >
Sure, this is always possible. > We too may be wanting to call SPs, and this was how I was anticipating doing > it... > Of course it is possible to obtain the Jdbc connection used by a broker and to perform any operations against it. I was thinking one step further. I thought of using stored procedures instead of prepared statements for PB methods store(), etc. This would require to provide a modified SqlGenerator that generates the appropiate SP calls. (This is what Ron Gallagher was talking about.) cheers, Thomas > Thanks, > Jason > > ----- Original Message ----- > From: "Graham Lounder" <[EMAIL PROTECTED]> > To: "OJB Users List" <[EMAIL PROTECTED]> > Sent: Friday, October 11, 2002 10:41 AM > Subject: Can OJB use stored procedures? > > > >>Hi all, >> >>Simple question, does OJB 0.9.7 support stored procedures? I know Thomas >>answered a similar question back in July. At that time, there was no >>support for this with the exception of using QueryBySQL. Has this fact >>changed with the latest release? >> >>Thanks in advance, >>Graham >> >>============================================ >> Graham Lounder >> Java Developer >> Spatial Components Division >> CARIS >> 264 Rookwood Ave >> Fredericton NB E3B-2M2 >> Office 506 462-4263 >> Fax 506 459-3849 >> [EMAIL PROTECTED] >> http://www.spatialcomponents.com >>============================================ >> >> >>-- >>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]>
