Hi Stephen,

if you obtain a PB within odmg-api never
do a PB.close() - this is all handled by the
odmg-api.
> broker = ((TransactionImpl) tx).getBroker();
use it, but don't close it (or commit it).
odmg-api is set on top of pb-api.

regards,
Armin

----- Original Message -----
From: "Stephen Ting" <[EMAIL PROTECTED]>
To: "'OJB Users List'" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 12:00 PM
Subject: RE: multithread problems using ODMG api


> Sorry I have to reopen this case. after I try to dig more and again
> encounter some errors when I try to acquire a pb from a active
> transaction.
>
> db = odmg.newDatabase();
> db.open(site.getDbConnectionAlias(),Database.OPEN_READ_WRITE);
> Transaction tx = odmg.currentTransaction();
>
> file://if I add this line it will throw the following errors.
> broker = ((TransactionImpl) tx).getBroker();
>
>
> I have broker.close() in the finally clause and db.close() in the
> ejbRemove() method of the stateless session bean.
>
> I only have db.close() in the ejbRemove() method. The funny thing is
> this happens only when I include the method to get pb using the above
> mentioned method. Seems, otherwise the ejbRemove() never get invoked
by
> the container. Is there any extra ejb deployment descriptor I have to
> include.(I follow closely Armin ejb test case)? What's the correct
ways
> to use the external transaction? What the method to acquire pb from
the
> ODMG api?
>
> Thanks in advance.
>
> Cheers
> Stephen
>
> 2003-09-25 17:48:23,495 INFO  [STDOUT]
> [org.apache.ojb.odmg.DatabaseImpl] ERROR:
> 2003-09-25 17:48:23,495 INFO  [STDOUT] Could not close database, found
> active transaction. tx-status was 'STATUS_ACTIVE'
> 2003-09-25 17:48:23,526 INFO  [STDOUT]
> [org.apache.ojb.odmg.J2EETransactionImpl] ERROR:
> 2003-09-25 17:48:23,526 INFO  [STDOUT] Could not commit, because tx
> status was marked rollback
> 2003-09-25 17:48:23,541 ERROR [STDERR]
> org.apache.ojb.broker.OJBRuntimeException: Could not commit, because
tx
> status was marked rollback
> at
> org.apache.ojb.odmg.J2EETransactionImpl.beforeCompletion(Unknown
Source)
> at
> org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1416)
> at org.jboss.tm.TxCapsule.rollback(TxCapsule.java:484)
> at
> org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:83)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.j
> ava:357)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
> CMT.java:247)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98)
> at
>
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
> a:130)
> at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> at
>
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer
> .java:313)
> at org.jboss.ejb.Container.invoke(Container.java:738)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> at
>
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383
> )
> 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:324)
> at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> at java.security.AccessController.doPrivileged(Native Method)
> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> at
>
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
> at
>
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
> va:701)
> at java.lang.Thread.run(Thread.java:534)
> 2003-09-25 17:48:23,588 ERROR [org.jboss.ejb.plugins.LogInterceptor]
> RuntimeException:
> org.odmg.TransactionInProgressException: Database cannot be closed,
> associated Tx is still open.
> Used PBKey was org.apache.ojb.broker.PBKey: jcdAlias=syweb, user=syl,
> password=*****
> at org.apache.ojb.odmg.DatabaseImpl.close(Unknown Source)
> at
>
my.com.shinyang.eply.service.ejb.LogReceivingSessionBean.ejbRemove(LogRe
> ceivingSessionBean.java:91)
> at
>
org.jboss.ejb.StatelessSessionEnterpriseContext.discard(StatelessSession
> EnterpriseContext.java:93)
> at
>
org.jboss.ejb.plugins.AbstractInstancePool.discard(AbstractInstancePool.
> java:271)
> at
>
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Statele
> ssSessionInstanceInterceptor.java:99)
> at
>
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterce
> ptor.java:107)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
> CMT.java:237)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:98)
> at
>
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
> a:130)
> at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> at
>
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer
> .java:313)
> at org.jboss.ejb.Container.invoke(Container.java:738)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> at
>
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:383
> )
> 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:324)
> at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> at java.security.AccessController.doPrivileged(Native Method)
> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> at
>
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
> at
>
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
> va:701)
> at java.lang.Thread.run(Thread.java:534)
>
>
>
>
> >-----Original Message-----
> >From: Stephen Ting [mailto:[EMAIL PROTECTED]
> >Sent: 25 September 2003 15:16
> >To: 'OJB Users List'
> >Subject: RE: multithread problems using ODMG api
> >
> >
> >Yeah!!! After I upgrade to rc4 this errors gone...
> >
> >Thanks
> >
> >
> >>-----Original Message-----
> >>From: Stephen Ting [mailto:[EMAIL PROTECTED]
> >>Sent: 25 September 2003 08:49
> >>To: 'Ojb Users List'
> >>Subject: multithread problems using ODMG api
> >>
> >>
> >>
> >>I have problems in using OJB ODMG api in ejb system. When i do
> >>multithread testing it's failed, the object doesn't get
> >>persisted. Whereas, if i do single thread test with multiple
> >>iteration there is no problem. Could someone give me some
> >>guideline on how to design a multithread safe sessionbean
> >>(container managed transaction) using odmg api?
> >>
> >>the stack trace is as follow
> >>Any help are very much appreciated.
> >>Regards,
> >>Stephen Ting
> >>
> >> public LogReceiving createDoc(Site site, LogReceiving document)
> >> throws ServiceException{
> >>
> >>
> >> try{
> >> file://db = odmg.getDatabase(null);
> >> if(db != null){
> >> db.close();
> >> }
> >> Transaction tx = null;
> >> file://openODMGDatabase(site);
> >> db = odmg.newDatabase();
> >>
> >>db.open(site.getDbConnectionAlias(),Database.OPEN_READ_WRITE);
> >>
> >> file://get the current transaction from the container
> >>
> >> tx = odmg.currentTransaction();
> >>
> >> tx.lock(document,Transaction.WRITE);
> >>
> >> file://db.makePersistent(document);
> >>
> >>
> >> }catch(LockNotGrantedException ex){
> >> ex.printStackTrace();
> >> throw new ServiceException(
> >> "Failed to save Log Receiving document
> >>with label "
> >> + document.getLabel());
> >> }catch(PersistenceBrokerException ex){
> >> ex.printStackTrace();
> >> throw new ServiceException(
> >> "Failed to save Log Receiving document
> >>with label "
> >> + document.getLabel());
> >> }catch(ODMGException ex){
> >>
> >> ex.printStackTrace();
> >> }
> >> finally{
> >> if(broker != null){
> >> broker.close();
> >> }
> >> }
> >>
> >> return document;
> >> }
> >>
> >>
> >>2003-09-24 18:08:23,510 INFO
> >>[org.jboss.resource.connectionmanager.LocalTxConnectionManager$
> >>LocalConn
> >>ectionEventListener] throwable from unregister connection
> >>java.lang.IllegalStateException: Trying to return an unknown
> >>connection1!
[EMAIL PROTECTED]
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionManager.un
> >>registerC
> >>onnection(CachedConnectionManager.java:264)
> >> at
> >>org.jboss.resource.connectionmanager.LocalTxConnectionManager$L
> >>ocalConne
>
>>ctionEventListener.connectionClosed(LocalTxConnectionManager.java:371)
> >> at
> >>org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cl
> >>oseHandle
> >>(BaseWrapperManagedConnection.java:280)
> >> at
> >>org.jboss.resource.adapter.jdbc.WrappedConnection.close(Wrapped
> >>Connectio
> >>n.java:97)
> >> at org.apache.ojb.broker.util.WrappedConnection.close(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.util.pooling.ByPassConnection.close(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl
> >>.releaseC
> >>onnection(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.release
> >>Connectio
> >>n(Unknown Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.close(Unknown
Source)
> >> at
> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.close(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.core.PoolablePersistenceBroker.close(Unknown
> >>Source)
> >> at org.apache.ojb.odmg.DatabaseImpl.open(Unknown Source)
> >> at
> >>my.com.shinyang.eply.service.ejb.LogReceivingSessionBean.create
> >>Doc(LogRe
> >>ceivingSessionBean.java:222)
> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >> at
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccesso
> >>rImpl.jav
> >>a:39)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.in
> >>voke(Stat
> >>elessSessionContainer.java:660)
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionIntercepto
> >>r.invoke(
> >>CachedConnectionInterceptor.java:186)
> >> at
> >>org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invok
> >>e(Statele
> >>ssSessionInstanceInterceptor.java:77)
> >> at
> >>org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstract
> >>TxInterce
> >>ptor.java:107)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn
> >>terceptor
> >>CMT.java:291)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT
> >.java:98)
> >> at
> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc
> >>eptor.jav
> >>a:130)
> >> at
> >>org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession
> >>Container
> >>.java:313)
> >> at org.jboss.ejb.Container.invoke(Container.java:738)
> >> at
> >>org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> >> at
> >>org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker
> >>.java:383
> >>)
> >> at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> >> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> >> at java.security.AccessController.doPrivileged(Native Method)
> >> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.
> >>java:460)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTra
> >>nsport.ja
> >>va:701)
> >> at java.lang.Thread.run(Thread.java:534)
> >>2003-09-24 18:08:23,510 ERROR [STDERR] Query "SELECT MAX(ID) FROM
> >>LOG_RECEIVING" execution time: 0 result set
> >fetch time: 0
> >>2003-09-24 18:08:23,541 INFO
> >>[org.jboss.resource.connectionmanager.LocalTxConnectionManager$
> >>LocalConn
> >>ectionEventListener] Unregistered handle that was not
> >>registered!
> >>[EMAIL PROTECTED] for
> >>managedConnection:
> >>[EMAIL PROTECTED]
> >>2003-09-24 18:08:23,572 ERROR [STDERR] Query "SHOW VARIABLES LIKE
> >>'tx_isolation'" execution time: 0 result set
> >>fetch time: 0
> >>2003-09-24 18:08:23,572 ERROR [STDERR] Query "SET autocommit=0"
> >>execution time: 0
> >>2003-09-24 18:08:23,572 INFO
> >>[org.jboss.resource.connectionmanager.LocalTxConnectionManager$
> >>LocalConn
> >>ectionEventListener] throwable from unregister connection
> >>java.lang.IllegalStateException: Trying to return an unknown
> >>connection2!
[EMAIL PROTECTED]
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionManager.un
> >>registerC
> >>onnection(CachedConnectionManager.java:274)
> >> at
> >>org.jboss.resource.connectionmanager.LocalTxConnectionManager$L
> >>ocalConne
>
>>ctionEventListener.connectionClosed(LocalTxConnectionManager.java:371)
> >> at
> >>org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cl
> >>oseHandle
> >>(BaseWrapperManagedConnection.java:280)
> >> at
> >>org.jboss.resource.adapter.jdbc.WrappedConnection.close(Wrapped
> >>Connectio
> >>n.java:97)
> >> at org.apache.ojb.broker.util.WrappedConnection.close(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.util.pooling.ByPassConnection.close(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl
> >>.releaseC
> >>onnection(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.release
> >>Connectio
> >>n(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementManager.closeResourc
> >>es(Unknow
> >>n Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.RsIterator.releaseDbResource
> >s(Unknown
> >>Source)
> >> at org.apache.ojb.broker.accesslayer.RsIterator.hasNext(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColle
> >>ctionByQu
> >>ery(Unknown Source)
> >> at
> >>my.com.shinyang.eply.service.ejb.LogReceivingSessionBean.create
> >>Doc(LogRe
> >>ceivingSessionBean.java:232)
> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >> at
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccesso
> >>rImpl.jav
> >>a:39)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.in
> >>voke(Stat
> >>elessSessionContainer.java:660)
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionIntercepto
> >>r.invoke(
> >>CachedConnectionInterceptor.java:186)
> >> at
> >>org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invok
> >>e(Statele
> >>ssSessionInstanceInterceptor.java:77)
> >> at
> >>org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstract
> >>TxInterce
> >>ptor.java:107)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn
> >>terceptor
> >>CMT.java:291)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT
> >.java:98)
> >> at
> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc
> >>eptor.jav
> >>a:130)
> >> at
> >>org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession
> >>Container
> >>.java:313)
> >> at org.jboss.ejb.Container.invoke(Container.java:738)
> >> at
> >>org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> >> at
> >>org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker
> >>.java:383
> >>)
> >> at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> >> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> >> at java.security.AccessController.doPrivileged(Native Method)
> >> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.
> >>java:460)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTra
> >>nsport.ja
> >>va:701)
> >> at java.lang.Thread.run(Thread.java:534)
> >>2003-09-24 18:08:23,572 ERROR
> >>[org.apache.ojb.broker.accesslayer.StatementsForClassImpl]
> >>java.sql.SQLException: Connection is closed.
> >>[EMAIL PROTECTED]
> >>2003-09-24 18:08:23,572 ERROR
> >>[org.apache.ojb.broker.accesslayer.StatementsForClassImpl]
> >>java.sql.SQLException: Connection is closed.
> >>[EMAIL PROTECTED]
> >>2003-09-24 18:08:23,603 ERROR [STDERR] Query "SHOW VARIABLES LIKE
> >>'tx_isolation'" execution time: 0 result set
> >>fetch time: 0
> >>2003-09-24 18:08:23,603 ERROR [STDERR] Query "SET autocommit=0"
> >>execution time: 0
> >>2003-09-24 18:08:23,619 ERROR [STDERR] Query "SELECT
> >>A0.HARD_SOFT,A0.TYPE,A0.AB,A0.DEFECT_DIAMETER,A0.MARK,A0.LENGTH
> >>,A0.INV_V
> >>ALUE,A0.SPECIES,A0.STATUS,A0.LABEL,A0.GRADE,A0.DIAMETER,A0.RECE
> >>IVING_ID,
> >>A0.COLOUR,A0.BOOK_VALUE,A0.LOGPOND_BLOCK_ID,A0.ROYALTY_ID,A0.ID
> >> FROM LOG_RECEIVING_ITEM A0 WHERE A0.LABEL IN ( 'REC01/1222341' ,
> >>'REC01/1222342' )" execution time: 0 result set fetch time:
> >>0
> >>2003-09-24 18:08:23,650 ERROR
> >>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl]
> >>PersistenceBrokerException during the execution of the query:
> >>Connection is closed.
> >>[EMAIL PROTECTED]
> >>java.sql.SQLException: Connection is closed.
> >>[EMAIL PROTECTED]
> >> at
> >>org.apache.ojb.broker.util.WrappedConnection.checkOpen(Unknown
Source)
> >> at
>
>>org.apache.ojb.broker.util.WrappedConnection.prepareStatement(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepar
> >>eStatemen
> >>t(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPre
> >>paredStmt
> >>(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS
> >>tatement(
> >>Unknown Source)
> >> at
>
>>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
> >>Source)
> >> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterat
> >>or(Unknow
> >>n Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF
> >>romQuery(
> >>Unknown Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro
> >>mQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColle
> >>ctionByQu
> >>ery(Unknown Source)
> >> at
> >>my.com.shinyang.eply.service.ejb.LogReceivingSessionBean.create
> >>Doc(LogRe
> >>ceivingSessionBean.java:232)
> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >> at
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccesso
> >>rImpl.jav
> >>a:39)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.in
> >>voke(Stat
> >>elessSessionContainer.java:660)
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionIntercepto
> >>r.invoke(
> >>CachedConnectionInterceptor.java:186)
> >> at
> >>org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invok
> >>e(Statele
> >>ssSessionInstanceInterceptor.java:77)
> >> at
> >>org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstract
> >>TxInterce
> >>ptor.java:107)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn
> >>terceptor
> >>CMT.java:291)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT
> >.java:98)
> >> at
> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc
> >>eptor.jav
> >>a:130)
> >> at
> >>org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession
> >>Container
> >>.java:313)
> >> at org.jboss.ejb.Container.invoke(Container.java:738)
> >> at
> >>org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> >> at
> >>org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker
> >>.java:383
> >>)
> >> at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> >> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> >> at java.security.AccessController.doPrivileged(Native Method)
> >> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.
> >>java:460)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTra
> >>nsport.ja
> >>va:701)
> >> at java.lang.Thread.run(Thread.java:534)
> >>rethrown as
> >>org.apache.ojb.broker.PersistenceBrokerSQLException:
> >>Connection is closed.
> >>[EMAIL PROTECTED]
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getPre
> >>paredStmt
> >>(Unknown Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementManager.getPreparedS
> >>tatement(
> >>Unknown Source)
> >> at
>
>>org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
> >>Source)
> >> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterat
> >>or(Unknow
> >>n Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorF
> >>romQuery(
> >>Unknown Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFro
> >>mQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionB
> >>yQuery(Un
> >>known Source)
> >> at
> >>org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColle
> >>ctionByQu
> >>ery(Unknown Source)
> >> at
> >>my.com.shinyang.eply.service.ejb.LogReceivingSessionBean.create
> >>Doc(LogRe
> >>ceivingSessionBean.java:232)
> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >> at
> >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccesso
> >>rImpl.jav
> >>a:39)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.in
> >>voke(Stat
> >>elessSessionContainer.java:660)
> >> at
> >>org.jboss.resource.connectionmanager.CachedConnectionIntercepto
> >>r.invoke(
> >>CachedConnectionInterceptor.java:186)
> >> at
> >>org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invok
> >>e(Statele
> >>ssSessionInstanceInterceptor.java:77)
> >> at
> >>org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstract
> >>TxInterce
> >>ptor.java:107)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIn
> >>terceptor
> >>CMT.java:291)
> >> at
> >>org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT
> >.java:98)
> >> at
> >>org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterc
> >>eptor.jav
> >>a:130)
> >> at
> >>org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)
> >> at
> >>org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSession
> >>Container
> >>.java:313)
> >> at org.jboss.ejb.Container.invoke(Container.java:738)
> >> at
> >>org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
> >> at
> >>org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker
> >>.java:383
> >>)
> >> at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
> >> at
> >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho
> >>dAccessor
> >>Impl.java:25)
> >> at java.lang.reflect.Method.invoke(Method.java:324)
> >> at
> >>sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
> >> at sun.rmi.transport.Transport$1.run(Transport.java:148)
> >> at java.security.AccessController.doPrivileged(Native Method)
> >> at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.
> >>java:460)
> >> at
> >>sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTra
> >>nsport.ja
> >>va:701)
> >> at java.lang.Thread.run(Thread.java:534)
> >>Caused by: java.sql.SQLException: Connection is closed.
> >>[EMAIL PROTECTED]
> >> at
> >>org.apache.ojb.broker.util.WrappedConnection.checkOpen(Unknown
Source)
> >> at
>
>>org.apache.ojb.broker.util.WrappedConnection.prepareStatement(Unknown
> >>Source)
> >> at
> >>org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepar
> >>eStatemen
> >>t(Unknown Source)
> >> ... 39 more
> >>
> >>
>
>>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: [EMAIL PROTECTED]
> >>For additional commands, e-mail: [EMAIL PROTECTED]
> >>
> >>
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to