https://community.qlik.com/t5/Talend-Studio/problem-with-oracle-Connection/m-p/2219611#M14337 Hello, <BR />The JDBC driver included in tOracle component doesn't support Oracle release before 8.1.7 <BR />You can use the tJDBC components with an older driver like classe12.zip. <BR />Regards, Fri, 08 Feb 2008 17:01:49 GMT Anonymous 2008-02-08T17:01:49Z https://community.qlik.com/t5/Talend-Studio/problem-with-oracle-Connection/m-p/2219610#M14336 Hi, <BR /> I'm a newbie taking his first steps with TAO (2.3.0). <BR />I've sucessfully created a job which reads out a small Lookup-Table from an Ora 9i Database. <BR />When defining the connection , I choose "ORACLE with SID" and I entered information exactly as in TNSNAMES.ORA. <BR />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 <BR />I get :Verbindung fehlgeschlagen. Sie müssen die Datenbankeinstellungen ändern. <BR /> Detail:java.sql.SQLException: Typlänge größer als Höchstwert <BR />To get some more information I entered a known table and select statement in the connections properties <BR />and ran the job: <BR />Exception in component tOracleInput_1 <BR />java.sql.SQLException: Typlänge größer als Höchstwert <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) <BR /> at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:885) <BR /> at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2231) <BR /> at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1048) <BR /> at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:112) <BR /> at oracle.jdbc.driver.T4CTTIdcb.receive(T4CTTIdcb.java:95) <BR /> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:591) <BR /> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) <BR /> at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351) <BR /> at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) <BR /> at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383) <BR /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) <BR /> at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125) <BR /> at load_si1.test_si.test_si.tOracleInput_1Process(test_si.java:201) <BR /> at load_si1.test_si.test_si.runJobInTOS(test_si.java:384) <BR /> at load_si1.test_si.test_si.main(test_si.java:303) <BR />the database in question is a 8.0.5, the (tnsnames.ora) connection has proven to work 100s of times before (TOAD). <BR />I found a similar thread with the suggestion of setting an env variable to an appropriate ora_home on jobstart (Perl) <BR />but I 1) want to work with java <BR /> 2) have only one ora_home , so whereelse should I point to? <BR />Any suggestions are welcome <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> , Regards <BR />Max Sat, 16 Nov 2024 14:27:51 GMT https://community.qlik.com/t5/Talend-Studio/problem-with-oracle-Connection/m-p/2219610#M14336 Anonymous 2024-11-16T14:27:51Z https://community.qlik.com/t5/Talend-Studio/problem-with-oracle-Connection/m-p/2219611#M14337 Hello, <BR />The JDBC driver included in tOracle component doesn't support Oracle release before 8.1.7 <BR />You can use the tJDBC components with an older driver like classe12.zip. <BR />Regards, Fri, 08 Feb 2008 17:01:49 GMT https://community.qlik.com/t5/Talend-Studio/problem-with-oracle-Connection/m-p/2219611#M14337 Anonymous 2008-02-08T17:01:49Z