Re: Users - Using PostgreSQL

Posted by Carl Gleisner on
URL: http://ofbiz.116.s1.nabble.com/Users-Using-PostgreSQL-tp137098p137101.html

Tarlika,

now I have tried the steps from Opentaps.org and the ones supplied by you earlier and I still get stuck in the verification paragraph of the tutorial at Opentaps.org. I've been discussing another issue with Si Chen and some others and I see some kind of pattern. Don't know if it's Ubuntu (love it) or some human error (me then). My only hope is someone with the same problem. Please keep me posted on any progress

Carl

T E Schmitz wrote

carlj wrote:
>>   I am trying to use Postgre instead of default derby DB. I followed the
>>instructions from Undersun, but have little problem connecting to the
>>database. OFBiz can not connect to it.
>>
>>*My configuration is:* Postgre SQL 7.4.8.
>>*JDBC client database file:* in /ofbiz/framework/entity/lib/jdbc called
>>pg74.216.jdbc3.jar
>>*entityengine.xml has being modified to:*
>>
>>
>>*Error I have:** Exception: org.ofbiz.entity.GenericDataSourceException
>>Message: Unable to esablish a connection with the database. Connection was
>>null!*

Hello Вадим + Carl,
I am running OFBiz with PostgreSQl 7.4. It was pretty straightforward to
set up. I am running an OFBiz revision from last year but hopefully the
following will still be of applicable:

There are only 2 things to set up in OFBiz:
- entityengine.xml
- drop the appropriate driver jar into framework/entity/lib/jdbc

Of course, you need to create the PostgreSQL user + DB before starting
OFBiz:
createuser myuser ...
createdb mydb

The user needs to have the permission to create tables.

In entityengine.xml set up the datasource :

<datasource name="localpostgres"
...
<inline-jdbc
   jdbc-driver="org.postgresql.Driver"            
jdbc-uri="jdbc:postgresql://<my-ip>:5432/mydb"
jdbc-username="myuser"
jdbc-password="mypass"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>

Comment out the jndi-jdbc stuff.

load the seed data:
java -jar ofbiz.jar -install -readers=seed
and to get started the demo data:
java -jar ofbiz.jar -install -readers=demo

Start OFBiz:
./startofbiz.sh

And Bob's your uncle.

--


Regards,

Tarlika Elisabeth Schmitz