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