connection with the database. (new connection from the pool)
Locked
 
|
I am getting a database connection error when I perform a quick ship. I have performed quickship on other orders without a problem. This order is different in that it is a no cost order. I made manual adjustments to make the cost zero. Here is the error, with svn info following:
The Following Errors Occurred: Error trying to begin transaction, could not process method: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findOne operation for entity [SalesInvoiceItemFact]: 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)) calling service updateShipment in createShipmentForFacilityAndShipGroup svn info Path: . URL: http://svn.apache.org/repos/asf/ofbiz/trunk Repository Root: http://svn.apache.org/repos/asf Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 Revision: 593421 Node Kind: directory Schedule: normal Last Changed Author: sichen Last Changed Rev: 593355 Last Changed Date: 2007-11-08 15:24:49 -0800 (Thu, 08 Nov 2007) |
Re: connection with the database. (new connection from the pool)
|
|
You have to configure the entityengine.xml file for the org.ofbiz.olap
group; something like this: <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localderby"/> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> </delegator> Hope it helps (you can also check the standard entityengine.xml file from trunk), Jacopo pmacdee wrote: > I am getting a database connection error when I perform a quick ship. I > have performed quickship on other orders without a problem. This order is > different in that it is a no cost order. I made manual adjustments to make > the cost zero. Here is the error, with svn info following: > > The Following Errors Occurred: > > Error trying to begin transaction, could not process method: The current > transaction is marked for rollback, not beginning a new transaction and > aborting current operation; the rollbackOnly was caused by: Failure in > findOne operation for entity [SalesInvoiceItemFact]: > 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)) calling > service updateShipment in createShipmentForFacilityAndShipGroup > > > svn info > Path: . > URL: http://svn.apache.org/repos/asf/ofbiz/trunk > Repository Root: http://svn.apache.org/repos/asf > Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 > Revision: 593421 > Node Kind: directory > Schedule: normal > Last Changed Author: sichen > Last Changed Rev: 593355 > Last Changed Date: 2007-11-08 15:24:49 -0800 (Thu, 08 Nov 2007) > |
|
|
Here is the section out of my ./framework/entity/config/entityengine.xml
<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> </delegator> I changed <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> to <group-map group-name="org.ofbiz.olap" datasource-name="localpostgres"/> but I got the same error. I want to add that I had used the quick ship several times before and all other parts of the system appear to work OK. Thanks!
|
Re: connection with the database. (new connection from the pool)
|
|
Did you cross check that these entities are created in postgres datasources
after doing changes to entityengine config file. On Dec 2, 2007 5:27 AM, pmacdee <[hidden email]> wrote: > > Here is the section out of my ./framework/entity/config/entityengine.xml > > <delegator name="default" entity-model-reader="main" > entity-group-reader="main" entity-eca-reader="main" > distributed-cache-clear-enabled="false"> > <group-map group-name="org.ofbiz" datasource-name="localpostgres"/> > <group-map group-name="org.ofbiz.olap" > datasource-name="localderbyolap"/> > </delegator> > > I changed > <group-map group-name="org.ofbiz.olap" > datasource-name="localderbyolap"/> > to > <group-map group-name="org.ofbiz.olap" > datasource-name="localpostgres"/> > > but I got the same error. I want to add that I had used the quick ship > several times before and all other parts of the system appear to work OK. > > Thanks! > > Jacopo Cappellato wrote: > > > > You have to configure the entityengine.xml file for the org.ofbiz.olap > > group; something like this: > > > > <delegator name="default" entity-model-reader="main" > > entity-group-reader="main" entity-eca-reader="main" > > distributed-cache-clear-enabled="false"> > > <group-map group-name="org.ofbiz" > datasource-name="localderby"/> > > <group-map group-name="org.ofbiz.olap" > > datasource-name="localderbyolap"/> > > </delegator> > > > > Hope it helps (you can also check the standard entityengine.xml file > > from trunk), > > > > Jacopo > > > > pmacdee wrote: > >> I am getting a database connection error when I perform a quick ship. > I > >> have performed quickship on other orders without a problem. This order > >> is > >> different in that it is a no cost order. I made manual adjustments to > >> make > >> the cost zero. Here is the error, with svn info following: > >> > >> The Following Errors Occurred: > >> > >> Error trying to begin transaction, could not process method: The > current > >> transaction is marked for rollback, not beginning a new transaction and > >> aborting current operation; the rollbackOnly was caused by: Failure in > >> findOne operation for entity [SalesInvoiceItemFact]: > >> 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)) calling > >> service updateShipment in createShipmentForFacilityAndShipGroup > >> > >> > >> svn info > >> Path: . > >> URL: http://svn.apache.org/repos/asf/ofbiz/trunk > >> Repository Root: http://svn.apache.org/repos/asf > >> Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 > >> Revision: 593421 > >> Node Kind: directory > >> Schedule: normal > >> Last Changed Author: sichen > >> Last Changed Rev: 593355 > >> Last Changed Date: 2007-11-08 15:24:49 -0800 (Thu, 08 Nov 2007) > >> > > > > > > > > -- > View this message in context: > http://www.nabble.com/connection-with-the-database.-%28new-connection-from-the-pool%29-tf4889367.html#a14111073 > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Vikas Mayur |
|
|
No, I didn't. How do I do that?
|
Re: connection with the database. (new connection from the pool)
|
|
Every time you do changes to entityengine.xml, you need to restart the
application server. This will create the entities that was in group "org.ofbiz.olap" in your database, Since this is the first time you associate this group to a different datasource. If there is any seed - demo data associated with the entities, than you have to install the data before running the application as well. Two ways to do that. 1) Find the entity from webtools. 2) From terminal, connect to the database, run $ \dt *name*; This will do a like search on name. On Dec 4, 2007 6:32 PM, pmacdee <[hidden email]> wrote: > > No, I didn't. How do I do that? > > > Vikas Mayur-2 wrote: > > > > Did you cross check that these entities are created in postgres > > datasources > > after doing changes to entityengine config file. > > > > > > On Dec 2, 2007 5:27 AM, pmacdee <[hidden email]> wrote: > > > >> > >> Here is the section out of my > ./framework/entity/config/entityengine.xml > >> > >> <delegator name="default" entity-model-reader="main" > >> entity-group-reader="main" entity-eca-reader="main" > >> distributed-cache-clear-enabled="false"> > >> <group-map group-name="org.ofbiz" > >> datasource-name="localpostgres"/> > >> <group-map group-name="org.ofbiz.olap" > >> datasource-name="localderbyolap"/> > >> </delegator> > >> > >> I changed > >> <group-map group-name="org.ofbiz.olap" > >> datasource-name="localderbyolap"/> > >> to > >> <group-map group-name="org.ofbiz.olap" > >> datasource-name="localpostgres"/> > >> > >> but I got the same error. I want to add that I had used the quick ship > >> several times before and all other parts of the system appear to work > OK. > >> > >> Thanks! > >> > >> Jacopo Cappellato wrote: > >> > > >> > You have to configure the entityengine.xml file for the > org.ofbiz.olap > >> > group; something like this: > >> > > >> > <delegator name="default" entity-model-reader="main" > >> > entity-group-reader="main" entity-eca-reader="main" > >> > distributed-cache-clear-enabled="false"> > >> > <group-map group-name="org.ofbiz" > >> datasource-name="localderby"/> > >> > <group-map group-name="org.ofbiz.olap" > >> > datasource-name="localderbyolap"/> > >> > </delegator> > >> > > >> > Hope it helps (you can also check the standard entityengine.xml file > >> > from trunk), > >> > > >> > Jacopo > >> > > >> > pmacdee wrote: > >> >> I am getting a database connection error when I perform a quick > ship. > >> I > >> >> have performed quickship on other orders without a problem. This > >> order > >> >> is > >> >> different in that it is a no cost order. I made manual adjustments > to > >> >> make > >> >> the cost zero. Here is the error, with svn info following: > >> >> > >> >> The Following Errors Occurred: > >> >> > >> >> Error trying to begin transaction, could not process method: The > >> current > >> >> transaction is marked for rollback, not beginning a new transaction > >> and > >> >> aborting current operation; the rollbackOnly was caused by: Failure > in > >> >> findOne operation for entity [SalesInvoiceItemFact]: > >> >> 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)) > calling > >> >> service updateShipment in createShipmentForFacilityAndShipGroup > >> >> > >> >> > >> >> svn info > >> >> Path: . > >> >> URL: http://svn.apache.org/repos/asf/ofbiz/trunk > >> >> Repository Root: http://svn.apache.org/repos/asf > >> >> Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 > >> >> Revision: 593421 > >> >> Node Kind: directory > >> >> Schedule: normal > >> >> Last Changed Author: sichen > >> >> Last Changed Rev: 593355 > >> >> Last Changed Date: 2007-11-08 15:24:49 -0800 (Thu, 08 Nov 2007) > >> >> > >> > > >> > > >> > > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/connection-with-the-database.-%28new-connection-from-the-pool%29-tf4889367.html#a14111073 > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > >> > > > > > > -- > > Vikas Mayur > > > > > > -- > View this message in context: > http://www.nabble.com/connection-with-the-database.-%28new-connection-from-the-pool%29-tf4889367.html#a14150061 > Sent from the OFBiz - User mailing list archive at Nabble.com. > > -- Vikas Mayur |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |