If you get an error similar to the following it is most likely because the JDBC driver bundled with DbVisualizer is not compatible with Oracle 8i.

An error occurred while establishing the connection:

Long Message:
7

Details:
   Type: java.lang.ArrayIndexOutOfBoundsException

Stack Trace:
java.lang.ArrayIndexOutOfBoundsException: 7
   at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1611)
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)
   at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
   ...

To solve this you need to create a new driver entry and load a compatible JDBC driver jar file in DbVisualizer.


DbVisualizer 13.0 and later

  1. Open Tools->Driver Manager
  2. In the list of drivers, select Oracle Thin
  3. Create a new user driver using Driver->Copy Driver or Driver->Create User driver from Template (depending on what you selected)
  4. In the right pane, remove all existing Artifacts
  5. Add the compatible driver jar file (typically named classes12.jar for Oracle 8i), see new Driver Manger for how to do this.
  6. Open the details for your Oracle 8i connection and change the Driver Type to the newly created driver


In previous versions of DbVisualizer

  1. Open Tools->Driver Manager
  2. In the list of drivers, select Oracle Thin
  3. Clone it using Driver->Duplicate Driver or Driver-> 
  4. In the right pane, remove all existing jar files
  5. Click the Open File button next to the list and locate, and select the compatible driver jar file (typically named classes12.jar for Oracle 8i)
  6. Let the driver manager identify the driver class and then close the driver manager window
  7. Open the details for your Oracle 8i connection and change the Driver (JDBC) to the newly created driver
  8. Now Connect using the new driver