I'm still having trouble using MySQL instead of hsqldb in the SQL
Transformer sample.
* I loaded the data into MySQL using the dump file that comes with the
sample
* I can use the MySQL Control Center to see the data and verify that the
user/password works
* I added the driver to web.xml: com.mysql.jdbc.Driver
* I renamed the hsqldb "personnel" pool in cocoon.xconf to "personnel-old"
and added:
<jdbc logger="core.datasources.personnel" name="personnel">
<pool-controller min="5" max="10"/>
<driver>com.mysql.jdbc.Driver</driver>
<dburl>jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true</dburl>
<user>TestUser</user>
<password>test</password>
</jdbc>
After the setup changes Cocoon is unable to connect to MySQL (running on the
same machine). I receive: "Failed to obtain connection. Made 5 attempts with
5000ms interval" error. The log shows:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
etc.
Any debugging suggestions? I'm pretty new to MySQL--should there be any logs
on the MySQL side to show an attempted connection?
Are there any more specific log messages I should be looking for? I'd like
to know WHY it can't connect!
Jeff
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
