oracle 9i
public Connection getConn() throws SQLException {
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhwlcool:8080:fyt";//zhwlcool是计算机名字
Connection conn = null;
String user="scott";
String pass="ch111111";
try {
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,user,pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
报错信息:
java.sql.SQLException: Io 异常: Got minus one from a read call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
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 a.TestConn.getConn(TestConn.java:30)
at a.TestConn.getPreparedStatement(TestConn.java:48)
at a.TestConn.main(TestConn.java:57)
public Connection getConn() throws SQLException {
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhwlcool:8080:fyt";//zhwlcool是计算机名字
Connection conn = null;
String user="scott";
String pass="ch111111";
try {
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,user,pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
报错信息:
java.sql.SQLException: Io 异常: Got minus one from a read call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
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 a.TestConn.getConn(TestConn.java:30)
at a.TestConn.getPreparedStatement(TestConn.java:48)
at a.TestConn.main(TestConn.java:57)
再想问一个问题,我装的时候明明改了端口的,为什么不是我改的啊,而是用默认的的1521啊我改成8090了,然后我启动tomcat居然启动不了,端口网站显示的是oracle的信息,后来我就改我把tomcat改成8081了
但是oracle用8080又连接不上,真是奇怪
但是我安装的时候确实提示了输入端口啊
不过开发得时候,用不着oracle得httserver,你可以在服务里面都禁用掉,只留 TNSListner那个和OrcleServiceORCL(ORCL是你的SID)两个服务就可以了。