Question

java.sql.SQLException: 无法从套接字读取更多的数据 at oracle.jdbc.driver.DatabaseError.throwSqlExcep

Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ibm","scott","quanbo");
stmt = conn.createStatement();
jat oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)

Answer 1

at TestDML.main(TestDML.java:18)贴出来你main方法的代码。打印一下conn看看有值没

追问

public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ibm","scott","quanbo");
stmt = conn.createStatement();
String sql = "insert into dept2 values (98,'GAME','BJ')";

追答

代码是没有问题的，你需要System.out.println(conn);一下看有没有值。如果有值的话，就是insert into dept2 values (98,'GAME','BJ')这句出了问题，看你的表结构和你插入的数值是否对应。你的错误信息贴的不全，现在看不出来

追问

conn没值，java.sql.SQLException: 无法从套接字读取更多的数据，这句话什么意思？

追答

conn没值的话说明你的连接有问题，看看jar包是否导入了，数据库服务是否开启了

Answer 2

Oracle无法从套接字读取更多的数据的解决

http://www.tudou.com/listplay/zlwxNFxGCJ0/AmePkLv_-0E.html

Answer 3

错误信息不全，请打印完全。尤其是cause root by ....

Answer 4

我现在遇到你这情况了，求救啊~~~求解说~~

Answer 5

问题不全。。请多写点