entityconfig.xml

[Florin Popa]

Hello,

Is it any newer version of

http://ofbiz.apache.org/docs/entityconfig.html ?

from here

<inline-jdbc
                jdbc-driver="org.postgresql.Driver"
               
jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
                jdbc-username="platinshop"
                jdbc-password="pl4t1nshop"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>


I can not find in the document pool-minsize


First crashes are

Could not commit transaction:
org.ofbiz.entity.transaction.GenericTransactionException: Roll back
error (with no rollbackOnly cause found), could not commit transaction,
was rolled back instead: javax.transaction.RollbackException:
Transaction timeout (Transaction timeout)

  and then finally (needs restart ):

org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
connection with the database. (Unable to acquire a new connection from
the pool)




thanks.
 Florin

[james_sg]

Hi,

You can looked at the Database Setup in Apache OFBiz Technical Production Setup Guide on how to configure a database.

Regards,
James

Florin Popa wrote

Hello,

Is it any newer version of

http://ofbiz.apache.org/docs/entityconfig.html ?

from here

<inline-jdbc
                jdbc-driver="org.postgresql.Driver"
               
jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
                jdbc-username="platinshop"
                jdbc-password="pl4t1nshop"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>


I can not find in the document pool-minsize


First crashes are

Could not commit transaction:
org.ofbiz.entity.transaction.GenericTransactionException: Roll back
error (with no rollbackOnly cause found), could not commit transaction,
was rolled back instead: javax.transaction.RollbackException:
Transaction timeout (Transaction timeout)

  and then finally (needs restart ):

org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
connection with the database. (Unable to acquire a new connection from
the pool)




thanks.
 Florin

[BJ Freeman]

https://svn.apache.org/repos/asf/ofbiz/
select the branch or trunk and drill down to
/framework/entity/config/


Florin Popa sent the following on 2/11/2010 4:09 PM:

> Hello,
>
> Is it any newer version of
>
> http://ofbiz.apache.org/docs/entityconfig.html ?
>
> from here
>
> <inline-jdbc
>                jdbc-driver="org.postgresql.Driver"
>              
> jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
>                jdbc-username="platinshop"
>                jdbc-password="pl4t1nshop"
>                isolation-level="ReadCommitted"
>                pool-minsize="2"
>                pool-maxsize="250"/>
>
>
> I can not find in the document pool-minsize
>
>
> First crashes are
>
> Could not commit transaction:
> org.ofbiz.entity.transaction.GenericTransactionException: Roll back
> error (with no rollbackOnly cause found), could not commit transaction,
> was rolled back instead: javax.transaction.RollbackException:
> Transaction timeout (Transaction timeout)
>
>  and then finally (needs restart ):
>
> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
> connection with the database. (Unable to acquire a new connection from
> the pool)
>
>
>
>
> thanks.
> Florin
>
>

[BJ Freeman]

disregard. missed you question.


BJ Freeman sent the following on 2/11/2010 5:55 PM:

> https://svn.apache.org/repos/asf/ofbiz/
> select the branch or trunk and drill down to
> /framework/entity/config/
>
>
> Florin Popa sent the following on 2/11/2010 4:09 PM:
>> Hello,
>>
>> Is it any newer version of
>>
>> http://ofbiz.apache.org/docs/entityconfig.html ?
>>
>> from here
>>
>> <inline-jdbc
>>                jdbc-driver="org.postgresql.Driver"
>>              
>> jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
>>                jdbc-username="platinshop"
>>                jdbc-password="pl4t1nshop"
>>                isolation-level="ReadCommitted"
>>                pool-minsize="2"
>>                pool-maxsize="250"/>
>>
>>
>> I can not find in the document pool-minsize
>>
>>
>> First crashes are
>>
>> Could not commit transaction:
>> org.ofbiz.entity.transaction.GenericTransactionException: Roll back
>> error (with no rollbackOnly cause found), could not commit transaction,
>> was rolled back instead: javax.transaction.RollbackException:
>> Transaction timeout (Transaction timeout)
>>
>>  and then finally (needs restart ):
>>
>> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
>> connection with the database. (Unable to acquire a new connection from
>> the pool)
>>
>>
>>
>>
>> thanks.
>> Florin
>>
>>
>
>

[Florin Popa]

My question was related to a .html file - so to an actual version of the
documentation for that entityconfig.xml.

Of course the latest one from SVN I am using already.. but the
documentation I mentioned below is from 2004 and it does not match the
current xml structure at all

thanks,
 Florin

> https://svn.apache.org/repos/asf/ofbiz/
> select the branch or trunk and drill down to
> /framework/entity/config/
>
>
> Florin Popa sent the following on 2/11/2010 4:09 PM:
>  
>> Hello,
>>
>> Is it any newer version of
>>
>> http://ofbiz.apache.org/docs/entityconfig.html ?
>>
>> from here
>>
>> <inline-jdbc
>>                jdbc-driver="org.postgresql.Driver"
>>              
>> jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
>>                jdbc-username="platinshop"
>>                jdbc-password="pl4t1nshop"
>>                isolation-level="ReadCommitted"
>>                pool-minsize="2"
>>                pool-maxsize="250"/>
>>
>>
>> I can not find in the document pool-minsize
>>
>>
>> First crashes are
>>
>> Could not commit transaction:
>> org.ofbiz.entity.transaction.GenericTransactionException: Roll back
>> error (with no rollbackOnly cause found), could not commit transaction,
>> was rolled back instead: javax.transaction.RollbackException:
>> Transaction timeout (Transaction timeout)
>>
>>  and then finally (needs restart ):
>>
>> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
>> connection with the database. (Unable to acquire a new connection from
>> the pool)
>>
>>
>>
>>
>> thanks.
>> Florin
>>
>>
>>    
>
>
>  

