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
