Oracle OCI and Thin drivers are missing in SQuirreL SQL

oracle-call-interface ojdbc squirrel-sql
ROMANIA_engineer picture ROMANIA_engineer · Aug 1, 2016 · Viewed 22.1k times · Source

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

    Drivers OCI and Thin Driver

How can I fix this problem?

Answer

ROMANIA_engineer picture ROMANIA_engineer · Aug 1, 2016

  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.

Related questions

How to find out when an Oracle table was updated the last time

Can I find out when the last INSERT, UPDATE or DELETE statement was performed on a table in an Oracle database and if so, how? A little background: The Oracle version is 10g. I have a batch application that runs …

Read More
libaio.so.1: cannot open shared object file

I have a simple test program that when I run I get: ./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory I link it like this: $(CC) $(CCFLAGS) -o hello hello.…

Read More
Fatal error: Call to undefined function oci_connect()

I have the next lines uncommented (in my php.ini): extension=php_oracle.dll extension=php_oci8.dll And I downloaded this file instantclient-basiclite-nt-11.2.0.2.0.zip and unzipped and put that on drive D... I am using Windows XP I set …

Read More