problem with oracle Connection

One Star

problem with oracle Connection

Hi,
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(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:885)
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2231)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1048)
at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:112)
at oracle.jdbc.driver.T4CTTIdcb.receive(T4CTTIdcb.java:95)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:591)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
at load_si1.test_si.test_si.tOracleInput_1Process(test_si.java:201)
at load_si1.test_si.test_si.runJobInTOS(test_si.java:384)
at load_si1.test_si.test_si.main(test_si.java:303)
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
Max
Employee

Re: problem with oracle Connection

Hello,
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 classe12.zip.
Regards,