I'm learning JSP and Databases and I want to use connection pooling with the DataSource class. I use hypersonic sql and Mysql. I need a small example for both databases. From what I understand I need LDAP JNDI,DataSource class to use connection pooling. I want two very small servlet utilities that show me how to setup connection pooling with JNDI and the DataSource class. I would like this as a utility so that I can use it again. There is a good example of what I want in the chap 18, page 649 in the Beg Java Databases book by Wrox Press. I need to understand what's going on and how to put all this togethe on my own. It has to work on my system and be used in a servlet. I war file for most of the deployment would be great. This request is for showing me how to do it as much as it is writing the code. I need all the files required, i.e. xml,*.jar and etc. full instructions please thanks Tim
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. The zip file contains a hypersonic database. Complete copyrights to all work purchased.
## Platform
Win 2000 Jakarta Tomcat 4.0.3 JDK 1.3 Hypersonic Database(supplied) Hypersonic SQL 1.7
## Deadline information
Please write this code as an efficient utility for connection pooling for mysql and hypersonic databases. Please make it easy as possible to make your code work and remember I need this so that I can learn to do it myself.