[Florin Popa]

Actually it is the same thing I mentioned last night.. the link  below
has a reference to http://ofbiz.apache.org/docs/entityconfig.html and
this one is from 2004 - nothing actual, not related to the current xml
structure so I ask myself if there are other settings I miss and that's
why I got those exceptions - which drives quickly to a blocking of every
instance

thanks,
 Florin

> Hi,
>
> You can looked at the Database Setup in
> http://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
> Apache OFBiz Technical Production Setup Guide  on how to configure a
> database.
>
> Regards,
> James
>
>
> Florin Popa wrote:
>  
>> Hello,
>>
>> Is it any newer version of
>>
>> http://ofbiz.apache.org/docs/entityconfig.html ?
>>
>> from here
>>
>> <inline-jdbc
>>                 jdbc-driver="org.postgresql.Driver"
>>                
>> jdbc-uri="jdbc:postgresql://212.95.36.30:5432/ofbiz_platin_abda"
>>                 jdbc-username="platinshop"
>>                 jdbc-password="pl4t1nshop"
>>                 isolation-level="ReadCommitted"
>>                 pool-minsize="2"
>>                 pool-maxsize="250"/>
>>
>>
>> I can not find in the document pool-minsize
>>
>>
>> First crashes are
>>
>> Could not commit transaction:
>> org.ofbiz.entity.transaction.GenericTransactionException: Roll back
>> error (with no rollbackOnly cause found), could not commit transaction,
>> was rolled back instead: javax.transaction.RollbackException:
>> Transaction timeout (Transaction timeout)
>>
>>   and then finally (needs restart ):
>>
>> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
>> connection with the database. (Unable to acquire a new connection from
>> the pool)
>>
>>
>>
>>
>> thanks.
>>  Florin
>>
>>
>>
>>    
>
>  

[james_sg]

Hi,

I do feel that you should look Database Setup section to see if you have missed out any steps like the following:

1.If using the default OFBiz transaction manager and connection pool, update the data URI, username and password in the inline-jdbc tag
2.If you want your OFBiz tables in a special schema first create that schema in your database, then set the schema-name attribute on the datasource tag
3.Find the "default" delegator near the top of the file and change the datasource-name attribute value in the group-map tag under it to the name of the data source you modified or created.

If the above doesn't solved the problem, have you done this?

2.If necessary, put the correct JDBC driver in:
a.${ofbiz install dir}/framework/entity/lib/jdbc

Regards,
James

Florin Popa wrote

Actually it is the same thing I mentioned last night.. the link  below
has a reference to http://ofbiz.apache.org/docs/entityconfig.html and
this one is from 2004 - nothing actual, not related to the current xml
structure so I ask myself if there are other settings I miss and that's
why I got those exceptions - which drives quickly to a blocking of every
instance

thanks,
 Florin

[james_sg]

I think you meant to say entityengine.xml

Florin Popa wrote

My question was related to a .html file - so to an actual version of the
documentation for that entityconfig.xml.

Of course the latest one from SVN I am using already.. but the
documentation I mentioned below is from 2004 and it does not match the
current xml structure at all

thanks,
 Florin

[Florin Popa]

sorry, /framework/entity/config/entityengine.xml, indeed it is this one

previous suggestions are all done..

> I think you meant to say entityengine.xml
>
>
> Florin Popa wrote:
>  
>> My question was related to a .html file - so to an actual version of the
>> documentation for that entityconfig.xml.
>>
>> Of course the latest one from SVN I am using already.. but the
>> documentation I mentioned below is from 2004 and it does not match the
>> current xml structure at all
>>
>> thanks,
>>  Florin
>>
>>
>>    
>
>  

[BJ Freeman]

yes sorry about that
here is what I was thinking
http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/dtd/entity-config.xsd?view=co&revision=817194&content-type=text%2Fplain
if you look at pool is shows the defaults.


Florin Popa sent the following on 2/11/2010 11:15 PM:

> sorry, /framework/entity/config/entityengine.xml, indeed it is this one
>
> previous suggestions are all done..
>> I think you meant to say entityengine.xml
>>
>>
>> Florin Popa wrote:
>>  
>>> My question was related to a .html file - so to an actual version of
>>> the documentation for that entityconfig.xml.
>>>
>>> Of course the latest one from SVN I am using already.. but the
>>> documentation I mentioned below is from 2004 and it does not match
>>> the current xml structure at all
>>>
>>> thanks,
>>>  Florin
>>>
>>>
>>>    
>>
>>  
>
>