关于WAS连接数据库超时的问题 求大神

问题描述

CST]00000030SystemOutOselectHTIP.STORAGER_STATUS.DATA_TAG,HTIP.STORAGER_STATUS.RECEIVE_TIME,HTIP.STORAGER_STATUS.STATUS,HTIP.STORAGER_STATUS.SERVICE_RECEIVEfromHTIP.STORAGER_STATUS,HTIP.DATA_STORAGERwhereHTIP.STORAGER_STATUS.STATUS='01'andHTIP.STORAGER_STATUS.STATUS_TIME<'2014-09-1116:47:23:580'ANDHTIP.STORAGER_STATUS.STATUS_TIME>'2014-09-1111:57:23:580'andHTIP.STORAGER_STATUS.DATA_TAG=HTIP.DATA_STORAGER.DATA_TAG[14-9-1116:57:23:799CST]0000002eSystemOutO2014-09-1116:57:23.79943db43dbI:取值~~~~~~~~~~~~~~~~~~~~11[14-9-1116:57:23:799CST]0000002eSystemOutO2014-09-1116:57:23.79943db43dbI:[DBOperator(22862286)]Connectionopenedin0.170304ms[14-9-1116:57:23:799CST]0000002eSystemOutO2014-09-1116:57:23.79943db43dbI:conn:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@22862286[14-9-1116:57:23:799CST]0000002eSystemOutO2014-09-1116:57:23.79943db43dbI:makingaconnection...[349][14-9-1116:57:41:988CST]0000002dConnectionEveWJ2CA0206W:发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。[14-9-1116:57:41:988CST]0000002dConnectionEveAJ2CA0056I:连接管理器从资源HTIPpool的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException:Io异常:Socketreadtimedout[14-9-1116:57:41:988CST]0000002dWSRdbManagedCWDSRA0180W:在ManagedConnection.destroy()期间检测到异常。异常：com.ibm.ws.exception.WsException:DSRA0080E:AnexceptionwasreceivedbytheDataStoreAdapter.Seeoriginalexceptionmessage:关闭的连接.withSQLState:99999SQLCode:17008atoracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)atoracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)atoracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)atoracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)atcom.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)atcom.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)atcom.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)atcom.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)atcom.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)atcom.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)atcom.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)atcom.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)atcom.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)atcom.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)atcom.haitaiinc.change.service.dao.StoragerStatusDAO.getAlreadySendData(StoragerStatusDAO.java:391)atcom.haitaiinc.change.service.send.SendExceptionAction.getAlreadySendData(SendExceptionAction.java:92)atcom.haitaiinc.change.service.thread.AlreadySendThread.alreadySend(AlreadySendThread.java:44)atcom.haitaiinc.change.service.thread.AlreadySendThread.run(AlreadySendThread.java:21)Causedby:java.sql.SQLException:关闭的连接DSRA0010E:SQL状态：99999，错误码：17,008。...26more[14-9-1116:57:42:519CST]00000030ConnectionEveWJ2CA0206W:发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。[14-9-1116:57:42:519CST]00000030ConnectionEveAJ2CA0056I:连接管理器从资源HTIPpool的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException:Io异常:Socketreadtimedout[14-9-1116:57:42:519CST]00000030WSRdbManagedCWDSRA0180W:在ManagedConnection.destroy()期间检测到异常。异常：com.ibm.ws.exception.WsException:DSRA0080E:AnexceptionwasreceivedbytheDataStoreAdapter.Seeoriginalexceptionmessage:关闭的连接.withSQLState:99999SQLCode:17008atoracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)atoracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)atoracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)atoracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)atcom.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)atcom.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)atcom.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)atcom.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)atcom.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)atcom.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)atcom.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)atcom.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)atcom.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)atcom.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)atcom.haitaiinc.change.service.dao.StoragerStatusDAO.getWaitData(StoragerStatusDAO.java:305)atcom.haitaiinc.change.service.send.SendExceptionAction.getWaitData(SendExceptionAction.java:71)atcom.haitaiinc.change.service.thread.WaitSendThread.waitSend(WaitSendThread.java:44)atcom.haitaiinc.change.service.thread.WaitSendThread.run(WaitSendThread.java:21)Causedby:java.sql.SQLException:关闭的连接DSRA0010E:SQL状态：99999，错误码：17,008。...26more[14-9-1116:57:42:737CST]0000002eConnectionEveWJ2CA0206W:发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。[14-9-1116:57:42:737CST]0000002eConnectionEveAJ2CA0056I:连接管理器从资源HTIPpool的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException:Io异常:Socketreadtimedout[14-9-1116:57:42:737CST]0000002eWSRdbManagedCWDSRA0180W:在ManagedConnection.destroy()期间检测到异常。异常：com.ibm.ws.exception.WsException:DSRA0080E:AnexceptionwasreceivedbytheDataStoreAdapter.Seeoriginalexceptionmessage:关闭的连接.withSQLState:99999SQLCode:17008atoracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)atoracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)atoracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)atoracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)atcom.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)atcom.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)atcom.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)atcom.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)atcom.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)atcom.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)atcom.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)atcom.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)atcom.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)atcom.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)atcom.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)atcom.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)atcom.haitaiinc.change.service.dao.StoragerStatusDAO.getFailData(StoragerStatusDAO.java:519)atcom.haitaiinc.change.service.send.SendExceptionAction.getFailData(SendExceptionAction.java:131)atcom.haitaiinc.change.service.thread.FailSendThread.failSend(FailSendThread.java:45)atcom.haitaiinc.change.service.thread.FailSendThread.run(FailSendThread.java:21)Causedby:java.sql.SQLException:关闭的连接DSRA0010E:SQL状态：99999，错误码：17,008。...26more

