java.sql.Connection in multiple threads [duplicate]

Question

Possible Duplicate:
Is java.sql.Connection thread safe?

can multiple threads use a same java.sql.Connection to send queries to a database at the same time? all the threads will use the connection at the same time.

if the connection is obtained from a singleton class, will the above case be possible still?

1615903 · Accepted Answer · 2012-12-20 08:35:55Z

2

Yes, it's possible, but I would recommend that you implement some connection pooling - c3p0 is quite popular option.

answered Dec 20, 2012 at 8:35

1615903

35.4k14 gold badges81 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jakub Zaverka · Accepted Answer · 2012-12-20 08:37:32Z

1

No, java.sql.Connection is not thread safe. Imagine one thread issuing a command, while another command executes rollback. The previous command would be rolled back even if it would be perfectly valid. Or one thread executing a command while the other closes the connection.

However! There is no problem in creating multiple connections! SQL servers are designed to handle a large number of asynchronous connections. Instead of reinventing the wheel and synchronizing database access in the application, use the synchronization mechanism in the databse itself.

answered Dec 20, 2012 at 8:37

Jakub Zaverka

8,9023 gold badges37 silver badges50 bronze badges

2 Comments

jigzat Over a year ago

Does it matter if they are local connections?

Jakub Zaverka Over a year ago

No it doesn't. It is still not thread safe.

Collectives™ on Stack Overflow

java.sql.Connection in multiple threads [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related