Re: Server side Prepared Statement usage
Posted by: Jason Winnebeck
Date: February 11, 2005 11:08AM

I don't know if I completely understand your posting, but PreparedStatements in JDBC are "attached" to the original connection you prepared them on. This means that if you have two parallel connections and you want to execute the same statement you'll have to do two separate prepares.

Now you can keep around the reference to that PS whereever you want for reuse however you want, even sharing it between threads (with the proper synchronization of course).

Options: ReplyQuote


Subject
Written By
Posted
February 05, 2005 06:18PM
Re: Server side Prepared Statement usage
February 11, 2005 11:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.