Hi all,
Thanks Antonio for the pointer.
But this does not serve my purpose. (The document talks of executing an SP when
a "persistable class/ bean" (corresponding to a row of data in a table of
database) is inserted/modified/deleted).
I intend to execute the procedure independent of any such bean modifications.
For example, I may trigger the SP if a particular condition is met in my Java
class.
I am looking for an alternative to the implementation of "CallableStatement"
Java API.
Please refer to the following code snippet:
CallableStatement stmt = conn.prepareCall("call Upload_Data()"); // "conn"
is the object to connect to the database.
stmt.executeQuery();
I need an alternative to this.
Thanks for your time.
With best regards,
Anjishnu.
-----Original Message-----
From: Antonio Gallardo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 03, 2006 11:26 AM
To: OJB Users List
Subject: Re: Calling a Stored Procedure through OJB
hi,
Googling for: OJB stored procedure
returns:
http://db.apache.org/ojb/docu/howtos/howto-work-with-stored-procedures.html
Best Regards,
Antonio Gallardo.
Anjishnu Bandyopadhyay escribió:
> Hi all,
>
>
>
> I want to call an Oracle Stored Procedure (SP) through OJB (say, via the
> PersistenceBroker object).
>
> Is there a way I can do it?
>
>
>
> Thanks for your time.
>
>
>
> With best regards,
>
> Anjishnu.
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
> for the use of the addressee(s). If you are not the intended recipient,
> please notify the sender by e-mail and delete the original message. Further,
> you are not to copy, disclose, or distribute this e-mail or its contents to
> any other person and any such actions are unlawful. This e-mail may contain
> viruses. Infosys has taken every reasonable precaution to minimize this risk,
> but is not liable for any damage you may sustain as a result of any virus in
> this e-mail. You should carry out your own virus checks before opening the
> e-mail or attachment. Infosys reserves the right to monitor and review the
> content of all messages sent to or from this e-mail address. Messages sent to
> or from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
