thread safe JDBC code

"Steve" wrote in message

> How to guarantee the JDBC code is thread safe? Should we put
> synchronize block in JDBC methods that performs update/delete
> operations?
>
> please advice. thanks.

Here are some articles (despite the titles, not MySQL specific) that discuss
the general problem:

http://www.mysql.com/news-and-events/newsletter/2003-04/a0000000154.html

Key phrases: "The answer to this problem is to realize that a unit of work
is scoped by a java.sql.Connection instance. In fact, even transaction
control is scoped to a java.sql.Connection, via Connection.setAutoCommit(),
Connection.commit() and Connection.rollback(). Therefore, let only one
thread at a time use a Connection instance to do its unit of work. There are
multiple strategies for doing this, from giving each thread its own
Connection instance, or sharing Connection instances via a Connection pool."

Note: one can also use ThreadLocal.

http://dev.mysql.com/tech-resources/articles/connection_pooling_with_c...ectorj.

Has code example. Recall that local variables are unique to a thread, unlike
instance and class variables. Therefore, if thread A gets a connection
locally then Threads B and C won't be accessing it.

AHS
 >> Stay informed about: thread safe JDBC code