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 <andru..bjectstyle.org>:
>>
>> 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 <andru..bjectstyle.org>:
>> >>
>> >> 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
This archive was generated by hypermail 2.0.0 : Tue Apr 03 2007 - 13:44:34 EDT