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
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,
