Problem with connection pooling,unable to establish connection
posted 11 years ago
Hi, I am new enough to Java, about 9 months. I am trying to run the example of connection pooling of the Tomcat documentation. I am running tomcat version 5 have manged to establish a connection to my sql database using jdbc driver but cannot this example working For anyone who has tomcat installed the example is called "JNDI Datasource HOW-TO" This can be found at http://localhost:8080/tomcat-docs/jndi-datasource-examples-howto.html
When i try to launch the jsp page i receive the message "Results Foo Not Connected Bar -1 " I set up the mysql datbase and compiled the file without any problems, I also coped the files
commons-collections.jar > commons-dbcp-1.1.jar > commons-pool-1.1.jar to the directory C:\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib I also copied the jdbc driver file aswell
If you need me to post the code i can do so , but it is exactly as it appears in the example and I have carefully followed each step. I'd be grateful for any feedback becuase i have been stuck on this for a few days. Ps:I tried running a similar example and it returned a simliar message .