Take the 2-minute tour ×  I have a java application with
multiple thread started and they are all sharing a single db
connection created in the main function. So far things have been
running smoothly. I am worried will there be any problem in
future like corruption etc?  share|improve this question  1
Answer 1  up vote 2 down vote accepted  You will have problem
if: - you use transactions. Two threads starting transactions on
the same connection would not be nice for your datas. Think
about what mysql will do if one thread want a rollback - you use
auto increment and LAST_INSERT_ID. If two threads work on the
same table at the same moment, the last id is the same for both
if they share the same connection - and maybe much more problems
if you don't only use "simple" things (aka select/insert/update)
share|improve this answer thank you for the input yes each of my
thread is using one transaction and sure enough I am using
last_insert_id too. So what is your best suggestion then use
individual connection is it