Emmanuel Cecchet wrote:
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
This statement returns the same error (of course), the error appear in
BIGINT type, I test executing this statement changing BIGING->INT and
appear another error! VARCHAR need a value, I write this "VARCHAR(50)"
and finally the table is created... But appear the same error using
controller.sh with the next table...
I will review some parameters because something is wrong..
Thanks Emmanuel ;)
_______________________________________________
Sequoia mailing list
[EMAIL PROTECTED]
https://forge.continuent.org/mailman/listinfo/sequoia
