Talend BLOB and CLOB data types

One Star

Talend BLOB and CLOB data types

Hi all,
Does talend support the BLOB and CLOB data types and how if yes?
Thanks in advance!
Sidi.
Community Manager

Re: Talend BLOB and CLOB data types

Hi
Yes, TOS support these two data types, when you define the schema, the data type is Object for BLOB and CLOB datas.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend BLOB and CLOB data types

I have one oracle table and I created an other one with the same structure (both have one field of type BLOB) and I build the job which copies the first table into the second (OracleInput --------------> OracleOutput). but when I execute my job no data is inserted into my target table and the following error message is displayed:
Starting job test_blob_provincia at 12:11 14/11/2007.
Exception in component tOracleOutput_1
java.sql.SQLException: Tipo di colonna non valido
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:3150)
at oracle.jdbc.driver.OraclePreparedStatement.setNullInternal(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:3653)
at caccia_project.test_blob_provincia.test_blob_provincia.tOracleInput_1Process(test_blob_provincia.java:386)
at caccia_project.test_blob_provincia.test_blob_provincia.main(test_blob_provincia.java:536)
Job test_blob_provincia ended at 12:11 14/11/2007.
Note: java.sql.SQLException: Tipo di colonna non valido = column type is not valid.
Any Help??
Thanks in advance!!
Sidi.
Employee

Re: Talend BLOB and CLOB data types

Hello,
You can monitor issue 2258
Regards,