CODEWITHSUNDEEP
javadatabasemultithreadingjdbcibatis
mahan07
mahan07

Reputation: 917

Can two different database framework for single application share the same connection object?

I have an application in which a.jar is using jdbc framework and b.jar is using ibatis framework for database connectivity,a database operation on a.jar is taking 10 mins for executing as it is having large rows,so can a data base oparation on b.jar will also take time?

According to my knowledge both will have different connection object,but sometimes i mean very intermittenty this issue in which execution of query on b.jar will result in wait because of large query execution in a.jar resulting in entire jvm hung.

So my question is:are both the frameworks are using the same connection object because of which threads are hanging?Please help me,we are facing these issues in production.

Upvotes: 0

Views: 171

Answers (1)

Elliott Frisch
Elliott Frisch

Reputation: 201527

It is possible that they might share a connection pool (which is safe enough, because each application has its' own instance). If you run a long query from "a" then queries from "b" may well hang until the query from "a" completes, it depends on what the transaction isolation level is set to in the database (also, when you share a database - not a connection - what you do from one application can take resources from the other; which is what appears to have happened).

Upvotes: 2

Related Questions