Error on connecting database

[pauler]

Hi guys, I am using windows XP and Oracle 9.0 When I try to connect to the database using the following statement

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

// Connect to the local database
Connection conn = DriverManager.getConnection ("jdbcracleci8:@mydatabase", "scott", "tiger");

I get the following error message:

Exception in thread "AWT-EventQueue-0" java.lang.UnsatisfiedLinkError: C:\orant\BIN\oci805jdbc.dll: Can't find dependent libraries
at java.lang.ClassLoader$NativeLibrary.load... Method)

Can anyone guide me please?
Thanks in advance.

[dba]

Oracle 9 uses the dll in the following folder C:\oracle\ora92\bin\ocijdbc9.dll the C:\orant\BIN\oci805jdbc.dll this is for previous version of Oracle.

[Hack]

Do you mean for Oracle, the path is hard coded?

[dba]

Do you mean for Oracle, the path is hard coded?

// Connect to the local database
Connection conn = DriverManager.getConnection ("jdbc oracle oci8:@mydatabase", "scott", "tiger");

Oracle 9 uses the dll in the following folder C:\oracle\ora92\bin\ocijdbc9.dll the C:\orant\BIN\oci805jdbc.dll this is for previous version of Oracle.


Yes, the hardcoded path must include the ocijdbc9. Your files for Oracle 9 should in the c:\oracle\ora92 the version prior to Oracle 9 used the c:\orant\..... Check to see an oracle or orant folder. Thanks.

[Hack]

Thanks for the info. It just seems odd to do it this way.

My whole career as a programmer I've been beaten about the head and shoulders while being yelled at never, ever hard code anything.

For a product as universal and powerful as Oracle it just seems like an odd way to run a railroad.

BTW: Welcome to DevX

[dba]

// Connect to the local database
Connection conn = DriverManager.getConnection ("jdbc oracle oci8:@mydatabase", "scott", "tiger");

Oracle 9 uses the dll in the following folder C:\oracle\ora92\bin\ocijdbc9.dll the C:\orant\BIN\oci805jdbc.dll this is for previous version of Oracle.


Yes, the hardcoded path must include the ocijdbc9. Your files for Oracle 9 should in the c:\oracle\ora92 the version prior to Oracle 9 used the c:\orant\..... Check to see an oracle or orant folder. Thanks.

I agree don't hard code. Let's try again. Remove the 8 from oci8 because it is looking for the library that in the version prior to 9 it was located in a different folder. The library that you need is the oci.

[Hack]

Is the oci a folder?

[Amahdy]

paular "0 posts" interesting ...

[dba]

Is the oci a folder?

No, oci is a library. The error you received was telling you that oracle could not find the oci8 library. The library name changed from oci8 to oci and the location of the library changed in version 9 of oracle. It is no longer in the orant folder by in the oracle folder. Hope this helps.

[Hack]

Thanks for the info.