OFBiz 16.11 with postgres

[vivek.mi]

Hello all,

I was trying to configure OFBiz 16.11.01 with postgres, but couldn't find the folder to place the Postgres JDBC driver.

Has anyone configured it? Kindly let me know how to go for it.

Thanks in advance.

Regards,
Vivek Mishra

[satish]

Hi Vivek,
            You need to put Postgres JDBC driver under below directory:-
/framework/entity/lib/jdbc

Thanks

[taher]

Hi vivke,

Actually a better approach is to add it as a dependency to your gradle
build script. Reference in here ->
http://markmail.org/message/5qjjnxvvkyp7cxax

Cheers,

Taher Alkhateeb

On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]> wrote:

> Hi Vivek,
>             You need to put Postgres JDBC driver under below directory:-
> /framework/entity/lib/jdbc
>
> Thanks
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Wei Zhang]

I use below in my own build.gradle


dependencies {
    pluginLibsCompile 'org.postgresql:postgresql:9.4.1209.jre7'
}

[Jacques Le Roux]

Hi Taher,

Could we not add something in the main README.MD (then automatically propagated in HTML format to
https://cwiki.apache.org/confluence/display/OFBIZ/From+Ant+to+Gradle)

Jacques

Le 14/12/2016 à 08:08, Taher Alkhateeb a écrit :

> Hi vivke,
>
> Actually a better approach is to add it as a dependency to your gradle
> build script. Reference in here ->
> http://markmail.org/message/5qjjnxvvkyp7cxax
>
> Cheers,
>
> Taher Alkhateeb
>
> On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]> wrote:
>
>> Hi Vivek,
>>              You need to put Postgres JDBC driver under below directory:-
>> /framework/entity/lib/jdbc
>>
>> Thanks
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.
>> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>

[Jacques Le Roux]

I just noticed that I wrote something in the "Step by Step point 2" on the wiki page. But I guess a shorter and direct explanation would be better.

Jacques


Le 14/12/2016 à 12:20, Jacques Le Roux a écrit :

> Hi Taher,
>
> Could we not add something in the main README.MD (then automatically propagated in HTML format to
> https://cwiki.apache.org/confluence/display/OFBIZ/From+Ant+to+Gradle)
>
> Jacques
>
> Le 14/12/2016 à 08:08, Taher Alkhateeb a écrit :
>> Hi vivke,
>>
>> Actually a better approach is to add it as a dependency to your gradle
>> build script. Reference in here ->
>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>
>> Cheers,
>>
>> Taher Alkhateeb
>>
>> On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]> wrote:
>>
>>> Hi Vivek,
>>>              You need to put Postgres JDBC driver under below directory:-
>>> /framework/entity/lib/jdbc
>>>
>>> Thanks
>>>
>>>
>>>
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>
>

[taher]

Yeah I guess we can add a line or two in the README.md file to explain how
to get database drivers for non-derby databases. I'd rather keep it clean
and short though and maybe put a link to the actual documentation page.

On Wed, Dec 14, 2016 at 2:23 PM, Jacques Le Roux <
[hidden email]> wrote:

> I just noticed that I wrote something in the "Step by Step point 2" on the
> wiki page. But I guess a shorter and direct explanation would be better.
>
> Jacques
>
>
>
> Le 14/12/2016 à 12:20, Jacques Le Roux a écrit :
>
>> Hi Taher,
>>
>> Could we not add something in the main README.MD (then automatically
>> propagated in HTML format to https://cwiki.apache.org/confl
>> uence/display/OFBIZ/From+Ant+to+Gradle)
>>
>> Jacques
>>
>> Le 14/12/2016 à 08:08, Taher Alkhateeb a écrit :
>>
>>> Hi vivke,
>>>
>>> Actually a better approach is to add it as a dependency to your gradle
>>> build script. Reference in here ->
>>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>>
>>> Cheers,
>>>
>>> Taher Alkhateeb
>>>
>>> On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]>
>>> wrote:
>>>
>>> Hi Vivek,
>>>>              You need to put Postgres JDBC driver under below
>>>> directory:-
>>>> /framework/entity/lib/jdbc
>>>>
>>>> Thanks
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>
>>
>

[Jacques Le Roux]

What actual documentation page do you think about?
I mean do you want to refer to the "Step by Step point 2" or to create something else there?
Because else 1 or 2 lines (+1 from me) in the README.MD will anyway be reflected in this page ;)

