jboss异常：sql error 17002和sql error 17008
原为行业内业务系统，布署了两套系统，分别采用jboss和weblogic作为服务器，两套系统在同一个物理机器上，使用两个端口。
服务器：weblogic12.1.2 jboss eap6.0
：oracle12(另一个物理机器，两套系统共用)
jboss系统在试运行过程中，会不定时挂掉，经查询jboss日志，当系统挂掉时，会报sql error 17008和sql error 17002的错误，如下：
[html] view plain copy
09:24:41,771 warn [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-/0.0.0.0:8089-11) sql error: 17008, sqlstate: 99999
09:24:41,771 error [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-/0.0.0.0:8089-11) closed connection
09:24:41,771 error [org.jboss.as.ejb3.tx.cmttxinterceptor] (http-/0.0.0.0:8089-11) javax.ejb.ejbtransactionrolledbackexception: org.hibernate.exception.genericjdbcexception: closed connection
09:24:41,772 error [org.jboss.as.ejb3.invocation] (http-/0.0.0.0:8089-11) jbas014134: ejb invocation failed on component jpadaoimpl for method public abstract java.util.list com.xxxx.getobjects(java.lang.string,boolean): javax.ejb.ejbtransactionrolledbackexception: org.hibernate.exception.genericjdbcexception: closed connection
at org.jboss.as.ejb3.tx.cmttxinterceptor.handleincallertx(cmttxinterceptor.java:138) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1]
at org.jboss.as.ejb3.tx.cmttxinterceptor.invokeincallertx(cmttxinterceptor.java:203) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1]
at org.jboss.as.ejb3.tx.cmttxinterceptor.required(cmttxinterceptor.java:305) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1] ……
[html] view plain copy
caused by: javax.persistence.persistenceexception: org.hibernate.exception.genericjdbcexception: closed connection
at org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1372) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1295) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:317) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1] ……
[html] view plain copy
caused by: org.hibernate.exception.genericjdbcexception: closed connection
at org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:54) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1] ……
[html] view plain copy
caused by: java.sql.sqlexception: closed connection
at oracle.jdbc.driver.sqlstatemapping.newsqlexception(sqlstatemapping.java:70)
at oracle.jdbc.driver.databaseerror.newsqlexception(databaseerror.java:133) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:199) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:263) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”] ……[html] view plain copy
09:24:54,605 warn [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-/0.0.0.0:8089-7) sql error: 17002, sqlstate: 08006
09:24:54,605 error [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-/0.0.0.0:8089-7) io exception: connection timed out
09:24:54,606 error [org.jboss.as.ejb3.tx.cmttxinterceptor] (http-/0.0.0.0:8089-7) javax.ejb.ejbtransactionrolledbackexception: org.hibernate.exception.jdbcconnectionexception: io exception: connection timed out
09:24:54,606 error [org.jboss.as.ejb3.invocation] (http-/0.0.0.0:8089-7) jbas014134: ejb invocation failed on component jpadaoimpl for method public abstract java.lang.object com.xxxx.jpa.jpadao.getsingleobject(java.lang.string,java.lang.object[]): javax.ejb.ejbtransactionrolledbackexception: org.hibernate.exception.jdbcconnectionexception: io exception: connection timed out
at org.jboss.as.ejb3.tx.cmttxinterceptor.handleincallertx(cmttxinterceptor.java:138) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1]
at org.jboss.as.ejb3.tx.cmttxinterceptor.invokeincallertx(cmttxinterceptor.java:203) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1]
at org.jboss.as.ejb3.tx.cmttxinterceptor.required(cmttxinterceptor.java:305) [jboss-as-ejb3-7.1.2.final-redhat-1.jar:7.1.2.final-redhat-1] ……[html] view plain copy
caused by: javax.persistence.persistenceexception: org.hibernate.exception.jdbcconnectionexception: io exception: connection timed out
at org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1372) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1295) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.ejb.queryimpl.getresultlist(queryimpl.java:265) [hibernate-entitymanager-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1] ……
[html] view plain copy
caused by: org.hibernate.exception.jdbcconnectionexception: io exception: connection timed out
at org.hibernate.exception.internal.sqlstateconversiondelegate.convert(sqlstateconversiondelegate.java:131) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1]
at org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110) [hibernate-core-4.1.3.final-redhat-1.jar:4.1.3.final-redhat-1] ……[html] view plain copy
caused by: java.sql.sqlrecoverableexception: io exception: connection timed out
at oracle.jdbc.driver.sqlstatemapping.newsqlexception(sqlstatemapping.java:101)
at oracle.jdbc.driver.databaseerror.newsqlexception(databaseerror.java:133) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:199) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:263) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:521) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”] ……
[html] view plain copy
caused by: java.net.socketexception: connection timed out
at java.net.socketinputstream.socketread0(native method) [rt.jar:1.6.0_30]
at java.net.socketinputstream.read(socketinputstream.java:129) [rt.jar:1.6.0_30]
at oracle.net.ns.packet.receive(packet.java:240) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”]
at oracle.net.ns.datapacket.receive(datapacket.java:92) [ojdbc14.jar:oracle jdbc driver version – “10.2.0.3.0”] ……解决办法：[html] view plain copy
jdbc:oracle:thin:@ip地址:1521:orcl
oracle.jdbc.driver.oracledriver
oracle
2
20
true
false
failingconnectiononly
dbusername
dbpassword
oracle.jdbc.xa.client.oraclexadatasource
对数据库连接进行验证。