Re: Users - Using PostgreSQL

Posted by cjhowe on
URL: http://ofbiz.116.s1.nabble.com/Users-Using-PostgreSQL-tp137098p137104.html

I'm not sure if this issue applies with Postgresql,
but with MySql you need to create the empty database
with the name designated in your datasource (in the
default setting, it is ofbiz) before you're able to
load the tables.  

--- carlj <[hidden email]> wrote:

>
> 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
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
> --
> View this message in context:
>

http://www.nabble.com/Users---Using-PostgreSQL-tf1009995.html#a5526865
> Sent from the OFBiz - User forum at Nabble.com.
>
>