Hi Pierre,
I try to use RecoveryLog on Oracle, tables are created on controller initialization.
I replaced BIGINT, INT and VARCHAR from original types to NUMBER(12),NUMBER(8) and VARCHAR2(xxx) with xxx empiricaly choosen from ColumnName....
My question is about recovery table, which -if I correctly undertood- stores all SQL queries.
How sequoia can manage queries with LOB fields ? (fields are liable to be larger than maximum recovery table field length)
RecoveryLogTable is the table that stores all SQL queries.
The column that store the statements is defined by sqlColumnName,sqlColumnType
and sqlParamColumnType.
The PreparedStatement template is stored in sqlColumnName and the values of
the parameters are serialized (Hex64 for LOBs) into sqlParamColumn.
<RecoveryLogTable
tableName="SEQ_RECOVERY"
logIdColumnType="NUMBER(12) NOT NULL"
vloginColumnType="VARCHAR2(255) NOT NULL"
sqlColumnName="sqlStmt"
sqlColumnType="VARCHAR2(4000)NOT NULL"
sqlParamColumnType="VARCHAR2(4000)"
These VARCHAR2(4000) are unlikely to be correct unless you can ensure
that every statement never exceeds 4000 characters. Usually we use
VARCHAR or TEXT which are unlimited in length. You might have to use a
type like CLOB with Oracle.
Hope this helps,
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
