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_______________________________________________
Sequoia mailing list
[email protected]
http://forge.continuent.org/mailman/listinfo/sequoia
