Copy "Clob" data from one Oracle Database to another Database

One Star cc
One Star

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.
Employee

Re: Copy "Clob" data from one Oracle Database to another Database

Clob type is a problem.

What is your TOS version ?
What is the type of your column in Talend Schema (Type and DB Type) ?
One Star cc
One Star

Re: Copy "Clob" data from one Oracle Database to another Database

My TOS Version: 3.0.0
Column Type: Object and DB Type: CLOB (in input and in output).
Thanks.
Employee

Re: Copy "Clob" data from one Oracle Database to another Database

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,