postgres SQL standard for many linux boxes is 7.4
however there are newer versions like 8.2.4
they require thier own Jbc drivers
you can find these on
http://www.postgresql.org/download/
comment out the derby and replace it with
<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"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
when you setup you postgres besure to create a DB per the localpostgres
section for usr and password.
Brendan Vogt sent the following on 10/20/2007 12:33 PM:
> You speak of " as you have the right
> version and jbc drivers in the configuration". What do you mean of right
> version and jdbc drivers in the configuration?
>
> I have copied the jdbc driver for Postgres database to:
>
> ...\TestOfBiz\framework\entity\lib\jdbc
>
> Do I have to specify anything else in the entityengine.xml file found in
> ...\TestOfBiz\framework\entity\config or should I leave it as is?
>
>
> -----Original Message-----
> From: BJ Freeman [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 20, 2007 6:39 PM
> To: [email protected]
> Subject: Re: OfBiz Database Installation
>
> You select your datasource at the top, see where the derby is setup now.
> you can use the postgres datasource as long as you have the right
> version and jbc drivers in the configuration.
>
> Brendan Vogt sent the following on 10/20/2007 8:02 AM:
>> Hi,
>>
>>
>>
>> I am new to this kind of setup. I am a C# programmer, and I am used to
>> clicking a couple of times then everything is installed and ready to go.
> I
>> am wanting to try out the OfBiz application.
>>
>>
>>
>> After hours of trying to get the source code, I managed to download it.
> Now
>> I am following the installation steps as set out in:
>>
>>
> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setu
>> p+Guide
>>
>>
>>
>> I am busy with the section under Database Setup. I have SQL Server 2005,
>> but want to use Postgres database. I have it installed as well. I have
>> added the JDBC driver .rar in the directory which they said I must. In
> the
>> ${ofbiz install dir}/framework/entity/config/entityengine.xml file I have
> to
>> set my datasource. There is already many datasources added.
>>
>>
>>
>> Question
>>
>> Do I need to change any of the setting for the Postgres database
> datasource?
>> DO I keep the other datasources there?
>>
>>
>>
>> Regards,
>>
>> Brendan
>>
>>
>
>
>
>
