Thread: error in type2driver

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
DriverManager.getConnection("jdbcracleci:@192.168.1.6:1522:apsnacs","arunasree_linux","p osidex");

i wrote above code by setting the class path to classes12.jar

i am getting following exception

Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java :1734)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.jav a:262)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:314)
at java.sql.DriverManager.getConnection(DriverManager .java:582)
at java.sql.DriverManager.getConnection(DriverManager .java:185)
at com.posidex.type2driver.TypeTwoDriver.main(TypeTwo Driver.java:15)
please can any one solve this it's urgent requirement

You need to add the ojdbc jar to your classpath.

Originally Posted by aprabhat

You need to add the ojdbc jar to your classpath.

dear i added to the classpath i tried with ojdbc14.jar as well classes12.jar dear.

Related to http://www.javaprogrammingforums.com...ification.html.

Type 2 drivers are hybrid drivers that are part Java and part native. For the latter part you may need to add the associated native library/ies to some environment variables. I'm not familiar with Oracle, but I'd suggest you first find out the Oracle version that you have. After that do an Internet search for the JDBC driver download for that version. E.g., you can find the drivers for Oracle 12c Release 1 at Oracle Database 12c Release 1 JDBC Driver Downloads. Then look for the README file, which contains installation instructions that would state the environment variables you need to set up.

Hi, kindly check the below points.

1. Whether you have installed the Oracle Client.
2. If you have installed, kindly check whether you have added the OCI jar file is added in the classpath and path environment variable.
3. Also pls check the version of the Oracle Client that you are using.
4. If your java version is <= 1.3; then use the classes12.jar else try to use the client's ojdbc14.jar file in the class path.

Let me know if you still could not resolve after checking the above points.

Dear Bharath,
I installed the oraclexe 10g .
1)first i want to know what is oracle client

--- Update ---

Dear Bharath,
dont mind actually i am new to java.
how can i check wheather the odbc jars added or not in my classpath.

Okay.. You have something called as environment variables in your computer.. Classpath is one of the many environment variables. All you need to do is to edit the classpath environment variable in your computer by adding the path to the ojdbc14.jar or the OCI jar file. The new path can be appended to the existing value by using the semicolon ( as the delimiter. To find environment variables do the following.

Right click on My Computer -> Properties -> Advanced System Settings -> Advanced Tab -> Environment Variables button (in Windows 7 OS). In case if you have not set class path till now then kindly do set it.

Oracle client is nothing but a program which talks to the Oracle server and gets your intented work done. Its one of the client-server architecture model. Kindly refer online tutorials for more information.