how to enter the url value for a mysql jdbc resource

[gschrade]

I am trying to enter the value for the url parameter for a mysql jdbc resource in server.xml. I am entering the url without the user and password appended because I am including a user and password parameter in the resourse. Yet when I hit the servlet, it says "Access denied for user: nobody@mymachine.mydomain (Using password: YES)" but I am providing the user and password in their parameters? Am I missing something?

 

[sedj]

post your relevant entry in server.xml for the data source ...

 

[gschrade]

Here is the resourse in server.xml:

<Resource name="jdbc/myDatabase"
type="javax.sql.DataSource"
auth="Container"
debug="6"
/>
<ResourceParams name="jdbc/myDatabase"/>
<paramater>
<name>user</name>
<value>someuser</value>
</parameter>
<parameter>
<name>password</name>
<value>somepassword</value>
<parameter>
<name>driverClassName</name>
<value>com.jdbc.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>
jdbc:mysql://mymachine.mydomain/myDatabase
</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>9</value>
</parameter>
</ResourceParams>

 

[sedj]

Two problems :

Your driverClassName is incorrect. It should be com.mysql.jdbc.Driver

You url is incorrect. It should be like :
jdbc:mysql://servername:3306/dbName

 

[gschrade]

I had the driver part correct, I just typed it wrong here. I used my domain without the machine name in front then followed with :3306 and I get the following exception: java.net.UnknownHostException

 

[sedj]

I'm not sure if you can use a domain name. Normally, people use the machine name, or IP address.

 

[gschrade]

When I use the machine name it gets past the java.net.UnknownHostException and puts me back to my original problem: it does not recognize the user and password parameter in server.xml

 

[sedj]

According to

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html

...

This is wrong :
<paramater>
<name>user</name>
<value>someuser</value>
</parameter>

This is right :

<parameter>
<name>username</name>
<value>someuser</value>
</parameter>

 

[gschrade]

Thank you! That was it. I was looking at a book written by someone. I shall know now not to trust that always and to look at the documentation.

Thanks again