Hello,
I'm trying to get MySQL 4.1 and Sequoia 2.10 to play together but it's
not happening. I was able to configure the sequoia tables in my DB,
initialization works on the "backend" but it barfs if I try to run a backup
via the sequoia console or enable the backend - it states that the mysql
driver isn't sequoia compatible - I'm using mysql connector j v5.1.
Here's the backend setup:
<DatabaseBackend name="myDB" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://10.1.1.8:3306/myDB"
connectionTestStatement="call now()">
<ConnectionManager vLogin="user" rLogin="test" rPassword="pass">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
Here's part of the controller output:
14:36:12,548 WARN controller.virtualdatabase.my_DB Error while initalizing
dat
abase backend streetwise (java.sql.SQLException: Driver
com.mysql.jdbc.Driver is
not Sequoia compliant)
java.sql.SQLException: Driver com.mysql.jdbc.Driver is not Sequoia
compliant
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriver
Compliance(DatabaseBackend.java:610)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.get
AndCheckBackend(VirtualDatabase.java:2101)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.ena
bleBackendFromCheckpoint(VirtualDatabase.java:1723)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.ena
bleBackendFromCheckpoint(VirtualDatabase.java:1777)
at
org.continuent.sequoia.controller.virtualdatabase.management.VirtualD
Note:
I can connect to the server with the driver via Java using the url above,
jdbc:mysql://10.1.1.8:3306/myDB.
What I don't understand is how did it make checkpoint and backend table
entries in the database (upon 'inititiation') but then has a problem with
the driver? Could be some specific command?
Anyhow, has anybody had any luck with MySQL v4.1 and Sequoia 2.10? Is there
a special driver I should be using?
Any help is greatly appreciated.
Best regards,
Randall
BEGIN:VCARD VERSION:2.1 N:Fidler;Randall FN:Randall Fidler EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20050926T075331Z END:VCARD
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
