Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Please Help me.....! -_-;;

Please Help me.....! -_-;;

From: Choi wontai <skydew_at_shinbiro.com>
Date: Sat, 29 Aug 1998 18:37:44 +0900
Message-ID: <35E7CBE8.D74DE58C@shinbiro.com>


I read your letters in Usenet.
and I thought that You can help me solving my problem. Please Help me....
I've got a problem while I try to connect Oracle7.33(UNIX) using JDBC thin driver.
I could make a connection to Oracle with JDBC thin driver before I reinstall Oracle. I reinstalled Oracle from Same CD. but now, It doesn't work correctly.
While I use Oracle Navigater or SQLPlus on My Window Client, it's fine. and works very well. There are no problem. but establishing a connection to Oracle with Sample JDBC makes a serious SQL exception like this.

C:\JDBC\samples\thin>java Emp
Driver Loaded...
java.sql.SQLException: No more data to read from socket

        at java.lang.Throwable.<init>(Compiled Code)
        at java.sql.SQLException.<init>(Compiled Code)
        at oracle.jdbc.dbaccess.DBError.check_error(Compiled Code)
        at oracle.jdbc.ttc7.TTCInBuffer.getByte(Compiled Code)
        at oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(Compiled Code)
        at oracle.jdbc.ttc7.O3log.receive1st(Compiled Code)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:163)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:146)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at java.sql.DriverManager.getConnection(Compiled Code)
        at Emp.main(Compiled Code)

and the Source is like this.
import java.sql.*;

class Emp
{
  public static void main (String args [])

       throws SQLException, ClassNotFoundException   {
    Class.forName ("oracle.jdbc.driver.OracleDriver");     System.out.println("Driver Loaded...");

    Connection conn =
      DriverManager.getConnection
("jdbc:oracle:thin:@203.254.86.129:1521:ORA733",

       "scott", "tiger");
    System.out.println("DB Connected...");

    Statement stmt = conn.createStatement ();

    ResultSet rset = stmt.executeQuery ("select ENAME from EMP");     System.out.println("Query Exequted...");

    while (rset.next ())
      System.out.println (rset.getString (1));   }
}

What is the reason? I can't understand. It works fine before reinstall oracle.
But doesn't work now........
Have you ever experienced this problem? Please Help me.
Thanks in advance. Received on Sat Aug 29 1998 - 04:37:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US