topic Re: Copy "Clob" data from one Oracle Database to another Database in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 14:08:22 GMT

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.

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

Anonymous — Mon, 01 Dec 2008 16:34:48 GMT

Clob type is a problem.

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

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

Anonymous — Tue, 02 Dec 2008 13:29:22 GMT

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

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

Anonymous — Thu, 04 Dec 2008 20:47:10 GMT

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,