Issues when connecting to Oracle database

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Issues when connecting to Oracle database

alfville
I am able to connect to an Oracle Database instance that requires "thin" driver, but when trying to an Oracle Database instance which requires "OCI" driver, then I am getting the error message below.

Wonder if anyone has been able to connect to an Oracle database instance which requires the OCI driver.

1) When using ojdbc5.jar or ojdbc6.jar got the following:

ERROR o.s.s.p.Platform  Can not start Sonar
org.picocontainer.PicoLifecycleException: PicoLifecycleException: method 'public void org.sonar.server.database.JndiDatabaseConnector.start()', instance 'org.sonar.server.database.JndiDatabaseConnector@68c12474, java.lang.RuntimeException: wrapper

Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path


2) When using ojdbc14.jar then got the following:

ERROR o.s.s.p.Platform  Can not start Sonar
org.picocontainer.PicoLifecycleException: PicoLifecycleException: method 'public void org.sonar.server.database.JndiDatabaseConnector.start()', instance 'org.sonar.server.database.JndiDatabaseConnector@7178b64b, java.lang.RuntimeException: wrapper

Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
Reply | Threaded
Open this post in threaded view
|

Re: Issues when connecting to Oracle database

Freddy Mallet
Hello,

I don't know what to say without duplicating the error message :-)

Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

If you use the Oracle OCI version of the jdbc driver that means that you want to use the native oracle library that must be installed locally. The Oracle JDBC driver is expecting to find the path to this native library with help of the "java.library.path" property. So looks like you haven't correctly configured your java environment to use this Oracle native library.

Kind regards,
Freddy


I am able to connect to an Oracle Database instance that requires "thin"
driver, but when trying to an Oracle Database instance which requires "OCI"
driver, then I am getting the error message below.

Wonder if anyone has been able to connect to an Oracle database instance
which requires the OCI driver.

1) When using ojdbc5.jar or ojdbc6.jar got the following:

ERROR o.s.s.p.Platform  Can not start Sonar
org.picocontainer.PicoLifecycleException: PicoLifecycleException: method
'public void org.sonar.server.database.JndiDatabaseConnector.start()',
instance 'org.sonar.server.database.JndiDatabaseConnector@68c12474,
java.lang.RuntimeException: wrapper

Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path