java.sql.SQLException: Can't obtain connection. Request timed out. Total used connections: 1

From: Mike Kienenberger (mkienen..laska.net)
Date: Thu Mar 04 2004 - 17:37:54 EST

  • Next message: Mike Kienenberger: "Re: java.sql.SQLException: Can't obtain connection. Request timed out. Total used connections: 1"

    Does anyone know what would cause this kind of error?

    I get it when I try to deploy my struts/cayenne application to Oracle
    Application Server, but not when I run it on my development machine using
    Tomcat 4.1.27

    The code called is the following:

                            DataContext aDataContext = DataContext.createDataContext();
                            RestrictingQualifierDataContextDelegate
    restrictingQualifierDataContextDelegate =
    RestrictingQualifierDataContextDelegate.getInstance();
                            aDataContext.setDelegate(restrictingQualifierDataContextDelegate);
                            List localizationList = Localization.getAllObjects(aDataContext,
    Localization.class);

            public static List getAllObjects(DataContext aDataContext, Class aClass)
            {
                    return aDataContext.performQuery(new SelectQuery(aClass));
            }

    -Mike

    cayenne INFO [AJPRequestHandler-ApplicationServerThread-43 03-04 13:19:37]
    QueryLogger: --- will run 1 query.
    cayenne INFO [AJPRequestHandler-ApplicationServerThread-43 03-04 13:19:57]
    QueryLogger: *** error.
    java.sql.SQLException: Can't obtain connection. Request timed out. Total
    used connections: 1
            at
    org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:424)
            at
    org.objectstyle.cayenne.conn.PoolManager.getConnection(PoolManager.java:385)
            at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:297)
            at
    org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:662)
            at
    org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1337)
            at
    org.objectstyle.cayenne.access.Transaction.performQueries(Transaction.java:176)
            at
    org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1260)
            at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:1226)
            at
    com.gvea.cayenne.GenericEntity.getAllObjects(GenericEntity.java:105)
            at com.gvea.struts.utils.Localizer.initialize(Localizer.java:72)
            at com.gvea.struts.utils.Localizer.getInstance(Localizer.java:47)
            at
    com.gvea.struts.utils.DatabaseMessageResources.getMessage(DatabaseMessageResources.java:58)
            at
    org.apache.struts.validator.Resources.getMessage(Resources.java:178)
            at org.apache.struts.validator.Resources.getArgs(Resources.java:251)
            at
    org.apache.struts.validator.Resources.getMessage(Resources.java:206)
            at
    org.apache.velocity.tools.struts.ValidatorTool.getDynamicJavascript(ValidatorTool.java:503)
            at
    org.apache.velocity.tools.struts.ValidatorTool.getJavascript(ValidatorTool.java:422)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at
    org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:260)
            at
    org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:207)
            at
    org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:250)
            at
    org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:271)
            at
    org.apache.velocity.runtime.directive.Parse.render(Parse.java:232)
            at
    org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:153)
            at
    org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94)
            at
    org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:109)
            at
    org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:271)
            at org.apache.velocity.Template.merge(Template.java:296)
            at
    org.apache.velocity.tools.view.servlet.VelocityLayoutServlet.mergeTemplate(VelocityLayoutServlet.java:253)
            at
    org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityViewServlet.java:455)
            at
    org.apache.velocity.tools.view.servlet.VelocityViewServlet.doGet(VelocityViewServlet.java:411)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at
    com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
            at
    com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
            at
    com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:220)
            at
    org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
            at
    org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
            at
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
            at
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at
    org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at
    com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
            at
    com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
            at
    com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:220)
            at
    org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
            at
    org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1012)
            at
    org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:582)
            at
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:260)
            at
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
            at
    org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at
    com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
            at
    com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
            at
    com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:220)
            at
    com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:224)
            at
    org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:170)
            at _index._jspService(_index.java:54)
            at
    com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
            at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:347)
            at
    oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
            at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
            at
    com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
            at
    com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
            at
    com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
            at
    com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:208)
            at
    com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
            at
    com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
            at java.lang.Thread.run(Thread.java:534)



    This archive was generated by hypermail 2.0.0 : Thu Mar 04 2004 - 17:37:04 EST