Hi,
Remove the extra trailing comma in:
transactionIdColumnType CDATA "BIGINT NOT NULL,"\
That should fix it.
Thanks for your interest in Sequoia,
Emmanuel
Hello,I used sequoia-2.10.10,and met a problem as following:
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 'request_id BIGINT,exec_status CHAR(1) NOT NULL,exec_time
BIGINT,up
date_count INT' at line 1)
the configuration is:
<RecoveryLog driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost/recovery" login="root" password="root">
<RecoveryLogTable/>
<CheckpointTable/>
<BackendTable/>
<DumpTable/>
</RecoveryLog>
And I changed the dtd file like this:
<!ATTLIST RecoveryLogTable
createTable CDATA "CREATE TABLE"
tableName CDATA "logtable"
logIdColumnType CDATA "BIGINT NOT NULL"
vloginColumnType CDATA "text NOT NULL"
sqlColumnName CDATA "dsql"
sqlColumnType CDATA "text NOT NULL"
sqlParamColumnType CDATA "text"
autoConnTranColumnType CDATA "CHAR(1) NOT NULL"
transactionIdColumnType CDATA "BIGINT NOT NULL,"
requestIdColumnType CDATA "BIGINT"
execTimeColumnType CDATA "BIGINT"
updateCountColumnType CDATA "INT"
extraStatementDefinition CDATA ",PRIMARY KEY (log_id)"
But it does not work.When I copied the default statement in dtd file :
CREATE TABLE logtable (
log_id BIGINT NOT NULL UNIQUE,
vlogin text NOT NULL,
dsql text NOT NULL,
sql_param text,
auto_conn_tran CHAR(1) NOT NULL,
transaction_id BIGINT NOT NULL,
request_id BIGINT,
exec_status CHAR(1) NOT NULL,
exec_time BIGINT,
update_count INT,
PRIMARY KEY (log_id)
)
to mysql command line,It can work.
Can any one help me?
Thanks
------------------------------------------------------------------------
?????????????????????????????????? <http://email.163.com>
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
http://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]
http://forge.continuent.org/mailman/listinfo/sequoia
