wood burning stoves*
The moose likes Struts and the fly likes Connection Timedout Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Connection Timedout Exception" Watch "Connection Timedout Exception" New topic
Author

Connection Timedout Exception

thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
What could be the cause of this error?

esidual_billing][AccountInfoDAO][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountDetailsList(ProjPk projPk) ends
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountsList(form)
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][GlobalParamContext][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method strats here
[residual_billing][ConnectionMgr][02/25 12:22:50.811][INFO][Severity 4] [] Method Starts Here
[residual_billing][GlobalParamContext][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method ends here
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8843
    
    7

I can't tell you with what you've given us.
What are you trying to connect to?
Do you have a stack trace?
The code where the error occurs?


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
Using WAS 6.0.2,DB2 and struts.Trying to connect to DB2 using JDBC.It keeps on throwing Connection Timeout Exception

Only 3 concurrent users for pilot run and 10 connections are allocated in connection pool of WAS.Using SessionDB for Session management of WAS.


There are two errors

1)SESN0040E: BackedHashtable:commonSetup - problem streaming object

2)com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000

1)2/21/08 7:54:08:751 GMT] 00000cbc LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
[2/21/08 7:54:08:785 GMT] 00000cbc LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment.
[2/21/08 7:54:12:633 GMT] 000000ae SessionContex E SESN0040E: BackedHashtable:commonSetup - problem streaming object. Exception caught while trying to serialize session data for subsequent database write. The session data may be too large to serialize. Either put less data in the session or consider configuring Session Manager for MultiRow database mode.


2)[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.ViewProjDAO.getProjInfo(ViewProjDAO.java:69)
at services.in.gdbilling.cc.helper.LogonHelper.createRBUser(LogonHelper.java:272)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
[
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
Connection Timeout Error is hitting everywhere.I can not tell one place where it is going to hit.Users are complaining this error in different screens and places.It is very difficult to pinpoint the place where it throws this error.
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
00000337 LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
00000337 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled

Needs to following things
From Database
these are the apps currently connected:

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
can whittle down the list of those app ids that are in lock wait, and those that are not,
and we can try purging the ones that you deem least likely to cause issues... the ones in
UOW status (idle) can usually be purged
Get lock snapshot , so that we can pin point why is this happening

while you're reading through that snaplock - I found another UOW thread - 885, it also has one X lock will check that after this force hmmm, looks like 932 is gone now
Paul can you please tell us what is LOCKTIMEOUT value?
can you please tell us what is LOCKTIMEOUT value
db2 get db cfg | grep LOCK
LOCKTIMEOUT=-1
db2 get db cfg for RESBILL |grep LOCK
Max storage for lock list (4KB) (LOCKLIST) = 100
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = -1


what enterprising soul set that value, I wonder? no wonder all those apps are just sitting there lockwaiting

Needs to find out Lock Wait
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Timedout Exception
 
Similar Threads
Connection Wait Timeout Exception:
Server boot time issue
issue while using struts-core-1.3.5
please help in setting db connection in jboss
Newbie to JBoss