我下载Oracle数据库连接驱动类与SqlConnectText.java在同一目录下,是ojdbc6.jar
数据库版本是Oracle11g Express版本,SID是xe
JDK是1.6版本的
然后端口1521正在被监听
这是Java类代码
import java.sql.*;
public class SqlConnectTest {
private static String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
private static String theUser = "root";
private static String thePw = "root";
public static void main(String[] args) {
ResultSet rs = null;
Connection conn = null;
Statement stat = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection(dbUrl, theUser, thePw);
stat = conn.createStatement();
rs = stat.executeQuery("select * from AdminUser");
while (rs.next()) {
System.out.println(rs.getString("username")+"--"+rs.getString("password"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if(rs != null) {
try { rs.close(); } catch(Exception e) {}
}
if(stat != null) {
try { stat.close(); } catch(Exception e) {}
}
if(conn != null) {
try { conn.close(); } catch(Exception e) {}
}
}
}
}
这是异常信息
D:\F\oracle\sql>javac SqlConnectTest.java -Djava.ext.dirs=./
D:\F\oracle\sql>java -Djava.ext.dirs=./ SqlConnectTest
java.sql.SQLException: Socket read timed out
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at SqlConnectTest.main(SqlConnectTest.java:36)
Caused by: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:320)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
实在是不知道出什么问题了,求大家帮忙解答