Re: Users - Using PostgreSQL

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

Hello,

I'm sorry I can't make out your name but I've been battling the same issue.
Please let me know if you find any solution to it.

Carl

PS How do you write your name with western characters?

Вадим K. wrote

Hello all,

   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:*

 <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.odbc"
datasource-name="localpostgres"/>
    </delegator>

Section with localpostgres left unchanged because I have *user:*ofbiz with *
password:*ofbiz and *database name* is also ofbiz
That is all.

*Error I have:** Exception: org.ofbiz.entity.GenericDataSourceException
Message: Unable to esablish a connection with the database. Connection was
null!*

First question - how does entity knows which client .jar file to load?
Why connection does not work?

Best regards,

--
/ ** Вадим К. **/

 
_______________________________________________
Users mailing list
[e-mail]
http://lists.ofbiz.org/mailman/listinfo/users