Don't know ofbiz well, but I know databases. It would help to know what database backend you are using. Postgresql? Oracle? Microsoft? local database of what kind? unique user of what kind?
These kinds of web apps usually pool database connections to reduce overhead time to setup/teardown a connection, but you are apparently either using all the connections in the pool (unlikely if there is only one user on the system) or you can't get a connection because there IS no pool, e.g. the username or password or permission has changed, the database daemon is down, or whatever, so ofbiz can't reach the database at all. Try contacting the database manually using the username/password in the ofbiz config. Also check the database logs and see if it tels you anything. On Tue, 2010-01-12 at 18:36 -0500, 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. > -- Matt Warnock <[email protected]> RidgeCrest Herbals, Inc.
