Hi,
Does anybody got Tomcat 4 running on OS X to access MySQL successfully?
We have a large JSP-based application that we intend to port over to OS X - and everything runs perfectly under Tomcat until we discovered that...
...there is no way for it to connect to MySQL datasource. We tried accessing external MySQL database - invalid datasource. We tried installing MySQL in OS X and port database to it (success - and we can try queries etc in OS X), but the datasource is always invalid.
Part of our setting in server.xml, where database is named res. The same setting works in Windows ME/NT and Linux. But NOT OS X 10.1.4! This is really surprising...
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:mysql://localhost/res</value>
</parameter>
... the other 2 are user name and password which is not listed here for obvious reason.
In web.xml of the web application:
<resource-ref>
<res-ref-name>jdbc/res</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Any ideas? Thanks for the help!
Thye Chean
Does anybody got Tomcat 4 running on OS X to access MySQL successfully?
We have a large JSP-based application that we intend to port over to OS X - and everything runs perfectly under Tomcat until we discovered that...
...there is no way for it to connect to MySQL datasource. We tried accessing external MySQL database - invalid datasource. We tried installing MySQL in OS X and port database to it (success - and we can try queries etc in OS X), but the datasource is always invalid.
Part of our setting in server.xml, where database is named res. The same setting works in Windows ME/NT and Linux. But NOT OS X 10.1.4! This is really surprising...
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:mysql://localhost/res</value>
</parameter>
... the other 2 are user name and password which is not listed here for obvious reason.
In web.xml of the web application:
<resource-ref>
<res-ref-name>jdbc/res</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Any ideas? Thanks for the help!
Thye Chean