Copy "Clob" data from one Oracle Database to another Database
Hello,
I try to copy data from one Oracle Database to another. It's the same data model into the 2 databases and the Clob type is a problem.
My job is really simle: tOracleInput -> tMap -> tOracle Output.
After some search, I have found a property "SetBigStringTryClob" which should be initialized to "true". So I adapted a copy of "tOracleInput" and "tOracleOutput" components to initialize this connection property.
So now I read my data but when I try to write it on the second database, I have the following error:
"java.sql.SQLException: La taille des données est supérieure à la taille max pour ce type: 64660
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:905)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:82)
at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:1654)
at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:795)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1133)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:1984)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2198)
at importexportwf.test3_0_1.test3.tOracleInputCeline_1Process(test3.java:942)
at importexportwf.test3_0_1.test3.runJobInTOS(test3.java:1166)
at importexportwf.test3_0_1.test3.main(test3.java:1081)".
Please, Have you got some idea??
Thanks.
That's a little bit strange but you have to configure your components like : In tOracleInput: talend type : Object db type : Clob In tOracleOutput: talend type : String db type : Clob THis should resolve your problem. We have to work on this because, for me that really sound a little magic. HTH,
