[concurrency-interest] Cancellation convention
tim at peierls.net
Tue Jun 6 17:07:05 EDT 2006
On 6/6/06, Brian Goetz <brian at quiotix.com> wrote:
> > Is it safe to share PreparedStatement instances between threads?
> We don't know. The specification is absolutely silent on the subject of
> the thread-safety of JDBC objects. However, serial thread confinement
> can be applied to the entire family of related JDBC objects (Connection
> / PS / ResultSet), and in the absence of a truly whacked out
> interpretation of the spec, should probably be OK.
Mike seemed to be proposing something outside of serial thread confinement:
PS.execute in one thread, and PS.cancel in another. But your argument (here
and in JCiP 4.5.1) is that providing a cancel method in the API makes no
sense if you can't use it in this way.
Some vendors try to make their JDBC drivers safe (like Oracle.)
> Sometimes they succeed, though the Oracle driver has had well-known
> deadlock problems in the past (can't say about the current version.)
It's quite possible that some driver implementations work by accident.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Concurrency-interest