Talend BLOB and CLOB data types

Anonymous — Sat, 16 Nov 2024 14:30:59 GMT

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

Re: Talend BLOB and CLOB data types

Anonymous — Wed, 14 Nov 2007 06:38:21 GMT

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

Re: Talend BLOB and CLOB data types

Anonymous — Wed, 14 Nov 2007 11:18:34 GMT

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.

Re: Talend BLOB and CLOB data types

Anonymous — Wed, 28 Nov 2007 16:13:53 GMT

Hello,
You can monitor issue 2258
Regards,

topic Re: Talend BLOB and CLOB data types in Talend Studio

Talend BLOB and CLOB data types

Re: Talend BLOB and CLOB data types

Re: Talend BLOB and CLOB data types

Re: Talend BLOB and CLOB data types