有个问题向大家咨询一下,oracle客户端可以连接到数据库上,但是java程序确连接不上,连接串的地址,端口号,实例名都是正确,报Connection refusedException in thread "main" java.sql.SQLException: Io 异常: Connection refused10.72.7.109:1521:orcl at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.hongjiang.OracleConnection.main(OracleConnection.java:21)请问这个是什么原因呢
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.hongjiang.OracleConnection.main(OracleConnection.java:21)请问这个是什么原因呢
解决方案 »
- 关于hibernate util类,帮忙看一下。
- 急!系统的表分布在两个数据库中,如何配置数据源
- mysql汉字查询的时候出现空指针异常
- webwork+sitemesh中文乱码?
- 100分 求解 关于Hibernate一对一关系的问题
- 使用oc4j连接oracle———在线等
- java.util.Matcher.matchers返回的值是什么
- Application Server 8下如何实现SSL双向认证(最好有详细说明)
- 在struts的action里实现下载功能时报错“Cannot forward after response has been committed” 该如何解决?内有原码
- 关于EJB的初级问题
- ssh做数据备份,详情,请进
- N个表单的提交,求个好的方法
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
String url = "jdbc:oracle:thin:@10.72.7.109:1521:orcl";
String userName = "test";
String password = "test";
System.out.println(url);
System.out.println(userName);
System.out.println(password);
Connection conn = DriverManager.getConnection(url, userName, password); // Create a Statement
Statement stmt = conn.createStatement(); // Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery("select * from user_tables"); // Iterate through the result and print the employee names
while (rset.next())
System.out.println(rset.getString(1));
}
这个就要看ip、端口、用户名密码是否正确你用try{}catch抛出具体异常看看
连接被拒绝 看数据库服务器防火墙开着没 或者你是否有访问该网段的权限
抛出的异常
java.sql.SQLException: Io 异常: Connection refused10.72.7.109:1521:orcl at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
jar有没有导入~~
在异常中看到了这东西,你确定你的jar包与你连接的url是对应的?