JDBC error on oracle9i : ORA-06401:NETCMN:invalid driver designator

[sedj]

Dear fellow problem solvers,

I have a java GUI that connects to an Oracle9i database using Oracles own supplied oci JDBC driver. When I connect using the following parameters :

"oracle.jdbc.driver.OracleDriver" [for the driver]

"jdbcracleci8:BEN/BEN@" [for the url]

all is well and connection is made.

However when I try accessing the database via the net, using the url :

"jdbcracleci8:BEN/BEN@123.45.67.89:myoracle"

I get the following error :
"ORA-06401:NETCMN:invalid driver designator"

I am stumped - I throw my sanity and faith in oracle in your hands !

Many thanks for your help,

Ben

 

[wushutwist]

Oracle documentation (no help, as always):
ORA-06401 NETCMN: invalid driver designator

Cause: The login (connect) string contains an invalid driver designator.

Action: Correct the string and re-submit.

Two Comments:
1) Take a look at you connect String again. Try:

DriverManager.getConnection ("jdbc:oracle:oci8:@sid", "username", "password");

You should be suppling an SID not an IP. Since you are using OCI the IP will be looked up for you.

2) Have you tried the Oracle Thin Driver just to test? This has the added benifit of not requiring any Oracle client software. You should only need to change the connection String.

Connect String for thin driver:

"jdbc:oracle:thin:@host:port:sid"