users@glassfish.java.net

RE: RE: RE: Re: SQLException does not drop JDBC connection from pool

From: Markus Karg <karg_at_quipsy.de>
Date: Wed, 15 Oct 2008 14:11:32 +0200

These are the only stack traces:

[#|2008-10-13T08:48:21.845+0200|WARNING|sun-appserver9.1|oracle.toplink.
essentials.session.file:/C:/Programme/glassfish/domains/domain1/applicat
ions/j2ee-apps/SuperSimple/SuperSimple_jar/-QUIPSY|_ThreadID=37;_ThreadN
ame=p: thread-pool-1; w:
42;_RequestID=dba6dd82-56b7-4d6c-8f20-5ec3c278e9f6;|
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build
b04-fcs (04/11/2008))):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
Error Code: -660
Call: SELECT DISTINCT Text FROM VBFert
Query:
ReportQuery(de.quipsy.persistency.manufacturingMethod.ManufacturingMetho
d)
        at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(Data
baseException.java:319)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:566)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.execu
teCall(DatabaseAccessor.java:452)
        at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSess
ion.java:473)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:228)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:214)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeSelectCall(DatasourceCallQueryMechanism.java:285)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.selectAllRows(DatasourceCallQueryMechanism.java:615)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllRowsFromTable(ExpressionQueryMechanism.java:2416)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllReportQueryRows(ExpressionQueryMechanism.java:2382)
        at
oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuer
y(ReportQuery.java:802)
        at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQ
uery.java:628)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(Ob
jectLevelReadQuery.java:692)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInU
nitOfWork(ObjectLevelReadQuery.java:746)
        at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecu
teQuery(UnitOfWorkImpl.java:2233)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:952)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:924)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeRea
dQuery(EJBQueryImpl.java:367)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultL
ist(EJBQueryImpl.java:478)
        at
de.quipsy.application.complaint.manufacturingMethodManager.Manufacturing
MethodManagerBean.getNames(ManufacturingMethodManagerBean.java:122)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJB
SecurityManager.java:1067)
        at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
        at
com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContaine
r.java:2895)
        at
com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:203)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:120)
        at $Proxy98.getNames(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveT
ie.java:154)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
ToServant(CorbaServerRequestDispatcherImpl.java:687)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
(CorbaServerRequestDispatcherImpl.java:227)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestReq
uest(CorbaMessageMediatorImpl.java:1846)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:1706)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(Corb
aMessageMediatorImpl.java:1088)
        at
com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callbac
k(RequestMessage_1_2.java:223)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:806)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMe
ssageMediatorImpl.java:563)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMess
ageMediatorImpl.java:2567)
        at
com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
(ThreadPoolImpl.java:555)
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
        at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
        at ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:430)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:535)
        ... 44 more
|#]

[#|2008-10-13T08:48:21.908+0200|INFO|sun-appserver9.1|javax.enterprise.s
ystem.container.ejb|_ThreadID=37;_ThreadName=p: thread-pool-1; w:
42;ManufacturingMethodManagerBean;|EJB5018: An exception was thrown
during an ejb invocation on [ManufacturingMethodManagerBean]|#]

[#|2008-10-13T08:48:21.908+0200|INFO|sun-appserver9.1|javax.enterprise.s
ystem.container.ejb|_ThreadID=37;_ThreadName=p: thread-pool-1; w: 42;|
javax.ejb.EJBException
        at
com.sun.ejb.containers.BaseContainer.processSystemException(BaseContaine
r.java:3869)
        at
com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:37
69)
        at
com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:357
1)
        at
com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
        at
com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:210)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:120)
        at $Proxy98.getNames(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveT
ie.java:154)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
ToServant(CorbaServerRequestDispatcherImpl.java:687)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
(CorbaServerRequestDispatcherImpl.java:227)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestReq
uest(CorbaMessageMediatorImpl.java:1846)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:1706)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(Corb
aMessageMediatorImpl.java:1088)
        at
com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callbac
k(RequestMessage_1_2.java:223)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:806)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMe
ssageMediatorImpl.java:563)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMess
ageMediatorImpl.java:2567)
        at
