Im having problems with setting up a database connection pool with mysql
connector/j.
I follow the example code in the how-twos. My problem is that Tomcat seems to
pickup my resource and its parameters (kind of)! I would like to connect to a
database that is not on localhost. So in the url paremeter I use:
<parameter>
<name>url</name>
<value>jdbc:mysql://<IP_Address>:3306/javatest?autoReconnect=true</value>
</parameter>
However, when I run the test example I get:
Access denied for user: 'javauser@<Tomcat_Machine_IP_address>' (Using password:
YES)
When I replace the IP address with duff text ie. "blahblah" I then get the error
that blahblah is a n unknownhost exception, which I expect.
This is driving me bonkers and I bet its something simple, I just cant see
it!!!!
I have been reading many articles on the net and I have tried a variety of
combinations but to no success! Arrhh!
Setup;
1) Im using the mysql connector/j drivers
2) Using Tomcat 5.0
3) On windows XP (Dev!) which will be deployed to redhat eventually!
4) Using the example on the Tomcat website, I moved the context out of:
CATALINA_HOME\conf\server.xml to:
CATALINA_HOME\conf\Catalina\localhost\DBTest.xml it behaves the same in both
cases.
Many thanks in advance.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
