代码很简单就是连接成功后执行一个selec语句。
String dbUrl = "jdbc:oracle:thin:@localhost:1521:CLRExtProc";
String user = "scott";
String password = "tiger";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
c = DriverManager.getConnection(dbUrl, user, password);
Statement s = c.createStatement();
ResultSet r = s.executeQuery("select * from person");驱动包,我从ojdbc5、6、14都试过了连那个classes12也试了,sqlplus也是可以连接数据库成功的我真的要疯了 求解答啊~~大神们错误如下:
java.sql.SQLException: 无法从套接字读取更多的数据
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
at oracle.jdbc.ttc7.TTIpro.receive(TTIpro.java:133)
at oracle.jdbc.ttc7.v8TTIpro.receive(v8TTIpro.java:85)
at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1710)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:214)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.jdbcthin.<init>(jdbcthin.java:22)
at test.jdbcthin.main(jdbcthin.java:52)
Exception in thread "main" java.lang.NullPointerException
at test.jdbcthin.executeQuery(jdbcthin.java:34)
at test.jdbcthin.main(jdbcthin.java:53)
Oracle数据库EclipseJAR