Is Connection thread safe for Oracle drivers?

Joe Sam Shirah

Because of changing technology and the database and goals of the particular driver developer, it is always best to check the actual ( and current ) driver documentation; In this case check Oracle's site.

However, the spec confirms that for JDBC Compliant(tm) drivers "We require that all operations on all the java.sql objects be multi-thread safe and able to cope correctly with having several threads simultaneously calling the same object." The spec goes on to give an example with a connection. The bad news is that concurrency MAY be achieved by serial behavior. For further information, see the JDBC Specification, Chapter 9 - Asynchrony, Threading, and Transactions, section 9.2.

0 Comments  (click to add your comment)
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



About | Sitemap | Contact