if turning off eager-release="false" I get the following Exception:
15:59:17,301 INFO [STDOUT] [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:
15:59:17,302 INFO [STDOUT] executeQuery: [EMAIL PROTECTED]
15:59:17,408 INFO [TxConnectionManager$TxConnectionEventListener] throwable from unregister connection
java.lang.IllegalStateException: Trying to return an unknown connection1! [EMAIL PROTECTED]
at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.java:264)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:550)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:287)
at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:127)
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.jboss.resource.connectionmanager.CachedConnectionManager.closeAll(CachedConnectionManager.java:375)
at org.jboss.resource.connectionmanager.CachedConnectionManager.popMetaAwareObject(CachedConnectionManager.java:199)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:190)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
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)
What's that?? Seems that OJB creates a connection instead using the data source?
best regards,
Guido
Guido Beutler wrote:
Hi Armin, :-)
yes I'm using eager-release = 'true' with 'false' my connection pool die's when running under load :-( I'll try 'false' just for a test and post the result. Do you mean that I can not trust select results if running with 'true'?
best regards,
Guido
Armin Waibel wrote:
Hi Guido,
this can be a side-effect of the eager-release attribute when set 'true'. Did you tried to run your test with 'false'? Or is your test successful in standalone OJB?
regards, Armin
----- Original Message ----- From: "Guido Beutler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 3:27 PM Subject: Re: OJB RC4 does not select all objects?
Hi,,
I tried a workaround and select all A by a loop with direct primary
key
access like:
"select allobject from A where key=$1"
Whith this select I get all expected objects but of course this is not
very comfortable
to code a loop for every IN clause.
best regards,
Guido
-------- Original Message -------- Subject: OJB RC4 does not select all objects? Date: Wed, 01 Oct 2003 14:20:15 +0200 From: Guido Beutler <[EMAIL PROTECTED]> To: OJB Users List <[EMAIL PROTECTED]
Hello,
I've got a strange problem. I have two Tables A and B with
corresponding
classes. B has a foreign key to A and so I have a 1:N between A and B. A has a reference-descriptor to B and B has a collection-descriptor to A.
If I try to select all instances of A i only get a few entries instead
of 20. If I reinvoke
the test case the number of retrieved objects raises until 20 is
reached.
"select allobject from A where key is in ($1)"
$1 is a collection of 20 integers. If I select all objects of B first and then select all A i get the expected 20 objects. In both cases no exception is thrown. I'm using rc4 with ODMG inside of JBoss 3.2.2. with DB/2.
Has anybody seen this before?
gest regards,
Guido
--------------------------------------------------------------------- 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]