I am writing a Data Access Layer. At first I made this a Singleton class, so that the same DB connection is used everytime, to avoid creating many connections. Then I changed my code to use DataSource and connection pooling with Tomcat, and now I'm not sure how to go about.
I need the DataSource lookup code to run only once, and use this one DataSource to get connections to the DB. Should I keep the class a singleton?
Not sure if that will work as I am thinking to make my Connection object a member variable.
Below is my current DA class, any advice would be much appreciated:
SCJP J2SE 1.4<br />SCBCD J2EE 1.3
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