Oracle OCI and Thin drivers are missing in SQuirreL SQL

ojdbcoracle-call-interfacesquirrel-sql

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?

Best Answer

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.)
Go to the SQuirreL SQL installation folder (E.g.: C:\Program Files\squirrel-sql-3.7.1) > lib and put ojdbc7.jar there.
Restart SQuirreL SQL.

Related Solutions

Java – Oracle thin driver vs. OCI driver. Pros and Cons

The choice of the driver depends several factors. The nature of your calls to database (e.g. it seem like your app won't be using lots of stored proc calls), requirements for failover (e.g. clustered Oracle servers) and distributed transactions. Generally it is recommended to use the thin driver, but if there is some specific feature of the OCI driver that you just must have you may have to consider the OCI driver. It also been said that drivers in Oracle 10 and higher do have matching capabilities and there is practically no performance difference on modern JVMs.

Sql-server – how to connect to SQL Server with SQuirreL SQL from non domain registered Linux box

I got rid of Microsoft SQL Server JDBC Driver and downloaded jTDS driver. I tweaked a bit with it until I finally got a successful connection. The correct connection string was:

jdbc:jtds:sqlserver://<server_ip>:1433;databaseName=<instance_name>;domain=<domain_name>

Best Answer

Related Solutions

Java – Oracle thin driver vs. OCI driver. Pros and Cons

Sql-server – how to connect to SQL Server with SQuirreL SQL from non domain registered Linux box

Related Topic