You're using a quite old version of OFBiz with the Minerva connection pool (I can tell from the stack trace you sent earlier). The Minerva connection pool has some issues with resetting connections when there are errors, especially if there is any code that doesn't manage errors well, but also if there are network layer issues or other sorts of things... it just doesn't recover at all.
You could try making changes to use the Apache DBCP connection pool that we use now in OFBiz. To do so requires some low-level coding. You can look at the current code base for hints, but there is still some work. There are no known workarounds to this issue for really high volume sites, and for low-medium volume sites the workaround was to restart the app server(s) every day. -David On Jan 27, 2010, at 3:01 PM, Florin Popa wrote: > I was just asking myself if someone encountered before such problems on older > revisions.. > > Would be Geronimo ok to be used or shall I try something else? > > regards, > Florin >> I'm sorry the potential for problems with this approach is just too large >> for me to be able to help you through it. >> >> Regards >> Scott >> >> HotWax Media >> http://www.hotwaxmedia.com >> >> On 27/01/2010, at 1:53 PM, Florin Popa wrote: >> >> >>> The attempt to update Ofbiz to recent revision is for the moment (time >>> limits) not possible.. there are so many differences... I am even not sure >>> if bsh could work further instead of the newly groovy ?! ....also the >>> entity layer handling.. etc >>> >>> So what I tried was to back port the transaction management - latest >>> attempt is attached >> >> >