I'm trying to get sequoia (version 2.10.4) running with mysql5 but i have this
error:
----------------------------------------------
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLException: Unable to create table RECOVERY (You have an error in
your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'sql VARCHAR(255) NOT
NULL,sql_param varchar(255) default NULL,auto_conn_tran cha' at line 1)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.checkRecoveryLogTables(RecoveryLog.java:2844)
----------------------------------------------
using this configuration file:
----------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.4//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.4.dtd";>
<SEQUOIA>
<VirtualDatabase name="faxweb">
<Distribution hederaPropertiesFile="/hedera_appia.properties">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQL"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="local_localhost" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/OT_FAX_WEB" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="myuser" rPassword="mypw">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/RECOVERY_LOG" login="myuser"
password="mypw">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT(20) NOT
NULL"
vloginColumnType="VARCHAR(255) NOT NULL" sqlColumnType="VARCHAR(255)
NOT NULL"
sqlParamColumnType="varchar(255) default NULL"
autoConnTranColumnType="char(1) NOT NULL"
transactionIdColumnType="bigint(20) NOT NULL"
requestIdColumnType="bigint(20) default NULL"
execTimeColumnType="bigint(20) default NULL"
updateCountColumnType="int(11) default NULL"
extraStatementDefinition=",PRIMARY KEY (log_id),UNIQUE KEY log_id
(log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(255) NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(255) NOT NULL"
dumpFormatColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
tablesColumnType="VARCHAR(255) NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
----------------------------------------------
Can same help me?
Thank
Deborah
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
