Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and Relational Databases and the fly likes JDBC Connection Pooling issue 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 "JDBC Connection Pooling issue" Watch "JDBC Connection Pooling issue" New topic
Author

JDBC Connection Pooling issue

Prabhudatta Choudhury
Greenhorn

Joined: Jul 03, 2009
Posts: 20

I created a connection pooling class where I have all the necessary getconnection and releaseconnection Methods. I'm trying to reuse the same connection object in through out my project. So, I created an instance variable of the Connection in the inherited class and used that in all the methods in that calss. But when I tried to run the same in Tomcat 6 its throwing some error regarding release connection.





ConnectionPoolCustom2.java



Thanks
Prabhudatta
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

thanks for trying but our tags here inthe ranch use [ ] brackets not < >, so I have fixed them for you
Prabaharan Gopalan
Ranch Hand

Joined: Oct 16, 2009
Posts: 66

What exactly is the error you're getting? Were you able to execute statements through the connection acquired from the pool?


Googling doesn't make you a genius. But not Googling makes you dumber.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: JDBC Connection Pooling issue
 
It's not a secret anymore!