Hi Bakary,
The problem is that sql is a reserved keyword in MySQL 5.1 (see
http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html)
This is why the error message is "syntax to use near 'sql VARCHAR(20)
NOT NULL...". You can override the SQL column name using the
sqlColumnName attribute in the RecoveryLogTable element. This should work:
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(50) NOT NULL"
* sqlColumnName="sql_stmt"*
sqlColumnType="VARCHAR(20) NOT NULL"
sqlParamColumnType="VARCHAR(20) NOT NULL"
autoConnTranColumnType="CHAR(1) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
Hope this helps,
Emmanuel
I am new in sequoia....
I am trying to setup Sequoia to Mirror two MySQL Servers(v5.1.30).
My Controller fails to create the RecoveryLog Tables because
"VARCHAR(size) NOT NULL" not supported...
*RecoveryLog elements*:
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(50) NOT NULL"
sqlColumnType="VARCHAR(20) NOT NULL"
sqlParamColumnType="VARCHAR(20) NOT NULL"
autoConnTranColumnType="CHAR(1) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECK_POINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="SEQUOIA_DUMP"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="DATETIME"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
*BUG*:
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLExcep
tion: Unable to create table RECOVERY (You have an error in your SQL
syntax; che
ck the manual that corresponds to your MySQL server version for the
right syntax
to use near 'sql VARCHAR(20) NOT NULL,sql_param VARCHAR(20) NOT
NULL,auto_conn_tran CHAR(1) NOT NULL,trans
action_id BIGI' at line 1)
What should I set the type of the fields in the RecoveryLog Tables
to?
Help please.
Regards
--
Bakary,
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [email protected]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
