Connect to MySQL DB using multi-threading

Question

If I have a java code that deals with database and I want to use multi-threading in my application. Each thread suppose to run a function that contains insertion to the database. My question is: Where should I place the following statements:

Connection con = DriverManager.getConnection (dbUrl);
query = " insert into schema.table values (default,?,?)";   
preparedStmt = con.prepareStatement(query);

Should I place them in the run so every thread execute them? or in the Main so they are executed once only? or inside the function that is called by the run function ? I need to know the right method to insert to Database when I have multi-threads. Thanks.

Sujay · Accepted Answer · 2012-07-07 16:54:49Z

2

You should consider creating a ConnectionPool and get connection from this pool for your database related work.

The following two links might be of interest to you:

Connection Pooling
Apache Commons DBCP

Edit Thanks to @MJB for pointing this one out:
c3p0 is another one that is pretty good.
BoneCP is another one

But at the end of the day, the simple point is this: You need to implement connection pooling. Which one you choose is totally your decision and based on your requirements.

edited Jul 7, 2012 at 16:54

answered Jul 7, 2012 at 16:48

Sujay

6,7812 gold badges32 silver badges49 bronze badges

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

1 Comment

Joshua Martell Over a year ago

Connection pooling is probably the best way to deal with this. You might also consider passing messages to the thread that handles database interaction if the other threads do different kinds of jobs.

Collectives™ on Stack Overflow

Connect to MySQL DB using multi-threading

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related