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 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
