You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by pmacdee <pa...@hrl.com> on 2007/12/02 00:57:17 UTC
Re: connection with the database. (new connection from the pool)
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.
Re: connection with the database. (new connection from the pool)
Posted by Vikas Mayur <vi...@gmail.com>.
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 <pa...@hrl.com> 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 <pa...@hrl.com> 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
Re: connection with the database. (new connection from the pool)
Posted by pmacdee <pa...@hrl.com>.
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 <pa...@hrl.com> 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.
Re: connection with the database. (new connection from the pool)
Posted by Vikas Mayur <vi...@gmail.com>.
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 <pa...@hrl.com> 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