Oracle OCI and Thin drivers are missing in SQuirreL SQL

Question

I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing:

• Oracle OCI Driver

• Oracle Thin Driver

  

How can I fix this problem?

Solution 1

1. Download ojdbc7.jar

   • you need an Oracle account, but the e-mail is the only important detail that you need to provide (you can add any characters for Work Phone, Company Name, etc.)

2. Go to the SQuirreL SQL installation folder (E.g.: C:\Program Files\squirrel-sql-3.7.1) > lib and put ojdbc7.jar there.

3. Restart SQuirreL SQL.

Solution 2

The file ojdbc7.jar has to be downloaded from the following page, as you must accept the license agreement: https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

Note that you are not requested to log in nor to provide your email address.

Comments

[William Gustafson]

This worked for me on macOS 11 (Big Sur) as well. I placed the driver file in the following location: /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib/