I have fixed that
<RecoveryLogTable
tableName="RECOVERY"
logIdColumnType="BIGINT "
vloginColumnType="VARCHAR(8192) "
sqlColumnName="sqlStmt"
sqlColumnType="VARCHAR(8192) "
sqlParamColumnType="VARCHAR(8192) "
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
-----Original Message-----
From: Maris Orbidans
Sent: 10 April 2008 14:17
To: 'Sequoia general mailing list'
Subject: RE: [Sequoia] can't create RECOVERY table for embedded derby
It's because derby doesn't like 'sql' as column name. Is there any way
to change it ?
14:14:13,296 DEBUG sequoia.controller.recoverylog Log table create
statement: CREATE TABLE RECOVERY (log_id BIGINT ,vlogin VARCHAR(500)
,sql VARCHAR(500) ,sql_param VARCHAR,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))
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Maris
Orbidans
Sent: 10 April 2008 13:50
To: Sequoia general mailing list
Subject: [Sequoia] can't create RECOVERY table for embedded derby
Hi
I can't create RECOVERY table if I use embedded derby:
13:46:38,353 INFO sequoia.controller.recoverylog Creating recovery log
table: RECOVERY
13:46:38,384 ERROR controller.xml.DatabasesParser Failed to check JDBC
Recovery log tables.
java.lang.RuntimeException: Unable to initialize the database:
java.sql.SQLException: Unable to create table RECOVERY (Syntax error:
Encoun
tered "sql" at line 1, column 60.)
Something wrong in my config file ?
<RecoveryLog driver="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:recoverydb1;Password=derby;User=APP;databaseName=recover
ydb1;create=true;" login="APP" password="APP">
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT"
vloginColumnType="VARCHAR (500) "
sqlColumnType="VARCHAR(500)"
extraStatementDefinition=",PRIMARY KEY
(log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(500) "/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(500) "
backendNameColumnType="VARCHAR(500) "
checkpointNameColumnType="VARCHAR(500) "/>
<DumpTable tableName="DUMP"
dumpNameColumnType="VARCHAR(500) "
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR(500) "
dumpFormatColumnType="VARCHAR(500) "
checkpointNameColumnType="VARCHAR(500) "
backendNameColumnType="VARCHAR(500) "
tablesColumnType="VARCHAR(500) "/>
**********************************************************************
Confidentiality : This e-mail and any attachments are intended for the
addressee only and may be confidential. If they come to you in error you
must take no action based on them, nor must you copy or show them to
anyone. Please advise the sender by replying to this e-mail immediately
and then delete the original from your computer.
Opinion : Any opinions expressed in this e-mail are entirely those of
the author and unless specifically stated to the contrary, are not
necessarily those of the author's employer.
Security Warning : Internet e-mail is not necessarily a secure
communications medium and can be subject to data corruption. We advise
that you consider this fact when e-mailing us.
Viruses : We have taken steps to ensure that this e-mail and any
attachments are free from known viruses but in keeping with good
computing practice, you should ensure that they are virus free.
Inspired Gaming (UK) Limited
Registered in England No 3565640
Registered Office 3 The Maltings Wetmore Road, Burton On Trent,
Staffordshire DE14 1SE
_______________________________________________________________
This message has been checked for all known viruses by the MessageLabs
Virus Control Centre.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_____________________________________________________________________
This e-mail has been scanned for viruses by MessageLabs.
**********************************************************************
Confidentiality : This e-mail and any attachments are intended for the
addressee only and may be confidential. If they come to you in error you must
take no action based on them, nor must you copy or show them to anyone. Please
advise the sender by replying to this e-mail immediately and then delete the
original from your computer.
Opinion : Any opinions expressed in this e-mail are entirely those of the
author and unless specifically stated to the contrary, are not necessarily
those of the authors employer.
Security Warning : Internet e-mail is not necessarily a secure communications
medium and can be subject to data corruption. We advise that you consider this
fact when e-mailing us.
Viruses : We have taken steps to ensure that this e-mail and any attachments
are free from known viruses but in keeping with good computing practice, you
should ensure that they are virus free.
Inspired Gaming (UK) Limited
Registered in England No 3565640
Registered Office 3 The Maltings Wetmore Road, Burton On Trent, Staffordshire
DE14 1SE
_______________________________________________________________
This message has been checked for all known viruses by the MessageLabs Virus
Control Centre.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
