Error Loading Native Jdbc Driver Library Oracle Sql Developer
Contents |
have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the error loading the native oci library download. So you can be up and running in usually less than 5
Testing Loading Oracle Jdbc Driver ... Failed
minutes. But if you DO happen to have a Client on your machine, you'll be happier. If you're too lazy oci thick driver sql developer to go read the above post, here it is in a nutshell: JDBC doesn't do everything that OCI can OCI does a better job at reliably cancelling queries OCI has better support
Sql Developer.oci.available False
for advanced data types including XML So, if you're on-board with the idea of connecting up your Oracle Client with SQL Developer, let's talk about how to get that going. Prior to version 4, you would tell SQL Developer to use the ‘OCI/Thick driver' - by the way, OCI stands for ‘Oracle Client Interface.' Yes or No, basically The ‘problem' here is that many testing testing native oci library load of you have more than one Client on your machine. So not being able to explicitly tell SQL Developer WHICH client to use was problematic. So in version 4, we've enhanced the preferences to allow you to tell us exactly what client to use. Now you can say what client you want us to use Note the actual PATH I have here is: "Instant Client: file:/C:/Program Files/Oracle/11203_x64_InstantClient/instantclient_11_2/" You can put the Instant Client anywhere on your machine, but we need the directory location of where we can find these files: We get really picky, so you need to get this RIGHT. The Preferences Use Oracle Client This tells SQL Developer WHERE your client is. It will then use this location to attempt to load the OCI stuff when doing things like a Password Reset on an expired connection. It won't cause SQL Developer to use the OCI/Thick driver for connections though. Use OCI Thick Driver This DOES tell SQL Developer to make OCI/Thick connections to your Oracle database. It will use the client specified in the previous preference. SQL Developer will attempt to confirm that your Client is available once you clic
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can
Ocijdbc12 Download
not post a blank message. Please type your message and try again. More
Instant Client
discussions in SQL Developer All PlacesDatabaseDatabase Application DevelopmentSQL Developer This discussion is archived 1 2 3 4 Previous Next 55 oracle instant client 64 bit Replies Latest reply on Jul 21, 2008 9:42 PM by user443012 Go to original post This content has been marked as final. Show 55 replies 30. Re: Connection Error -K- Jul 6, http://www.thatjeffsmith.com/archive/2014/01/oracle-sql-developer-4-and-the-oracle-client/ 2007 9:35 AM (in response to 203328) Can you confirm missing "/lib" in your jdbc.library? Don't know how to change that wrong path, but the easiest would be to put the jars in there. K. Like Show 0 Likes(0) Actions 31. Re: Connection Error 203328 Jul 6, 2007 9:46 AM (in response to -K-) My current jdbc folder under sqldev root looks like this: C:\sqldeveloper.new\jdbc\lib And https://community.oracle.com/thread/508732?start=30&tstart=0 files within the lib are (both copied from my oracle client lib as suggested in an earlier post): ojdbc14.jar ojdbc14dms.jar I have the original jars in the folder as well, listed in the folder as 'copy of....jar' B Like Show 0 Likes(0) Actions 32. Re: Connection Error -K- Jul 6, 2007 10:25 AM (in response to 203328) Yes, I know, but can you confirm or correct: "jdbc.library = /C:/sqldeveloper.new/jdbc/ojdbc14.jar" without the "\lib" in there? K. Like Show 0 Likes(0) Actions 33. Re: Connection Error 203328 Jul 6, 2007 10:37 AM (in response to -K-) Oops I misreported the path to the jdbc.library, I'll edit it on my other reply post, sorry. should have been: /C:/sqldeveloper.new/jdbc/lib/ojdbc14.jar Like Show 0 Likes(0) Actions 34. Re: Connection Error -K- Jul 6, 2007 11:11 AM (in response to 203328) In that case I'm out of ideas already :-( Well, if the path could have any influence according to John, you could try emptying it just to try if that affects the issue. If so, you can drill down to find out which entry was guilty. Else I hope John can help you out more... K. Like Show 0 Lik
Filed under: SQL Developer | Tags: SQL Developer |6 Comments Yesterday I installed SQL Developer 4 on a Virtualbox VM that https://galobalda.wordpress.com/2013/07/14/sql-developer-4-jdbc-errors/ also contains Oracle 11g R2 and SQL Developer 3.2.20. I had no issues installing it; but as soon as I started clicking on anything that required a database connection (which is pretty much everything), the following error showed up. I went to the preferences and under the Database/Advanced section I found the option where you can sql developer choose between the OCI Thick driver or the JDBC Thin driver. My configuration after the initial install was set to use the OCI Thick driver as you can see. So I cleared the checkbox and everything went back to normal. I know the JDBC Thin driver is the default option, so now I was wondering how come native oci library I ended up with the OCI Thick driver instead. After a few minutes, I realized that my other SQL Developer installation (3.2.20) is using the OCI Thick driver and every time you install a new version of SQL Developer a pop-up window displays asking if you want to copy your existing preferences (which I did). That explained part of the puzzle. Now I still have to figure out why the OCI Thick driver is working with version 3.2.20 but not working with version 4. Hopefully That Jeff Smith will give me a clue about what's going on🙂 Update 07/15/2013: As Jeff suggested in the comments section, a recent version of ocijdbc11.dll (instant client 11.2.0.3) placed into the /sqldeveloper/bin directory fixed the issue. This is a temporary workaround until this is corrected in the GA version. Share this:EmailPrintTwitterFacebookGoogleLike this:Like Loading... Related 6 Comments on "SQL Developer 4: JDBCErrors?" thatjeffsmith says: July 15, 2013 at 7:15 am There's a new button on the preferences - try the ‘test' to the right of the ‘