File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Best way to use connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Best way to use connection" Watch "Best way to use connection" New topic

Best way to use connection

Nandhakumar Soundarrajan

Joined: Apr 24, 2009
Posts: 23
Hello JAVA experts,

I am in a process of developing a web application. I am just thinking of what would be the best way to use Connection object.

I am currently adding the connection object to the user's session and using it, but I encounter some problem (Connection is busy error) when I execute a query inside a while loop of the resultset of the first query, so in those cases, I am creating a new connection and executing the outer query, so that the inner query can use the connection object from the Session.

Could you guys give me a better in sight on how to handle this?

I am using jdbc odbc bridge to connect to my SQL server.

Note, I am not facing any issues with the code when I was using Ms-Access as a database.

Nandha Kumar S.

Thanking the green horns sincerely,
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

First off, don't use the JDBC-ODBC bridge, it is not production quality. Use a proper type 4 driver instead.

Secondly, a better solution in a web application is to use a connection pool, which gives you a nive configurable way of sharing connections.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Nandhakumar Soundarrajan

Joined: Apr 24, 2009
Posts: 23
Hi Paul,

Thanks for your reply.

Now I changed my code to use "Microsoft SQL driver for JDBC" and this is a type 4 driver.

And also, using connection pooling.

Thanks for your time.
Steve Jefferson

Joined: Jul 09, 2009
Posts: 10
I think Paul is right. Have you got the solution?

Project Management Tool | Automatic Scheduling
Nandhakumar Soundarrajan

Joined: Apr 24, 2009
Posts: 23
Yes, I have implemented connection pooling and used type4 driver.

Thanks you guys...
I agree. Here's the link:
subject: Best way to use connection
It's not a secret anymore!