com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
(ThreadPoolImpl.java:555)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1
(Build b04-fcs (04/11/2008))):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
Error Code: -660
Call: SELECT DISTINCT Text FROM VBFert
Query:
ReportQuery(de.quipsy.persistency.manufacturingMethod.ManufacturingMetho
d)
        at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(Data
baseException.java:319)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:566)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.execu
teCall(DatabaseAccessor.java:452)
        at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSess
ion.java:473)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:228)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:214)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeSelectCall(DatasourceCallQueryMechanism.java:285)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.selectAllRows(DatasourceCallQueryMechanism.java:615)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllRowsFromTable(ExpressionQueryMechanism.java:2416)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllReportQueryRows(ExpressionQueryMechanism.java:2382)
        at
oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuer
y(ReportQuery.java:802)
        at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQ
uery.java:628)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(Ob
jectLevelReadQuery.java:692)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInU
nitOfWork(ObjectLevelReadQuery.java:746)
        at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecu
teQuery(UnitOfWorkImpl.java:2233)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:952)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:924)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeRea
dQuery(EJBQueryImpl.java:367)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultL
ist(EJBQueryImpl.java:478)
        at
de.quipsy.application.complaint.manufacturingMethodManager.Manufacturing
MethodManagerBean.getNames(ManufacturingMethodManagerBean.java:122)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJB
SecurityManager.java:1067)
        at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
        at
com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContaine
r.java:2895)
        at
com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:203)
        ... 17 more
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
        at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
        at ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:430)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:535)
        ... 44 more
|#]

[#|2008-10-13T08:48:22.923+0200|WARNING|sun-appserver9.1|oracle.toplink.
essentials.session.file:/C:/Programme/glassfish/domains/domain1/applicat
ions/j2ee-apps/SuperSimple/SuperSimple_jar/-QUIPSY|_ThreadID=38;_ThreadN
ame=p: thread-pool-1; w:
41;_RequestID=cafcaf83-757c-4951-a06a-cc80ba2382d6;|
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build
b04-fcs (04/11/2008))):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
Error Code: -660
Call: SELECT DISTINCT Text FROM VBFert
Query:
ReportQuery(de.quipsy.persistency.manufacturingMethod.ManufacturingMetho
d)
        at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(Data
baseException.java:319)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:566)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.execu
teCall(DatabaseAccessor.java:452)
        at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSess
ion.java:473)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:228)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:214)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeSelectCall(DatasourceCallQueryMechanism.java:285)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.selectAllRows(DatasourceCallQueryMechanism.java:615)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllRowsFromTable(ExpressionQueryMechanism.java:2416)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllReportQueryRows(ExpressionQueryMechanism.java:2382)
        at
oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuer
y(ReportQuery.java:802)
        at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQ
uery.java:628)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(Ob
jectLevelReadQuery.java:692)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInU
nitOfWork(ObjectLevelReadQuery.java:746)
        at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecu
teQuery(UnitOfWorkImpl.java:2233)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:952)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:924)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeRea
dQuery(EJBQueryImpl.java:367)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultL
ist(EJBQueryImpl.java:478)
        at
de.quipsy.application.complaint.manufacturingMethodManager.Manufacturing
MethodManagerBean.getNames(ManufacturingMethodManagerBean.java:122)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJB
SecurityManager.java:1067)
        at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
        at
com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContaine
r.java:2895)
        at
com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:203)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:120)
        at $Proxy98.getNames(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveT
ie.java:154)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
ToServant(CorbaServerRequestDispatcherImpl.java:687)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
(CorbaServerRequestDispatcherImpl.java:227)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestReq
uest(CorbaMessageMediatorImpl.java:1846)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:1706)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(Corb
aMessageMediatorImpl.java:1088)
        at
com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callbac
k(RequestMessage_1_2.java:223)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:806)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMe
ssageMediatorImpl.java:563)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMess
ageMediatorImpl.java:2567)
        at
com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
(ThreadPoolImpl.java:555)
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
        at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
        at ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:430)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:535)
        ... 44 more
|#]

