Re: cannot obtain connection

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Apr 05 2005 - 09:39:59 EDT

  • Next message: Dhruti Ramani: "Having two relationships between same two tables"

    Hi Tomislav,

    Looks like your application load requires more than one connection in the
    pool ... or maybe you just have long running queries, so timeouts can
    occur even on light loads.

    Just change the maximum number of connections for the DataNode to a higher
    value in this dialog:

    http://objectstyle.org/cayenne/images/modelerguide/datanode.jpg

    Andrus

    > Hi,
    >
    > does anyone have any idea why I get the exception below on a (seemingly)
    > random basis? Maybe someone can interpret the stack trace...better than
    > I can, anyway.
    >
    > TIA,
    > Tomislav
    >
    > An exception has occurred.
    >
    > You may continue by restarting the session.
    >
    > org.apache.tapestry.ApplicationRuntimeException
    > Unable to invoke method priPrihvati on
    > netgen.anketa.sucelje.Home$Enhance_53..3c7b1[Home]: [v.1.2M1 November
    > 21 2004] Commit Exception
    >
    > org.objectstyle.cayenne.CayenneRuntimeException
    > [v.1.2M1 November 21 2004] Commit Exception
    > unlabeledMessage: Commit Exception
    >
    > java.sql.SQLException
    > Can't obtain connection. Request timed out. Total used connections: 1
    > errorCode: 0
    > Stack Trace:
    >
    > *
    > org.objectstyle.cayenne.conn.PoolManager.uncheckPooledConnection(PoolManager.java:466)
    > *
    > org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:392)
    > *
    > org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:385)
    > *
    > org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:313)
    > *
    > org.objectstyle.cayenne.access.ContextCommit.commit(ContextCommit.java:192)
    > *
    > org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1266)
    > *
    > org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1236)
    > * netgen.anketa.sucelje.Home.priPrihvati(Home.java:114)
    > * sun.reflect.GeneratedMethodAccessor375.invoke(Unknown Source) *
    > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    > * java.lang.reflect.Method.invoke(Method.java:585)
    > *
    > org.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMap.java:257)
    > *
    > org.apache.tapestry.listener.ListenerMap.access$100(ListenerMap.java:46)
    > *
    > org.apache.tapestry.listener.ListenerMap$SyntheticListener.invoke(ListenerMap.java:97)
    > *
    > org.apache.tapestry.listener.ListenerMap$SyntheticListener.actionTriggered(ListenerMap.java:102)
    > * org.apache.tapestry.form.Submit.renderComponent(Submit.java:80) *
    > org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
    > *
    > org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
    > *
    > org.apache.tapestry.components.Conditional.renderComponent(Conditional.java:56)
    > *
    > org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
    > *
    > org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
    > * org.apache.tapestry.form.Form.renderComponent(Form.java:362) *
    > org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
    > * org.apache.tapestry.form.Form.rewind(Form.java:568)
    > *
    > org.apache.tapestry.engine.RequestCycle.rewindForm(RequestCycle.java:432)
    > * org.apache.tapestry.form.Form.trigger(Form.java:582)
    > *
    > org.apache.tapestry.engine.DirectService.service(DirectService.java:169)
    > *
    > org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:872)
    > *
    > org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:197)
    > *
    > org.apache.tapestry.ApplicationServlet.doPost(ApplicationServlet.java:326)
    > * javax.servlet.http.HttpServlet.service(HttpServlet.java:709) *
    > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) *
    > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    > *
    > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    > *
    > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    > *
    > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    > *
    > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    > *
    > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    > *
    > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    > *
    > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    > *
    > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
    > *
    > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
    > *
    > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
    > *
    > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    > *
    > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    > * java.lang.Thread.run(Thread.java:595)

    This archive was generated by hypermail 2.0.0 : Tue Apr 05 2005 - 09:40:01 EDT