Hi Maris,
Add the sqlColumnName attribute to the VDB XML config as demonstrated below.
The root cause is that Sequoia tries to use 'SQL' as the column name which is a
reserved keyword in the Derby dialect of SQL.
<RecoveryLogTable tableName="RECOVERY"
logIdColumnType="BIGINT"
vloginColumnType="VARCHAR (500) "
sqlColumnType="VARCHAR(500)"
sqlColumnName="sqlstmt"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
Regards,
Nick
p.s. Make sure that you use Sequoia 2.10 otherwise the Recovery Log checks will
take
forever!!
----- Original Message -----
From: Maris Orbidans <[EMAIL PROTECTED]>
Date: Thursday, April 10, 2008 3:16 pm
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
> immediatelyand 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 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
>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