Jacques

Le 14/12/2016 à 12:38, Taher Alkhateeb a écrit :

> Yeah I guess we can add a line or two in the README.md file to explain how
> to get database drivers for non-derby databases. I'd rather keep it clean
> and short though and maybe put a link to the actual documentation page.
>
> On Wed, Dec 14, 2016 at 2:23 PM, Jacques Le Roux <
> [hidden email]> wrote:
>
>> I just noticed that I wrote something in the "Step by Step point 2" on the
>> wiki page. But I guess a shorter and direct explanation would be better.
>>
>> Jacques
>>
>>
>>
>> Le 14/12/2016 à 12:20, Jacques Le Roux a écrit :
>>
>>> Hi Taher,
>>>
>>> Could we not add something in the main README.MD (then automatically
>>> propagated in HTML format to https://cwiki.apache.org/confl
>>> uence/display/OFBIZ/From+Ant+to+Gradle)
>>>
>>> Jacques
>>>
>>> Le 14/12/2016 à 08:08, Taher Alkhateeb a écrit :
>>>
>>>> Hi vivke,
>>>>
>>>> Actually a better approach is to add it as a dependency to your gradle
>>>> build script. Reference in here ->
>>>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>>>
>>>> Cheers,
>>>>
>>>> Taher Alkhateeb
>>>>
>>>> On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]>
>>>> wrote:
>>>>
>>>> Hi Vivek,
>>>>>               You need to put Postgres JDBC driver under below
>>>>> directory:-
>>>>> /framework/entity/lib/jdbc
>>>>>
>>>>> Thanks
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>>> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>

[taher]

I'm not sure Jacques; perhaps here
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup

So maybe just have a line that says you can download the database driver
automatically from jcenter, here is an example and for more information
here is the link. Of course we need to update that documentation it looks
old to me as it recommends downloading a jar instead.

Given that database is a customization I think we'd rather keep it down
below in the file, it shouldn't take priority I think. The same by the way
for the security note, I think it would be better for users to see the
getting started header before anything else in README.md

On Dec 14, 2016 9:29 PM, "Jacques Le Roux" <[hidden email]>
wrote:

> What actual documentation page do you think about?
> I mean do you want to refer to the "Step by Step point 2" or to create
> something else there?
> Because else 1 or 2 lines (+1 from me) in the README.MD will anyway be
> reflected in this page ;)
>
> Jacques
>
> Le 14/12/2016 à 12:38, Taher Alkhateeb a écrit :
>
>> Yeah I guess we can add a line or two in the README.md file to explain how
>> to get database drivers for non-derby databases. I'd rather keep it clean
>> and short though and maybe put a link to the actual documentation page.
>>
>> On Wed, Dec 14, 2016 at 2:23 PM, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>> I just noticed that I wrote something in the "Step by Step point 2" on the
>>> wiki page. But I guess a shorter and direct explanation would be better.
>>>
>>> Jacques
>>>
>>>
>>>
>>> Le 14/12/2016 à 12:20, Jacques Le Roux a écrit :
>>>
>>> Hi Taher,
>>>>
>>>> Could we not add something in the main README.MD (then automatically
>>>> propagated in HTML format to https://cwiki.apache.org/confl
>>>> uence/display/OFBIZ/From+Ant+to+Gradle)
>>>>
>>>> Jacques
>>>>
>>>> Le 14/12/2016 à 08:08, Taher Alkhateeb a écrit :
>>>>
>>>> Hi vivke,
>>>>>
>>>>> Actually a better approach is to add it as a dependency to your gradle
>>>>> build script. Reference in here ->
>>>>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>>>>
>>>>> Cheers,
>>>>>
>>>>> Taher Alkhateeb
>>>>>
>>>>> On Wed, Dec 14, 2016 at 9:52 AM, satish <[hidden email]>
>>>>> wrote:
>>>>>
>>>>> Hi Vivek,
>>>>>
>>>>>>               You need to put Postgres JDBC driver under below
>>>>>> directory:-
>>>>>> /framework/entity/lib/jdbc
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>>>>> com/OFBiz-16-11-with-postgres-tp4700234p4700235.html
>>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>>>>
>>>>
>

[vivek.mi]

Thanks Taher. Followed the approach and it's working fine.

[vivek.mi]

Thank you everyone. It was done successfully.

Cheers!
Vivek Mishra