sharing jdbc connection between java threads

[patrick boulay]

I am wondering how to share jdbc connection between java threads
anyone with experience with this , code etc .
thank you
patrick

 

[patrick boulay]

The only way that comes to (my) mind is a connection pool.

thank you

actually I have found this link
as I am working with Oracle I shall have a look

http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/tips.htm#i1005436

 

[Daniel Pitts]

I am wondering how to share jdbc connection between java threads
anyone with experience with this , code etc .
thank you
patrick

a JDBC connection is not guaranteed to be thread safe. You have to make
sure that all access to it is serialized. It is probably better to have
a connection-per-thread, or offload db work into a separate worker
thread, perhaps using a queue similar to the AWT EventQueue.

 

[Arne Vajhøj]

I am wondering how to share jdbc connection between java threads
anyone with experience with this , code etc .

You don't.

One connection per thread using the database.

Arne

 

[Arne Vajhøj]

a JDBC connection is not guaranteed to be thread safe.

It is almost guaranteed to not be thread safe.

For most databases a connection is really a socket connection
to the database where query results is being streamed back.

Without some multiplexing logic in the driver having multiple
query results streamed out mixed would not work.

[newer SQLServer actually has such logic]

Arne

 

[Richard Maher]

Hi Arne,

One connection per thread using the database.

Idyllic!

Regards Richard Maher

 

[Arne Vajhøj]

Idyllic!

I don't know if it is idyllic.

But that is how it is done.

Arne

 

[PatrickBlais]

You can also set a property in DB2 on how the connections are shared:

Determines whether connections are shared based on the current state of the connection (-1) or the original connection request (0).

To specify with greater granularity which connection
properties are matched based on the current state, you may combine the following constants by
adding them together: 1=transaction isolation level, 2=read only, 4=holdability, 8=type map, 16=catalog.

However, I would be careful using anything else than transaction isolation level.