Oscar,
14:18:11,804 INFO sequoia.controller.recoverylog Creating recovery
log table: RECOVERY
14:18:11,824 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 (ORA-00906:
parenthèse de gauche absente
)*
There is a problem in the SQL statement used to create the recovery table.
<RecoveryLog driver="oracle.jdbc.OracleDriver"
driverPath="/home/barrioso/apps/sequoia-2.10.6-bin/drivers/ojdbc14-oracle-10.2.jar"
url="jdbc:oracle:thin:@----------------:----:---" login="-----"
password="----">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT
NOT NULL" vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR
NOT NULL" extraStatementDefinition=",PRIMARY KEY (log_id)"/>
With this configuration, Sequoia will try to create a table using:
CREATE TABLE RECOVERY (
log_id BIGINT NOT NULL,
vlogin VARCHAR NOT NULL,
sql VARCHAR NOT NULL,
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)
)
Could you check if you get any error while executing this statement on
the database ?
I don't understand the error, it's a problem of driver
ojdbc14-oracle-10.2.jar ? In RecoveryLog tag is necessary write an
user with permissions for create a table? The error is strange...
"missing left parenthesis!", where is created this sql query?
Yes, the user that you use in the recovery log configuration for Oracle
should have rights to create tables in the recovery log database (at
least if the tables do not exist)
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[EMAIL PROTECTED]
https://forge.continuent.org/mailman/listinfo/sequoia
