You need to download Oracle JDBC driver (ojdbc7.jar and/or ojdbc6.jar) and add it to the SQuirreL list of drivers.
If you were able to connect to Oracle in the previous version, you already have the driver - just enable it.
--
Alexandre Peshansky, MS
Lead Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(914) 294-6916 (office) (201) 970-3530 (cell)
[cid:image001.png@01D42E74.02145D00]
From: Pete Storer [mailto:Pet...@sa...]
Sent: Tuesday, August 07, 2018 1:40 PM
To: squ...@li...
Subject: [Squirrel-sql-users] Oracle driver change for SQuireL 3.8.1
I just upgraded our Squirrel client from 3.7.1 to 3.8.1 using the downloaded jar file. The installation seemed to go okay, but now the only valid driver that I am showing in my list is a Postgres driver. Most critically, the Oracle driver that I use for a LOT of connections is broken - I see the following errors:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Could not find class oracle.jdbc.driver.OracleDriver in neither the Java class path nor the Extra class path of the Oracle Thin Driver driver definition:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
I am nobody's Java expert, so I haven't a clue what the problem is or how to resolve it. I do know that Java 1.8.071 is running on this server, which should be sufficient. Any guidance would be most appreciated.
Thanks.
Pete Storer
|