Io 异常: The Network Adapter could not establish the connection

TommyWu01 2013-01-23 12:06:17
JDBC.property 配置如下：



jdbc.driverClassName   = oracle.jdbc.driver.OracleDriver

jdbc.url      = jdbc:oracle:thin:@10.25.33.137:1521:orcl

jdbc.username = jiefang

jdbc.password = jiefang123

jdbc.maxActive= 50


异常信息如下：

2013-01-23 11:58:34,546 ERROR [org.quartz.core.ErrorLogger] - An error occured while scanning for the next trigger to fire.

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'appDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)]

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:636)

	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3652)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2654)

	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:235)

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)

	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

	at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:197)

	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)

	... 4 more

Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

	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:441)

	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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

	... 8 more

2013-01-23 12:03:34,656 ERROR [org.quartz.impl.jdbcjobstore.JobStoreTX] - ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'appDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'appDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)]

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:636)

	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3070)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)

	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

	at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:197)

	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)

	... 4 more

Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

	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:441)

	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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

	... 8 more

2013-01-23 12:04:04,656 ERROR [org.quartz.impl.jdbcjobstore.JobStoreTX] - MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'appDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'appDS': org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection) [See nested exception: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)]

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:636)

	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3011)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: The Network Adapter could not establish the connection)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)

	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

	at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:197)

	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)

	... 4 more

Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

	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:441)

	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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

	... 8 more
...全文
798 13 打赏 收藏 转发到动态 举报
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
wx602350769 2013-03-14
  • 打赏
  • 举报
 回复
呵呵 我这边也报了这个问题了，也是quartz集群工作，不过我用的是c3p0 当前环境中该错误的出现频率很少，一般几个小时出现一次，怀疑是数据库连接遇到 terminate session导致 修改oracle服务端的sqlnet.ora文件 设置expire_time试一试
TommyWu01 2013-01-27
  • 打赏
  • 举报
 回复
引用 11 楼 xiaochao062 的回复:
commons-collections-3.1.jar 这个包没有导进去！大神！连接池必要的三个包之一！你自己去百度下一个吧！
这个包有，是commons-collections-3.2.jar
xiaochao062 2013-01-24
  • 打赏
  • 举报
 回复
commons-collections-3.1.jar 这个包没有导进去！大神！连接池必要的三个包之一！你自己去百度下一个吧！
brightyq 2013-01-23
  • 打赏
  • 举报
 回复
数据库连接是不是有问题,用sqlplus连接下oracle,看能不能连上.
iLemon 2013-01-23
  • 打赏
  • 举报
 回复
Failed to obtain DB connection from data source 'appDS' 已经说了，从appDs获取连接失败！
TommyWu01 2013-01-23
  • 打赏
  • 举报
 回复
引用 7 楼 ma929226676 的回复:
数据库大管家那个jar包没加进项目里
what?
TommyWu01 2013-01-23
  • 打赏
  • 举报
 回复
引用 8 楼 ivanjuli 的回复:
翻译会么？ 网络适配器.......先检查网络问题（ping一下数据库服务器ip）。再检查url，password，user。
ip 能ping 通，url password user 都是正确的。
ivanjuli 2013-01-23
  • 打赏
  • 举报
 回复
翻译会么？ 网络适配器.......先检查网络问题（ping一下数据库服务器ip）。再检查url，password，user。
枫桥 2013-01-23
  • 打赏
  • 举报
 回复
数据库大管家那个jar包没加进项目里
TommyWu01 2013-01-23
  • 打赏
  • 举报
 回复
引用 1 楼 yanan_seachange 的回复:
Failed to obtain DB connection from data source 'appDS' 已经说了，从appDs获取连接失败！
应该不是这个问题！下面是applicationContext-db.xml 配置文件 
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

	<!-- jndi datasource 
	<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 
	    <property name="jndiName" value="java:comp/env/appDS"/>
    </bean>
	<bean id="cleanDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 
	    <property name="jndiName" value="java:comp/env/appDS"/>
    </bean>    
	-->
	
	<!-- DBCP Basic datasource    --> 
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  destroy-method="close">
        <property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
        <property name="url"><value>${jdbc.url}</value></property>
        <property name="username"><value>${jdbc.username}</value></property>
        <property name="password"><value>${jdbc.password}</value></property>
		<property name="maxActive"><value>${jdbc.maxActive}</value></property>
    </bean>
	<bean id="cleanDataSource" class="org.apache.commons.dbcp.BasicDataSource"  destroy-method="close">
        <property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
        <property name="url"><value>${jdbc.url}</value></property>
        <property name="username"><value>${jdbc.username}</value></property>
        <property name="password"><value>${jdbc.password}</value></property>
		<property name="maxActive"><value>${jdbc.maxActive}</value></property>
    </bean>   
   
    
    
    <!-- Transaction manager for Spring JDBC -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    
    <bean id="transactionManager4Test" class="com.baosight.iplat4j.core.soa.util.AutoRollbackTransactionManager">
        <property name="manager" ref="transactionManager"/>
    </bean>
    
  

</beans>
TommyWu01 2013-01-23
  • 打赏
  • 举报
 回复
引用 2 楼 brightyq 的回复:
数据库连接是不是有问题,用sqlplus连接下oracle,看能不能连上.


使用 DbVisualizer 能连接成功！

TommyWu01 2013-01-23
  • 打赏
  • 举报
 回复
引用 3 楼 xulong1 的回复:
这个问题不是很明显吗？连接数据库错误，检查网络，检查数据库链接url，用户名和密码，没什么好说的
url, 密码，和用户名都是正确的。
xulqif 2013-01-23
  • 打赏
  • 举报
 回复
这个问题不是很明显吗？连接数据库错误，检查网络，检查数据库链接url，用户名和密码，没什么好说的
解决 The Network Adapter could not establish the connection
The Network Adapter could not establish the connection
Io 异常: The Network Adapter could not establish the connection解决方案
Io 异常: The Network Adapter could not establish the connection解决方案 Io 异常: The Network Adapter could not est...
Io 异常: The Network Adapter could not establish the connection解决方案
Io 异常: The Network Adapter could not establish the connection 这个异常的出现一般与数据库和你的PC的设置有关 这种异常的出现大致上有下面几种： 1。IP错误。 在设置URL时错误，例如：jdbc:oracle:thin:@192.168.0.36:1521:sharp 数据库服务器不正确：ping 服务器IP是否正确。不正
IO 异常：The Network Adapter could not establish the connection
IO 异常：The Network Adapter could not establish the connection 解决方案 这种异常的出现大致上有下面几种： 1。IP错误。 在设置URL时错误，例如：jdbc:oracle:thin:@192.168.1.36:1555:sharp 数据库服务器不正确：ping 服务器IP是否正确。不正确，将URL更改为正确 端口号错误：
IO异常：The Network Adapter could not establish the connection
IO异常：The Network Adapter could not establish the connection
Java EE

67,512

社区成员

225,880

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章