search

ParadoxHacker / jfox

Automatically exported from code.google.com/p/jfox
0 stars 0 forks source link

the jpa connection is not release? #2

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
when i deploy jfox 3.1 to apache tomcat 5.5.23, and install petstore, after
running about 5 minuts, there throw some "too many connections" exception.

i wandor if the jfox's jpa have any bug or my persistent config wrong?
my persistent config:
=====================
 <persistence-unit name="JPetstoreMysqlDS">
        <jta-data-source>java:/JPetstoreMysqlDS</jta-data-source>
        <properties>
            <property name="driver" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/jfoxps"/>
            <property name="username" value="jfoxps"/>
            <property name="password" value="jfoxps"/>
            <property name="minSize" value="1"/>
            <!-- min pool size -->
            <property name="maxSize" value="200"/>
            <!-- max pool size -->
            <property name="lifeTime" value="1800000"/>
            <!-- 3h, connection max idle time, in ms -->
            <property name="sleepTime" value="600000"/>
            <!--PoolKeeper sleep time, in ms -->
            <property name="deadLockRetryWait" value="2000"/>
            <!-- retry time if no free connection, in ms -->
            <property name="deadLockMaxWait" value="60000"/>
            <!-- max wait time if no free connection, in ms -->
            <property name="checkLevelObject" value="4"/>
            <!-- check connection closed -->
            <property name="cache.algorithm" value="LRU"/>
            <!-- algorithm for "default" cache category, LRU, LFU, FIFO-->
            <property name="cache.ttl" value="600000"/>
            <!-- ttl for "default", in ms-->
            <property name="cache.maxIdleTime" value="300000"/>
            <!-- maxidletime for "default", in ms-->
            <property name="cache.maxSize" value="1000"/>
            <!-- max size for "default" -->
            <property name="cache.maxMemorySize" value="100000000"/>
            <!-- max memory size for "default", in bytes-->
        </properties>
    </persistence-unit>

Original issue reported on code.google.com by tanbam...@gmail.com on 28 Feb 2008 at 8:40

GoogleCodeExporter commented 8 years ago 
the log info:
=====================
HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from
fulfilling this request.

exception

javax.servlet.ServletException: Invoke method
org.jfox.petstore.action.OrderAction.execute failed, ComponentId is ComponentId 
{order}
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:216)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

org.jfox.framework.component.ComponentInvocationException: Invoke method
org.jfox.petstore.action.OrderAction.execute failed, ComponentId is ComponentId 
{order}
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:30)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

org.jfox.framework.component.ComponentInvocationException: Invoke method
org.jfox.ejb3.SimpleEJB3Container.invokeEJB failed, ComponentId is ComponentId
{EJB3Container}
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:30)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy97.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy98.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.action.OrderAction.doGetList(OrderAction.java:201)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.mvc.ActionSupport.execute(ActionSupport.java:155)
    sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

org.jfox.framework.component.ComponentInvocationException: Invoke method
org.jfox.ejb3.SimpleEJB3Container.invokeEJB failed, ComponentId is ComponentId
{EJB3Container}
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:30)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy85.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy86.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.bo.OrderBOImpl.getOrdersByUsername(OrderBOImpl.java:40)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy97.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy98.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.action.OrderAction.doGetList(OrderAction.java:201)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.mvc.ActionSupport.execute(ActionSupport.java:155)
    sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.persistence.PersistenceException: SQLQuery.getResultList exception.
    org.jfox.entity.SQLQuery.getResultList(SQLQuery.java:153)
    org.jfox.petstore.dao.OrderDAOImpl.getOrdersByUsername(OrderDAOImpl.java:192)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy85.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy86.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.bo.OrderBOImpl.getOrdersByUsername(OrderBOImpl.java:40)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy97.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy98.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.action.OrderAction.doGetList(OrderAction.java:201)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.mvc.ActionSupport.execute(ActionSupport.java:155)
    sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection
exception: java.sql.SQLException: SQLException in
StandardPoolDataSource:getConnection no connection available 
java.sql.SQLException:
Cannot get connection for URL jdbc:mysql://localhost:3306/jfoxps : Too many 
connections
    org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:213)
    org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
    org.jfox.entity.EntityManagerImpl.getConnection(EntityManagerImpl.java:44)
    org.jfox.entity.SQLQuery.buildPreparedStatement(SQLQuery.java:244)
    org.jfox.entity.SQLQuery.getResultList(SQLQuery.java:125)
    org.jfox.petstore.dao.OrderDAOImpl.getOrdersByUsername(OrderDAOImpl.java:192)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy85.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy86.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.bo.OrderBOImpl.getOrdersByUsername(OrderBOImpl.java:40)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy97.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy98.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.action.OrderAction.doGetList(OrderAction.java:201)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.mvc.ActionSupport.execute(ActionSupport.java:155)
    sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no
connection available java.sql.SQLException: Cannot get connection for URL
jdbc:mysql://localhost:3306/jfoxps : Too many connections
    org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:204)
    org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPoolDataSource.java:164)
    org.jfox.entity.EntityManagerImpl.getConnection(EntityManagerImpl.java:44)
    org.jfox.entity.SQLQuery.buildPreparedStatement(SQLQuery.java:244)
    org.jfox.entity.SQLQuery.getResultList(SQLQuery.java:125)
    org.jfox.petstore.dao.OrderDAOImpl.getOrdersByUsername(OrderDAOImpl.java:192)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy85.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy86.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.bo.OrderBOImpl.getOrdersByUsername(OrderBOImpl.java:40)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.ejb3.interceptor.BusinessInterceptorMethod.invoke(BusinessInterceptorMethod.java:28)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler$1.proceed(InterceptorsEJBInvocationHandler.java:63)
    org.jfox.ejb3.invocation.InterceptorsEJBInvocationHandler.invoke(InterceptorsEJBInvocationHandler.java:67)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.TransactionEJBInvocationHandler.invoke(TransactionEJBInvocationHandler.java:120)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.SecurityEJBInvocationHandler.invoke(SecurityEJBInvocationHandler.java:55)
    org.jfox.ejb3.EJBInvocationHandler.next(EJBInvocationHandler.java:30)
    org.jfox.ejb3.invocation.ThreadContextEJBInvocationHandler.invoke(ThreadContextEJBInvocationHandler.java:28)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJBInvocation(SimpleEJB3Container.java:364)
    org.jfox.ejb3.SimpleEJB3Container.invokeEJB(SimpleEJB3Container.java:325)
    sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy97.invokeEJB(Unknown Source)
    org.jfox.ejb3.SessionBucket$ProxyStubInvocationHandler.invoke(SessionBucket.java:645)
    $Proxy98.getOrdersByUsername(Unknown Source)
    org.jfox.petstore.action.OrderAction.doGetList(OrderAction.java:201)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.mvc.ActionSupport.execute(ActionSupport.java:155)
    sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.jfox.framework.invoker.ReflectComponentInvoker.invokeMethod(ReflectComponentInvoker.java:27)
    org.jfox.framework.component.ProxyReferenceFactory$1.invoke(ProxyReferenceFactory.java:75)
    $Proxy245.execute(Unknown Source)
    org.jfox.mvc.WebContextLoader.invokeAction(WebContextLoader.java:197)
    org.jfox.mvc.servlet.ControllerServlet.forwardAction(ControllerServlet.java:201)
    org.jfox.mvc.servlet.ControllerServlet.service(ControllerServlet.java:100)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache 
Tomcat/5.5.23
logs.

Original comment by tanbam...@gmail.com on 28 Feb 2008 at 8:47