[#|2008-10-13T08:48:22.923+0200|INFO|sun-appserver9.1|javax.enterprise.s
ystem.container.ejb|_ThreadID=38;_ThreadName=p: thread-pool-1; w:
41;ManufacturingMethodManagerBean;|EJB5018: An exception was thrown
during an ejb invocation on [ManufacturingMethodManagerBean]|#]

[#|2008-10-13T08:48:22.923+0200|INFO|sun-appserver9.1|javax.enterprise.s
ystem.container.ejb|_ThreadID=38;_ThreadName=p: thread-pool-1; w: 41;|
javax.ejb.EJBException
        at
com.sun.ejb.containers.BaseContainer.processSystemException(BaseContaine
r.java:3869)
        at
com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:37
69)
        at
com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:357
1)
        at
com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1354)
        at
com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1316)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:210)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:120)
        at $Proxy98.getNames(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveT
ie.java:154)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
ToServant(CorbaServerRequestDispatcherImpl.java:687)
        at
com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch
(CorbaServerRequestDispatcherImpl.java:227)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestReq
uest(CorbaMessageMediatorImpl.java:1846)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:1706)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(Corb
aMessageMediatorImpl.java:1088)
        at
com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callbac
k(RequestMessage_1_2.java:223)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(Co
rbaMessageMediatorImpl.java:806)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMe
ssageMediatorImpl.java:563)
        at
com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMess
ageMediatorImpl.java:2567)
        at
com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run
(ThreadPoolImpl.java:555)
Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1
(Build b04-fcs (04/11/2008))):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
Error Code: -660
Call: SELECT DISTINCT Text FROM VBFert
Query:
ReportQuery(de.quipsy.persistency.manufacturingMethod.ManufacturingMetho
d)
        at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(Data
baseException.java:319)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:566)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.execu
teCall(DatabaseAccessor.java:452)
        at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSess
ion.java:473)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:228)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeCall(DatasourceCallQueryMechanism.java:214)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.executeSelectCall(DatasourceCallQueryMechanism.java:285)
        at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMec
hanism.selectAllRows(DatasourceCallQueryMechanism.java:615)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllRowsFromTable(ExpressionQueryMechanism.java:2416)
        at
oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechani
sm.selectAllReportQueryRows(ExpressionQueryMechanism.java:2382)
        at
oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuer
y(ReportQuery.java:802)
        at
oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQ
uery.java:628)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(Ob
jectLevelReadQuery.java:692)
        at
oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInU
nitOfWork(ObjectLevelReadQuery.java:746)
        at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecu
teQuery(UnitOfWorkImpl.java:2233)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:952)
        at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery
(AbstractSession.java:924)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeRea
dQuery(EJBQueryImpl.java:367)
        at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultL
ist(EJBQueryImpl.java:478)
        at
de.quipsy.application.complaint.manufacturingMethodManager.Manufacturing
MethodManagerBean.getNames(ManufacturingMethodManagerBean.java:122)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJB
SecurityManager.java:1067)
        at
com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
        at
com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContaine
r.java:2895)
        at
com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3986)
        at
com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvoca
tionHandler.java:203)
        ... 17 more
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL Anywhere]Verbindung
wurde beendet
        at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
        at ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:430)
        at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basic
ExecuteCall(DatabaseAccessor.java:535)
        ... 44 more
|#]


> -----Original Message-----
> From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> Sent: Mittwoch, 15. Oktober 2008 13:33
> To: users_at_glassfish.dev.java.net
> Subject: RE: RE: Re: SQLException does not drop JDBC connection from
> pool
>
> I see this exception coming from result set, most probably this can't
> be
> from a bad connection ?
> Can you provide more stack traces ?
>
> Thanks,
> -Jagadish
>
>
> On Wed, 2008-10-15 at 11:30 +0200, Markus Karg wrote:
> > Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL
> > Anywhere]Server 'FMEA': [Sybase][ODBC Driver][SQL
Anywhere]Verbindung
> > wurde beendet
> > at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
> > at
ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:430)
> > at
> >
>
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basi
> cExecuteCall(DatabaseAccessor.java:535)
> > ... 44 more
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net