Jboss服务器报这样的错

Question

我使用的是Struts1+hibernate3.2+spring,jdk1.5.
但是运行一天时间就出现错误,获取不到连接.报的错误如下.

Answer 1

2013-08-24 16:57:08,550 INFO  [STDOUT] 2013-08-24 16:57:08,550 INFO [com.baosight.baosteel.cas.server.sso.struts.action.LoginCheckAciton] - loginName:ftv1225
2013-08-24 16:57:08,550 INFO  [STDOUT] 2013-08-24 16:57:08,550 INFO [com.baosight.baosteel.cas.server.sso.struts.action.LoginCheckAciton] - logCount:0
2013-08-24 16:57:08,550 INFO  [STDOUT] 2013-08-24 16:57:08,550 INFO [com.baosight.baosteel.cas.server.sso.struts.action.LoginCheckAciton] - leastNeedShowCodeCount:3
2013-08-24 16:57:11,218 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:516)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:293)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:226)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:169)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:169)
at $Proxy88.isExistUserNo(Unknown Source)
at com.baosight.baosteel.cas.server.sso.struts.action.LoginAdAciton.execute(LoginAdAciton.java:143)
at com.baosight.web.struts.BAction.execute(BAction.java:65)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.baosight.web.filter.ChangeCharsetFilter.doFilter(ChangeCharsetFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
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:802)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:172)
... 50 more
2013-08-24 16:57:11,227 INFO  [STDOUT] 2013-08-24 16:57:11,227 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: null
2013-08-24 16:57:11,227 INFO  [STDOUT] 2013-08-24 16:57:11,227 ERROR [org.hibernate.util.JDBCExceptionReporter] - Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection))
2013-08-24 16:57:11,227 INFO  [STDOUT] 2013-08-24 16:57:11,227 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: null
2013-08-24 16:57:11,227 INFO  [STDOUT] 2013-08-24 16:57:11,227 ERROR [org.hibernate.util.JDBCExceptionReporter] - Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection))
2013-08-24 16:57:11,227 INFO  [STDOUT] 2013-08-24 16:57:11,227 WARN [org.apache.struts.action.RequestProcessor] - Unhandled Exception thrown: class org.springframework.transaction.CannotCreateTransactionException
2013-08-24 16:57:11,227 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/wf_cas].[action]] Servlet.service() for servlet action threw exception
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Answer 2

24 16:57:11,218 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null这一步为什么运行一段时间突然获取不到连接了.

Answer 3

应该是少驱动了。你丢一个oracle的驱动包进去，好像需要oracle驱动包

Answer 4

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
1 首先你是怎么样配置数据源的，deploy下面**-ds.xml配置的？，配置的数据库你ping的通吗？
2 以上的错误就是包网卡不能连接数据库，请先确认一下。

Answer 5

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
1 首先你是怎么样配置数据源的，deploy下面**-ds.xml配置的？，配置的数据库你ping的通吗？
2 以上的错误就是包网卡不能连接数据库，请先确认一下。
<datasources>
<local-tx-datasource>
  <jndi-name>test</jndi-name> 
 <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:efesco</connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 
  <!--<user-name>uup</user-name> 
  <password>uup2012</password> -->
  <user-name>test</user-name> 
  <password>test</password>
  <connection-property name="char.encoding">GBK</connection-property> 
  <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> 
  <min-pool-size>1</min-pool-size> 
  <max-pool-size>30</max-pool-size> 
  <blocking-timeout-millis>60000</blocking-timeout-millis> 
  <idle-timeout-minutes>50</idle-timeout-minutes> 
  <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> 
</local-tx-datasource>
</datasources>

Answer 6

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
1 首先你是怎么样配置数据源的，deploy下面**-ds.xml配置的？，配置的数据库你ping的通吗？
2 以上的错误就是包网卡不能连接数据库，请先确认一下。
使用的是jndi配置数据源

Answer 7

spring的配置: <bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:bsteel.properties</value>
</list>
</property>
</bean>
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="${jdbc.datasource}" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingDirectoryLocations">
<list>
<value>
hibernate3/
</value>
</list>
</property>
<property name="mappingLocations">
<value>
com/bsteel/application/supply/hibernate/Customer.hbm.xml
</value>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${hibernate.dialect}
</prop>
<prop key="hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider
</prop>
<prop key="hibernate.cache.use_minimal_puts">true</prop>
<prop key="hibernate.max_fetch_depth">2</prop>
<prop key="hibernate.show_sql">true</prop>
<prop
key="hibernate.bytecode.use_reflection_optimizer">
true
</prop> </props>
</property>
</bean> <!-- Transaction manager for a single Hibernate SessionFactory  -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean> <bean id="baseTransactionProxy"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="transactionAttributes">
<props>
<prop key="*">
PROPAGATION_REQUIRED,ISOLATION_DEFAULT,timeout_3000,-Exception
</prop>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="submitUpdatePersonInfo">PROPAGATION_NOT_SUPPORTED,-Exception</prop>
<prop key="submitRegisterSecondStep">PROPAGATION_NOT_SUPPORTED,-Exception</prop>
<prop key="get*">PROPAGATION_REQUIRED,readOnly,-Exception</prop>
<prop key="query*">PROPAGATION_REQUIRED,readOnly,-Exception</prop>
<prop key="list*">PROPAGATION_REQUIRED,readOnly,-Exception</prop>
</props>
</property>
</bean>

Answer 8

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
1 首先你是怎么样配置数据源的，deploy下面**-ds.xml配置的？，配置的数据库你ping的通吗？
2 以上的错误就是包网卡不能连接数据库，请先确认一下。
使用的是jndi配置数据源<property name="jndiName" value="${jdbc.datasource}" />真正的数据源的配置是在jboss/server/default/deploy/**-ds.xml这个文件中配置，发布以后它可以以jndi的方式进行查找。所以spring中其实是引用的这里的数据源。
你去找一下jboss/server/default/deploy/下面的**-ds.xml，看看有没有这个配置。

Answer 9

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
1 首先你是怎么样配置数据源的，deploy下面**-ds.xml配置的？，配置的数据库你ping的通吗？
2 以上的错误就是包网卡不能连接数据库，请先确认一下。
使用的是jndi配置数据源<property name="jndiName" value="${jdbc.datasource}" />真正的数据源的配置是在jboss/server/default/deploy/**-ds.xml这个文件中配置，发布以后它可以以jndi的方式进行查找。所以spring中其实是引用的这里的数据源。
你去找一下jboss/server/default/deploy/下面的**-ds.xml，看看有没有这个配置。
这个刚刚开始的时候运行没有问题,运行几天了才出现这样的问题,我现在怀疑有可能是网络的原因.

Answer 10

The Network Adapter could not establish the connection1 确认数据库ip能不能ping通
2 数据库端口是否打开
3 数据库客户端是否能登录

Answer 11

The Network Adapter could not establish the connection    这个服务器数据库关了，或者网络问题