6 Replies Latest reply on Oct 7, 2005 8:06 AM by 416044

    Latest ORACLE JDBC driver for ORACLE 8 database?

    416044
      On the oracle JDBC site, the latest JDBC driver is 9.2.0.5 that also works with a ORACLE database 8.0.5. I tried one of the 10g JDBC drivers but it didn't work. Is the 9.2.0.5 JDBC driver tha last that works with an ORACLE 8 database?
        • 1. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
          416044
          Noone with experience in this field?
          • 2. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
            843859
            http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#02_02

            http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html
            • 3. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
              416044
              Thanks, I know this link and it only shows up to version 9.0.1 of the JDBC driver.
              • 4. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
                796254
                On the oracle JDBC site, the latest JDBC driver is
                9.2.0.5 that also works with a ORACLE database 8.0.5.
                I tried one of the 10g JDBC drivers but it didn't
                work.
                What does "didn't work" look like?

                The driver should be backwards compatible. Sounds like you made an error, not the driver.
                Is the 9.2.0.5 JDBC driver tha last that works
                with an ORACLE 8 database?
                The ojdbc14.jar will work. I've connected to Oracle 8 and 9 with it.

                %
                • 5. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
                  416044
                  Well "didn't work means:
                   ERROR creating BAV database connection:RDBMS Vendor Code 604: "ORA-00604: error occurred at recursive SQL level 1
                  ORA-02248: invalid option for ALTER SESSION
                  " : SQLState=60000 [mine.DataStorage ]
                  java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
                  ORA-02248: invalid option for ALTER SESSION
                  
                       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
                       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
                       at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)
                       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
                       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
                       at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
                       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
                       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
                       at java.sql.DriverManager.getConnection(DriverManager.java:525)
                       at java.sql.DriverManager.getConnection(DriverManager.java:171)
                  switching back to pre 10.x drivers, it gets back working. So, the 10.x drivers are not compatible anymore to older (8.0.5) ORACLE databases.

                  And I connect via simple
                       /**
                        * Get a JDBC connection.
                       *
                        * @param driver JDBC driver string (e.g. "oracle.jdbc.OracleDriver").
                        * @param url JDBC URL (e.g. "jdbc:oracle:thin:@server:port:schema")
                        * @param user Database user to login.
                        * @param password Password for database user.
                        * @return Connection Database connection or null if an exception occured.
                        * @throws Exception
                        */
                      public static Connection getConnection(String driver, String url, String user,
                              String password) throws Exception {
                          Connection result = null;
                  
                          Class.forName(driver).newInstance();
                          result = DriverManager.getConnection(url, user, password);
                  
                          return result;
                      }//getConnection()
                  • 6. Re: Latest ORACLE JDBC driver for ORACLE 8 database?
                    416044
                    I found the information in the ORACLE FAQ:

                    Which JDBC drivers support which versions of Oracle Database?
                    JDBC 8.1.7 drivers can talk to RDBMS
                    10.1.0
                    9.2.0
                    9.0.1
                    8.1.7
                    8.1.6
                    8.1.5
                    8.0.6
                    8.0.5
                    8.0.4
                    7.3.4.
                    JDBC 9.0.1 drivers can talk to RDBMS
                    10.1.0
                    9.2.0
                    9.0.1
                    8.1.7
                    8.1.6
                    8.1.5
                    8.0.6
                    8.0.5
                    8.0.4
                    7.3.4
                    JDBC 9.2.0 drivers can talk to RDBMS
                    10.1.0
                    9.2.0
                    9.0.1
                    8.1.7
                    JDBC 10.1.0 drivers can talk to RDBMS
                    10.1.0
                    9.2.0
                    9.0.1
                    8.1.7
                    JDBC 10.2.0 drivers can talk to RDBMS
                    10.2.0
                    10.1.0
                    9.2.0
                    9.0.1
                    8.1.7

                    So, the 9.0.1 drivers are the latest to officially support an 8.0.5 Database (even though the 9.2.0.5 driver still works with our applications on a 8.0.5 database).