aspose file tools*
The moose likes JDBC and the fly likes Problem with connection pooling,unable to establish connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with connection pooling,unable to establish connection" Watch "Problem with connection pooling,unable to establish connection" New topic
Author

Problem with connection pooling,unable to establish connection

Dec Decan
Greenhorn

Joined: Apr 07, 2004
Posts: 1
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 .

Thanks


Dec
 
 
subject: Problem with connection pooling,unable to establish connection