Ok, moving ahead - another thing to check... Try a DBCP connection
pool instead of default Cayenne pool.
http://cayenne.apache.org/doc20/dbcpdatasourcefactory.html
Also could you do a "kill -QUIT" on the stuck instance to get the
thread dump and see where exactly it is stuck.
Andrus
On Apr 3, 2007, at 1:15 PM, jerome moliere wrote:
2007/4/3, Andrus Adamchik <[EMAIL PROTECTED]>:
One more shot in the dark. I've seen Sybase standard driver behave
unpredictably (I won't have access to Sybase until the end of the
week to try it). Can you run the same test with jTDS driver?
yes that's done.... same results
Thanks for your help
Cheers
jerome
http://jtds.sourceforge.net/
Andrus
On Apr 3, 2007, at 12:35 PM, jerome moliere wrote:
> 2007/4/3, Andrus Adamchik <[EMAIL PROTECTED]>:
>>
>> While I've never seen hung transactions in my apps, there were
other
>> users [1] who are seeing some strangeness. So let's try to
figure out
>> what's going on.
>>
>> 1. What DataSource are you using - Cayenne-provided or some other
>> (e.g. container-provided). Either should work of course, but this
>> information should help in debugging.
>
>
> cayenne provided one...
>
> 2. Are you using container-managed transactions? If you are, you
have
>> to check "container-managed transactions" [2], and ensure that
>> whatever transaction mechanism is used (i.e. explicit J2EE
>> UserTransactions), you commit them explicitly.
>
>
> no CMT.... these samples are made in a very simple context, STAND
> ALONE
> applications
> no J2EE stuff here...
>
>
> --
> Jerome Moliere - Mentor/J
> http://romjethoughts.blogspot.com/
> auteur Eyrolles
--
Jerome Moliere - Mentor/J
http://romjethoughts.blogspot.com/
auteur Eyrolles
