Connecting to Oracle

[Gale Greaser]

Hi -
I'm having trouble connecting to an Oracle database.
This is the code I try to connect with:
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("got driver.");

(dies here) --> conn = DriverManager.getConnection("url", "user", "pass");
System.out.println("got Connection");
This is the error message I get:
java.sql.SQLException: No more data to read from socket
java.lang.Throwable(java.lang.String)
java.lang.Exception(java.lang.String)
java.sql.SQLException(java.lang.String)
void oracle.jdbc.dbaccess.DBError.check_error(short)
short oracle.jdbc.ttc7.TTCInBuffer.getByte()
byte oracle.jdbc.ttc7.TTIMsg.unmarshalSB1()
void oracle.jdbc.ttc7.O3log.receive2nd()
oracle.jdbc.dbaccess.DBConversion oracle.jdbc.ttc7.TTC7Protocol.logon(java.lang.String, java.lang.String, java.lang.String, java.util.Properties)
oracle.jdbc.driver.OracleConnection(oracle.jdbc.dbaccess.DBAccess, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.util.Properties)
java.sql.Connection oracle.jdbc.driver.OracleDriver.connect(java.lang.String, java.util.Properties)
java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties, java.lang.ClassLoader)
java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String)

Any suggestions?
Thanks in Advance!
Gale

[Dean Reedy]

I do something like this:

 Class.forName("oracle.jdbc.driver.OracleDriver");
String connectionSQL;
String user;
String password;

connectionSQL = "jdbc :-o	 racle:thin:@<Host>:<Port>:<Instances>";
user = "username";
password = "password";
con = DriverManager.getConnection(connectionSQL, user, password); 

Note: You will need to fill in the UserName, Password, <Host>,<Port>,<Instances>
Hope this helps.
Dean

[Gale Greaser]

Thanks for the suggestion, but I received the same error when I tried it.
Could it be something with the Oracle Driver JAR file I'm using?
- Gale

[Gale Greaser]

Yep - my suspicions were correct.
I downloaded a new Oracle 9i driver from:
http://www.sba.oakland.edu/faculty/mathieson/mis426/resources/sample_programs/jdbc_oracle/default.asp
- And what d'ya know, it worked!
Must have had the wrong driver version.
Thanks for you help though!
-Gale