You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "vivek.mi" <vm...@gmail.com> on 2016/12/14 06:44:34 UTC

OFBiz 16.11 with postgres

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



-----
Vivek Mishra
--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-16-11-with-postgres-tp4700234.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: OFBiz 16.11 with postgres

Posted by "vivek.mi" <vm...@gmail.com>.
Thank you everyone. It was done successfully.

Cheers!
Vivek Mishra



-----
Vivek Mishra
--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-16-11-with-postgres-tp4700234p4700267.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: OFBiz 16.11 with postgres

Posted by "vivek.mi" <vm...@gmail.com>.
Thanks Taher. Followed the approach and it's working fine.



-----
Vivek Mishra
--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-16-11-with-postgres-tp4700234p4700266.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: OFBiz 16.11 with postgres

Posted by Taher Alkhateeb <sl...@gmail.com>.
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" <ja...@les7arts.com>
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 <
>> jacques.le.roux@les7arts.com> 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 <sa...@viithiisys.com>
>>>>> 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.
>>>>>>
>>>>>>
>>>>>>
>>>>
>

Re: OFBiz 16.11 with postgres

Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <
> jacques.le.roux@les7arts.com> 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 <sa...@viithiisys.com>
>>>> 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.
>>>>>
>>>>>
>>>


Re: OFBiz 16.11 with postgres

Posted by Taher Alkhateeb <sl...@gmail.com>.
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 <
jacques.le.roux@les7arts.com> 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 <sa...@viithiisys.com>
>>> 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.
>>>>
>>>>
>>
>>
>

Re: OFBiz 16.11 with postgres

Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <sa...@viithiisys.com> 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.
>>>
>
>


Re: OFBiz 16.11 with postgres

Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <sa...@viithiisys.com> 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.
>>


Re: OFBiz 16.11 with postgres

Posted by Taher Alkhateeb <sl...@gmail.com>.
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 <sa...@viithiisys.com> 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.
>

Re: OFBiz 16.11 with postgres

Posted by satish <sa...@viithiisys.com>.
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.

Re: OFBiz 16.11 with postgres

Posted by Wei Zhang <zh...@outlook.com>.
I use below in my own build.gradle


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



-----
程序羊
--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBiz-16-11-with-postgres-tp4700234p4700237.html
Sent from the OFBiz - User mailing list archive at Nabble.com.