ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vikas Mayur" <vikasma...@gmail.com>
Subject Re: connection with the database. (new connection from the pool)
Date Tue, 04 Dec 2007 13:22:54 GMT
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 <pamacdonald@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 <pamacdonald@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message