Hi Juan Pablo, I am having the same problem in my ofbiz instance till earlier of December, 2009. In my case I am using MySQL as database. After a long research on the database, we identified that *idle connection time outs* are happening with MySQL.
If you are using MySQL as database, after changing configuration settings for idle connection in mysql, we haven't face this problem from then. On Wed, Jan 13, 2010 at 12:35 PM, Jacques Le Roux < [email protected]> wrote: > From: "rohit" <[email protected]> > > Hi, >> >> Please also check the jobsandbox database for any service not properly >> terminated, for eg. they are still in the running status. >> >> i had a lot of problem with us service not ending properly. even with the >> latest code running i have to manually delete some running process on the >> database. Each running process seems to block 1 - 2 pool connection and >> hence the error. currently for eg. the sendorderconfirmation email gets >> stuck as a running process for a long time. >> > > A Jira issue is pending for that > https://issues.apache.org/jira/browse/OFBIZ-2974 > > Jacques > > > Hope it help. >> >> Rohit >> >> >> Juan Pablo wrote: >> >>> >>> Hi Community. >>> >>> Today I had a lot of error messages when I execute some operations: >>> Update >>> Product, Facility Receipt, etc. >>> >>> This is one of the error messages: >>> >>> ------ >>> >>> Error en la llamada el evento: >>> org.ofbiz.webapp.event.EventHandlerException: >>> Service invocation error (Could not commit transaction for service >>> [updateProduct] call: Roll back error, could not commit transaction, was >>> rolled back instead because of: Failure in findByCondition operation for >>> entity [ProductDimension]: org.ofbiz.entity.GenericDataSourceException: >>> Unable to esablish a connection with the database. (Unable to acquire a >>> new >>> connection from the pool). Rolling back >>> transaction.org.ofbiz.entity.GenericDataSourceException: Unable to >>> esablish >>> a connection with the database. (Unable to acquire a new connection from >>> the >>> pool) (Unable to esablish a connection with the database. (Unable to >>> acquire >>> a new connection from the pool))) >>> >>> ------ >>> I understand that the main erro is "Unable to acquire a new connection >>> from >>> the pool" but I don´t understand how I can resolve. >>> >>> I use a local installation with a unique user! >>> >>> Thaks. >>> >>> -- >>> Juan Pablo >>> >>> >>> >> -- >> View this message in context: >> http://n4.nabble.com/Unable-to-acquire-a-new-connection-from-the-pool-tp1012609p1012691.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > -- Thanks, Kumaraswamy.N 91-9866805250.
