Re: JDBC error with Oracle

If you've loaded the driver class oracle.jdbc.driver.OracleDriver, then you might try

  DriverManager.getConnection("jdbc:oracle:thin:@larry:1521:orcl", "scott", "tiger");

Assuming that larry is your machine pathname, you must be able to ping "larry" on your network....

lkaplan_at_etrade.com wrote:
>
> Just starting out with Oracle 8 on NT with JDBC. Using sample program
> JdbcTest, the line:
>
> Connection conn =
> DriverManager.getConnection"jdbc:oracle:thin:@larry:1521:ORCL",
> "scott", "tiger");
>
> Produces this error when run:
>
> G:\ORANT\JDBC\SAMPLES\THIN>java JdbcTest
> Symantec Java! JustInTime Compiler Version 3.10.093(i) for JDK 1.1.x
> Copyright (C) 1996-98 Symantec Corporation
>
> Loading Oracle driver
> Connecting to the local database
> SQL problem
> java.sql.SQLException: No more data to read from socket
> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:446)
> at oracle.jdbc.ttc7.TTCInBuffer.getByte(Compiled Code)
> at oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(TTIMsg.java:1085)
> at oracle.jdbc.ttc7.O3log.receive1st(Compiled Code)
> at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:191)
> at oracle.jdbc.driver.OracleConnection.<init>
> (OracleConnection.java:127)
>
> at oracle.jdbc.driver.OracleDriver.getConnectionInstance
> (OracleDriver.ja
> va:170)
> at oracle.jdbc.driver.OracleDriver.connect
> (OracleDriver.java:148)
> at java.sql.DriverManager.getConnection(DriverManager.java:83)
> at java.sql.DriverManager.getConnection(DriverManager.java:126)
> at JdbcTest.main(Compiled Code)
>
> Thanks for any help
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Thu Aug 26 1999 - 12:00:38 CDT