Java JDBC thread safety

Question

If I have following sequence in a function

void UpdateDatabase(conn) { createStatement executeStaement getResult }

Is this sequence of calls multithreading safe in Java

I think you need to show us some more code snippet, like what parameters are used by createStatement, executeStaement and getResult. How are you calling the UpdateDatabase function — Apurv
– Apurv, Commented Apr 17, 2013 at 8:40
Also it will depend on what database you are using as well. Typically databases will manage concurrent requests. So you wouldn't worry about thread safety at db client side. — anoopelias
– anoopelias, Commented Apr 17, 2013 at 8:45

Franz Kafka · Accepted Answer · 2013-04-17 09:33:59Z

Asuming your threads don't share any state or otherwise synchronize the shared state correctly the execution is only thread safe when viewing what happens inside of the JVM. More importantly however is if your data can still be corrupted.

Every JDBC connection should only be used by one thread at a time, which you are doing. Database systems however define four isolation levels, defining which state of the data concurrent transactions can see. If your concurrent transactions don't touch the same data your fine. If they do, have a look at the isolation level of your database.

Evgeniy Dorofeev · Accepted Answer · 2013-04-17 08:59:22Z

0

If you change it a little

void updateDatabase() { getConnection createStatement executeStaement getResult }

it will be definitely thread safe

answered Apr 17, 2013 at 8:59

Evgeniy Dorofeev

137k31 gold badges209 silver badges288 bronze badges

1 Comment

Apurv Over a year ago

Well, the question is "Is this sequence of calls thread safe". And not how to make this thread-safe

Collectives™ on Stack Overflow

Java JDBC thread safety

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related