Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Date Parsing and Locales by Opus
Filters in WebUI to limit records for individual users by Adrian.at.Talend
Issues with .csv files created by the tFileOutputDelimited component. by tgrady
Integer fields from Cache database always returning zeros by jbdailey
Job does not run concurrently in [...] by xalkideos
Insert into geometry column single quotes problem by nko
Talend Developer by Sarahjwilkins

Index
» Usage, Operation
» CLOB type and Oracle DB

Post a reply

Write your message and submit

Name

E-mail

Message

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

JuEs: 2007-09-28 11:45:53

Hi,

I have exactly the same problem has pico. So i need to "backup" datas from an oracle table (source) to a oracle table (destination) who is in an other schema. My problem is that is use CLOB in my table and the Map Component convert this CLOB in an Object Type who cause problem in job i have to do. Note that in Perl work well why a string 4000 is used but i have some CLOB who exced 4000 byte!

Hope this bug will be fixed as soon as possible.

Regards

Juan

pico: 2007-09-26 08:56:22

Hi,

I have a very simple job to do.
I want to copy all data from 1 Oracle schema to an other schema (tOracleInput --> tMap --> tOracleOutput).
The problem is that one column is of type CLOB.

With TOS 2.1.4/Java, I have the following error :

Code:

ORA-00942: table or view does not exist
Exception in component tOracleOutput_1
java.sql.SQLException: Type de colonne non valide
    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 eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.tOracleInput_1Process(Copy_of_TestReadData.java:1061)
    at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.runJob(Copy_of_TestReadData.java:1267)
    at eworkarchiver.copy_of_testreaddata.Copy_of_TestReadData.main(Copy_of_TestReadData.java:1211)

I have do exactly the same job in perl, it's ok (CLOB in perl is a string 4000).

Is it a bug with the JAVA version ?

Thanks for the great tool ... and for your help !

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Code:

Board footer