hello all,
i have a problem to connect to my mysql database. i tried the hole day to get a
connection but it does not work. I read about 5 tutorials to get the MySQL Connector/J
installed, but no result.
Could anybody give me a hint?
I'm using Cocoon 2.1.4 with Tomcat 4.1.29 on Windows 2000 with MySQL 4.0.15.
Error message:
WARN (2004-03-01) 16:25.47:650 [core.manager] (/cocoon/samples/dev/query)
http8080-Processor4/ResourceLimitingJdbcDataSource: Could not return connection
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
-----------------------
my configuration:
in web.xml:
...
<servlet>
<servlet-name>Cocoon</servlet-name>
<display-name>Cocoon</display-name>
<description>Cocoon</description>
<servlet-class>org.apache.cocoon.servlet.CocoonServlet</servlet-class>
<init-param>
<param-name>load-class</param-name>
<param-value>com.mysql.jdbc.Driver</param-value>
<!-- <param-value>org.gjt.mm.mysql.Driver</param-value> -->
</init-param>
...
in cocoon.xconf:
...
<datasources>
<jdbc name="mysqlpool">
<dburl>jdbc:mysql://localhost:3306/cocoondb</dburl>
<user>root</user>
<password></password>
</jdbc>
...
---------------------
I tried to put the mysql-connector-java-3.0.11-stable-bin.jar (or the
mysql-connector-java-3.1.1-alpha-bin.jar) into
"C:\tomcat_4.1.29\webapps\cocoon\WEB-INF\lib\" but that did not work.
Than i put the foldersystem "com\mysql\jdbc" into
"C:\tomcat_4.1.29\webapps\cocoon\WEB-INF\classes\" and after that i tried the old
'Mark Matthews' driver namer "org\gjt\mm\mysql".
Nothing worked....
Any help?
Thanx, Pascal
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
