I am trying to make a connection to oracle through java program using OCI driver. Following is the configuration. <ul> <li>Windows 7, 32 bit.</li> <li>JDK 1.7</li> <li>Oracle client 11g R2.</li> </ul> <code>ojdbc7.jar</code> in the class path of my standalone application. But I am getting following exception: <pre class="prettyprint"><code>Exception in thread 'main' java.lang.UnsatisfiedLinkError: no ocijdbc12 in java.library.path </code></pre> I tried connection using thin driver. For thin driver it is Connection Succeeded. I googled but was not able to figure out the solution. Please help me solve this problem.

I had the same issue, it was just the external folder of the my <code>*.ora</code> files which was not there any more, I pointed to it again via (menu navigation): <ul> <li>Tools <ul> <li>Preferences <ul> <li>Database <ul> <li>Advanced <ul> <li>tnsnames directory</li> </ul> </li> </ul> </li> </ul> </li> </ul> </li> </ul> It solved it!

no ocijdbc12 in java.library.path

Tags:

java

oracle

dll

oracle11g

I am trying to make a connection to oracle through java program using OCI driver.

Following is the configuration.

Windows 7, 32 bit.
JDK 1.7
Oracle client 11g R2.

ojdbc7.jar in the class path of my standalone application. But I am getting following exception:

Exception in thread 'main' java.lang.UnsatisfiedLinkError: no ocijdbc12 in java.library.path

I tried connection using thin driver. For thin driver it is Connection Succeeded. I googled but was not able to figure out the solution.

Please help me solve this problem.

990

asked Dec 12 '14 14:12

Darshil Shah

2 Answers

I had the same issue, it was just the external folder of the my *.ora files which was not there any more, I pointed to it again via (menu navigation):

Tools
- Preferences
  - Database
    - Advanced
      - tnsnames directory

It solved it!

answered Oct 01 '22 02:10

lyy

To use the oracle OCI driver you should have the relevant dlls in your java library path.

https://docs.oracle.com/cd/B28359_01/java.111/b31224/instclnt.htm#CHDIHGEF

Make sure to reference the correct release, both in term of 32/64 bit and version number.

answered Oct 01 '22 02:10

mic.sca

Related questions
                            
                                How to remove title bar in JFrame
                            
                                Spring - set a property only if the value is not null
                            
                                Android findViewById in DialogFragment
                            
                                Intent.setData vs Intent.putExtra
                            
                                What are the differences between 'Selenium-server-standalone.jar' and 'Selenium Client & WebDriver'?
                            
                                How to set and check cookies wih JAX-RS?
                            
                                Referencing non-final variable: why does this code compile?
                            
                                Superclass method being called even though object is of subclass
                            
                                "Can not set org.eclipse.aether.spi.log.Logger" with custom maven plugin
                            
                                How do I send an SMTP Message from Java? [duplicate]
                            
                                How to get a unique key for two fields with Hibernate?
                            
                                How to read MP3 file tags
                            
                                Getting real-time market/stock quotes in C#/Java
                            
                                Getting pattern string from java SimpleDateFormat
                            
                                slf4j logging with jdk – how to enable debug?
                            
                                How do I convert a document made in Jsoup (the Java html parser) into a string
                            
                                Create new object using reflection?
                            
                                NonUniqueDiscoveredSqlAliasException when two table has same column names
                            
                                How to pass intent with extras to an already running activity
                            
                                Android AutoCompleteTextView with chips

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With