解决方案

解决方案二：
自己顶！！！！！！

时间： 2024-11-01 00:05:49

关于WAS连接数据库超时的问题 求大神的相关文章

aspx.cs连接数据库的问题，求大神

问题描述 usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.Data.SqlClient;publicpartialclassDefault2:System.Web.UI.Page{protectedvoidadd_Click(objec

java-谷歌面试题，求大神帮忙

问题描述 谷歌面试题,求大神帮忙 原题是这样的(后面我补充了中文解释): Don't mind the map After the trauma of Dr. Boolean's lab, the rabbits are eager to get back to their normal lives in a well-connected community, where they can visit each other frequently. Fortunately, the rabbits

javascript-JS中if else问题。求大神分析，跪求

问题描述 JS中if else问题.求大神分析,跪求 shuifen 是页面输入的值:glmin=14:glmax=35:glbiaozhun=14:glbiaozhunjia=1.065:gljiagebodong=0.013: 下面一段JS代码:为什么else{}里的没执行呢?求大神分析. if(parseFloat(shuifen)>=parseFloat(glmin)&&parseFloat(shuifen)<=glmax ){ danjia =glbiaozhunji

ado连接sql数据库-求大神帮忙，ado连接数据库sql server 2005，总是失败

问题描述 求大神帮忙,ado连接数据库sql server 2005,总是失败 #include #include #include #include #import "C:Program FilesCommon FilesSystemadomsado15.dll" no_namespace rename("EOF","ADOEOF") int main() { if(!AfxOleInit()) { AfxMessageBox("ca

超时-c语言求组合数，但是超了，求大神指点！

问题描述 c语言求组合数,但是超了,求大神指点! 我用递归写出了求组合数,c(5,3),c(6,2)之类的能算出来,但是c(1024,512)这种大数就算不出来了,超时很严重,而且取模之后也不行,求大神们指点啊!!谢谢!! 解决方案 它只问多少种,没有让你列出多少种,这是数学问题不是编程问题.直接套公式. 解决方案二: c(1024,512)没有任何算法能做到. C(100, 50)已经达到10^29了,而C(1024,512)几乎是天文数字. 假设计算机每秒能计算1万亿次,每次计算都直接输出一

javvweb 连接数据库出现问题 求大神指教

问题描述 javvweb 连接数据库出现问题 求大神指教 下面是程序代码 <%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+r

求大神帮忙使用netbeans写java连接数据库时Statemnt中没有executeQuery方法

问题描述 求大神帮忙使用netbeans写java连接数据库时Statemnt中没有executeQuery方法 我在使用的netbeans中做数据库连接的时候没有Statemnt中没有executeQuery方法但是有execute方法怎么办是JDK的问题还是netbeans问题?求大神帮助!!!! 解决方案 public interface Statement 中有executeQuery 在java.sql中; public class Statement 这里面是没有executeQue

c语言-新手OJ， C语言 字符串顺序后移模块，超时，优化无思路 求大神对指点

问题描述 新手OJ, C语言 字符串顺序后移模块,超时,优化无思路 求大神对指点 for(i=1; i<=m; i++){ a=z[n]; for(p=&z[n]; p>=&z[2]; p--)p=(p-1); z[1]=a; } ++++++++++++++++++++++++++++++++++++++++ 作用:将数组z[n]中的所有元素进行向右移m位, 多出来的左端补上. 例如: 12345 m=1 变成 51234 但是我的算法效率太低, 当数组很长, m很大时超时,

jdbc连接数据库-JDBC连接数据库，求大神帮解决啊，我怎么也解决不了了。。。

问题描述 JDBC连接数据库,求大神帮解决啊,我怎么也解决不了了... java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680) at org.apache.catalina.loader.WebappClassLoader.loadClass(Web