this is a known problem with mysql. "sql" is a reserved word so it
can't be used as column name. You have to change the sequoia.dtd file
to change the name.
I also encountered a probleme with MySQL 4, where VARCHAR without
specifying the size was not accepted. I changed all VARCHAR with TEXT.
Gérard
Deborah Merico a écrit :
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=""
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="" 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
--
ALTRAN OUEST
Gérard
BUNEL
Chef
de Projet
____________________________________________________________________
Technopôle
Brest Iroise
Site du Vernis – CS 23866
29238
Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com
|
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
