problem with oracle Connection

One Star

problem with oracle Connection

I'm a newbie taking his first steps with TAO (2.3.0).
I've sucessfully created a job which reads out a small Lookup-Table from an Ora 9i Database.
When defining the connection , I choose "ORACLE with SID" and I entered information exactly as in TNSNAMES.ORA.
Now I wanted to do the same job with another oracle database (also in the TNSnames.ora, connection data entered exactly as with first try), but when checking the connection
I get :Verbindung fehlgeschlagen. Sie müssen die Datenbankeinstellungen ändern.
Detail:java.sql.SQLException: Typlänge größer als Höchstwert
To get some more information I entered a known table and select statement in the connections properties
and ran the job:
Exception in component tOracleInput_1
java.sql.SQLException: Typlänge größer als Höchstwert
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.check_error(
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(
at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(
at oracle.jdbc.driver.T4CTTIdcb.receive(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.execute_for_describe(
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at load_si1.test_si.test_si.tOracleInput_1Process(
at load_si1.test_si.test_si.runJobInTOS(
at load_si1.test_si.test_si.main(
the database in question is a 8.0.5, the (tnsnames.ora) connection has proven to work 100s of times before (TOAD).
I found a similar thread with the suggestion of setting an env variable to an appropriate ora_home on jobstart (Perl)
but I 1) want to work with java
2) have only one ora_home , so whereelse should I point to?
Any suggestions are welcome :-) , Regards

Re: problem with oracle Connection

The JDBC driver included in tOracle component doesn't support Oracle release before 8.1.7
You can use the tJDBC components with an older driver like

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.