Hi,
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)
TIA,
Pierre
PS : my recovery table config
<RecoveryLog
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@xxxx:xxxx:xxxx"
login="xxxx"
password="xxxx">
<RecoveryLogTable
tableName="SEQ_RECOVERY"
logIdColumnType="NUMBER(12) NOT NULL"
vloginColumnType="VARCHAR2(255) NOT NULL"
sqlColumnName="sqlStmt"
sqlColumnType="VARCHAR2(4000)NOT NULL"
sqlParamColumnType="VARCHAR2(4000)"
transactionIdColumnType="NUMBER(12) NOT NULL"
requestIdColumnType="NUMBER(12)"
execTimeColumnType="NUMBER(12)"
updateCountColumnType="NUMBER(8)"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable
tableName="SEQ_CHECKPOINT"
checkpointNameColumnType="VARCHAR2(255) NOT NULL"
logIdColumnType="NUMBER(12)"/>
<BackendTable
tableName="SEQ_BACKEND"
databaseNameColumnType="VARCHAR2(255) NOT NULL"
backendNameColumnType="VARCHAR2(255)"
checkpointNameColumnType="VARCHAR2(255)"/>
<DumpTable
tableName="SEQ_DUMP"
dumpNameColumnType="VARCHAR2(255) NOT NULL"
dumpDateColumnType="DATE"
dumpPathColumnType="VARCHAR2(255) NOT NULL"
dumpFormatColumnType="VARCHAR2(255) NOT NULL"
checkpointNameColumnType="VARCHAR2(255) NOT NULL"
backendNameColumnType="VARCHAR2(255) NOT NULL"
tablesColumnType="VARCHAR2(255) NOT NULL"/>
</RecoveryLog>
This e-mail is intended only for the above addressee. It may contain privileged
information.
If you are not the addressee you must not copy, distribute, disclose or use any
of the information in it.
If you have received it in error please delete it and immediately notify the
sender.
Security Notice: all e-mail, sent to or from this address, may be accessed by
someone other than the recipient, for system management and security reasons.
This access is controlled under Regulation of security reasons.
This access is controlled under Regulation of Investigatory Powers Act 2000,
Lawful Business Practises.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
