Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Please Help me.....! -_-;;
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