How to integrate Ofbiz with Cassandra Database?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
13 messages Options
Reply | Threaded
Open this post in threaded view
|

How to integrate Ofbiz with Cassandra Database?

Naveen Metta
Hi all,

Is anyone can point me in right direction for how to integrate Ofbiz with
Cassandra Database.

 

Thank you.

 

Naveeno Metta

 <mailto:[hidden email]> [hidden email]

 <https://www.linkedin.com/in/naveenmetta>
https://www.linkedin.com/in/naveenmetta

 

 

Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Naveen Metta
Can ofbiz  use CASSANDRA as DAtabase?

Thank you. Sent from my iPhone.
 
Naveeno Metta
[hidden email]
https://www.linkedin.com/in/naveenmetta

> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]> wrote:
>
> Hi all,
> Is anyone can point me in right direction for how to integrate Ofbiz with Cassandra Database.
>  
> Thank you.
>  
> Naveeno Metta
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>  
>  
Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Pranay Pandey-3
Hi Naveeno,

The answer to the question-
Can OFBiz use CASSANDRA as Database?
will be Yes, but based on my understanding as of now there is no direct
configuration settings available in OOTB OFBiz for the same. It may require
some work to get it working with Cassandra.

Let's wait and see what other community members have to say about it.


Best regards,

Pranay Pandey
HotWax Systems
http://www.hotwaxsystems.com/

On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
wrote:

> Can ofbiz  use CASSANDRA as DAtabase?
>
> Thank you. Sent from my iPhone.
>
> Naveeno Metta
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>
> > On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
> wrote:
> >
> > Hi all,
> > Is anyone can point me in right direction for how to integrate Ofbiz
> with Cassandra Database.
> >
> > Thank you.
> >
> > Naveeno Metta
> > [hidden email]
> > https://www.linkedin.com/in/naveenmetta
> >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Nicolas Malin-2

Hi Naveeno, please wait I can explain howto do this but I haven't time.

:) I try to find spare time this night

Nicolas

Le 03/06/2016 15:35, Pranay Pandey a écrit :

> Hi Naveeno,
>
> The answer to the question-
> Can OFBiz use CASSANDRA as Database?
> will be Yes, but based on my understanding as of now there is no direct
> configuration settings available in OOTB OFBiz for the same. It may require
> some work to get it working with Cassandra.
>
> Let's wait and see what other community members have to say about it.
>
>
> Best regards,
>
> Pranay Pandey
> HotWax Systems
> http://www.hotwaxsystems.com/
>
> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
> wrote:
>
>> Can ofbiz  use CASSANDRA as DAtabase?
>>
>> Thank you. Sent from my iPhone.
>>
>> Naveeno Metta
>> [hidden email]
>> https://www.linkedin.com/in/naveenmetta
>>
>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>> wrote:
>>> Hi all,
>>> Is anyone can point me in right direction for how to integrate Ofbiz
>> with Cassandra Database.
>>> Thank you.
>>>
>>> Naveeno Metta
>>> [hidden email]
>>> https://www.linkedin.com/in/naveenmetta
>>>
>>>

Reply | Threaded
Open this post in threaded view
|

RE: How to integrate Ofbiz with Cassandra Database?

Naveen Metta
Thank you Pranay and Nicolas. Appreciate your support.

Thank you.

Naveeno Metta
[hidden email]
https://www.linkedin.com/in/naveenmetta


-----Original Message-----
From: Nicolas Malin [mailto:[hidden email]]
Sent: Friday, June 03, 2016 8:40 AM
To: [hidden email]
Subject: Re: How to integrate Ofbiz with Cassandra Database?


Hi Naveeno, please wait I can explain howto do this but I haven't time.

:) I try to find spare time this night

Nicolas

Le 03/06/2016 15:35, Pranay Pandey a écrit :

> Hi Naveeno,
>
> The answer to the question-
> Can OFBiz use CASSANDRA as Database?
> will be Yes, but based on my understanding as of now there is no
> direct configuration settings available in OOTB OFBiz for the same. It
> may require some work to get it working with Cassandra.
>
> Let's wait and see what other community members have to say about it.
>
>
> Best regards,
>
> Pranay Pandey
> HotWax Systems
> http://www.hotwaxsystems.com/
>
> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
> wrote:
>
>> Can ofbiz  use CASSANDRA as DAtabase?
>>
>> Thank you. Sent from my iPhone.
>>
>> Naveeno Metta
>> [hidden email]
>> https://www.linkedin.com/in/naveenmetta
>>
>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>> wrote:
>>> Hi all,
>>> Is anyone can point me in right direction for how to integrate Ofbiz
>> with Cassandra Database.
>>> Thank you.
>>>
>>> Naveeno Metta
>>> [hidden email]
>>> https://www.linkedin.com/in/naveenmetta
>>>
>>>


Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Pranay Pandey-3
In reply to this post by Nicolas Malin-2
Thanks Nicolas, will wait for the details from your side. It will be very
interesting to know your experience working with OFBiz + Cassandra.

Best regards,

Pranay Pandey
HotWax Systems
http://www.hotwaxsystems.com/

On Fri, Jun 3, 2016 at 7:10 PM, Nicolas Malin <[hidden email]>
wrote:

>
> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>
> :) I try to find spare time this night
>
> Nicolas
>
>
> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>
>> Hi Naveeno,
>>
>> The answer to the question-
>> Can OFBiz use CASSANDRA as Database?
>> will be Yes, but based on my understanding as of now there is no direct
>> configuration settings available in OOTB OFBiz for the same. It may
>> require
>> some work to get it working with Cassandra.
>>
>> Let's wait and see what other community members have to say about it.
>>
>>
>> Best regards,
>>
>> Pranay Pandey
>> HotWax Systems
>> http://www.hotwaxsystems.com/
>>
>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>> wrote:
>>
>> Can ofbiz  use CASSANDRA as DAtabase?
>>>
>>> Thank you. Sent from my iPhone.
>>>
>>> Naveeno Metta
>>> [hidden email]
>>> https://www.linkedin.com/in/naveenmetta
>>>
>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>>
>>> wrote:
>>>
>>>> Hi all,
>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>>>
>>> with Cassandra Database.
>>>
>>>> Thank you.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>>>>
>>>>
>>>>
>
Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Jacques Le Roux
Administrator
In reply to this post by Nicolas Malin-2
I also know Pierre Smits got it working with HBase https://issues.apache.org/jira/browse/OFBIZ-6965

Jacques

Le 03/06/2016 à 15:40, Nicolas Malin a écrit :

>
> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>
> :) I try to find spare time this night
>
> Nicolas
>
> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>> Hi Naveeno,
>>
>> The answer to the question-
>> Can OFBiz use CASSANDRA as Database?
>> will be Yes, but based on my understanding as of now there is no direct
>> configuration settings available in OOTB OFBiz for the same. It may require
>> some work to get it working with Cassandra.
>>
>> Let's wait and see what other community members have to say about it.
>>
>>
>> Best regards,
>>
>> Pranay Pandey
>> HotWax Systems
>> http://www.hotwaxsystems.com/
>>
>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>> wrote:
>>
>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>
>>> Thank you. Sent from my iPhone.
>>>
>>> Naveeno Metta
>>> [hidden email]
>>> https://www.linkedin.com/in/naveenmetta
>>>
>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>> wrote:
>>>> Hi all,
>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>> with Cassandra Database.
>>>> Thank you.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>>>>
>>>>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Jacques Le Roux
Administrator
Mmm, I also just noticed that I committed a patch from Pierre at r1743422 where he left an unwanted change for the same

I'll revert and comment

Jacques


Le 03/06/2016 à 15:44, Jacques Le Roux a écrit :

>
> I also know Pierre Smits got it working with HBase https://issues.apache.org/jira/browse/OFBIZ-6965
>
> Jacques
>
> Le 03/06/2016 à 15:40, Nicolas Malin a écrit :
>>
>> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>>
>> :) I try to find spare time this night
>>
>> Nicolas
>>
>> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>>> Hi Naveeno,
>>>
>>> The answer to the question-
>>> Can OFBiz use CASSANDRA as Database?
>>> will be Yes, but based on my understanding as of now there is no direct
>>> configuration settings available in OOTB OFBiz for the same. It may require
>>> some work to get it working with Cassandra.
>>>
>>> Let's wait and see what other community members have to say about it.
>>>
>>>
>>> Best regards,
>>>
>>> Pranay Pandey
>>> HotWax Systems
>>> http://www.hotwaxsystems.com/
>>>
>>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>>> wrote:
>>>
>>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>>
>>>> Thank you. Sent from my iPhone.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>>>>
>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>> wrote:
>>>>> Hi all,
>>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>>> with Cassandra Database.
>>>>> Thank you.
>>>>>
>>>>> Naveeno Metta
>>>>> [hidden email]
>>>>> https://www.linkedin.com/in/naveenmetta
>>>>>
>>>>>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Mike Z
MariaDB (clone of mysql) has a cassandra plugin.  Why not just use this
instead?

https://mariadb.com/kb/en/mariadb/cassandra-storage-engine-overview/

On Fri, Jun 3, 2016 at 6:48 AM, Jacques Le Roux <
[hidden email]> wrote:

> Mmm, I also just noticed that I committed a patch from Pierre at r1743422
> where he left an unwanted change for the same
>
> I'll revert and comment
>
> Jacques
>
>
>
> Le 03/06/2016 à 15:44, Jacques Le Roux a écrit :
>
>>
>> I also know Pierre Smits got it working with HBase
>> https://issues.apache.org/jira/browse/OFBIZ-6965
>>
>> Jacques
>>
>> Le 03/06/2016 à 15:40, Nicolas Malin a écrit :
>>
>>>
>>> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>>>
>>> :) I try to find spare time this night
>>>
>>> Nicolas
>>>
>>> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>>>
>>>> Hi Naveeno,
>>>>
>>>> The answer to the question-
>>>> Can OFBiz use CASSANDRA as Database?
>>>> will be Yes, but based on my understanding as of now there is no direct
>>>> configuration settings available in OOTB OFBiz for the same. It may
>>>> require
>>>> some work to get it working with Cassandra.
>>>>
>>>> Let's wait and see what other community members have to say about it.
>>>>
>>>>
>>>> Best regards,
>>>>
>>>> Pranay Pandey
>>>> HotWax Systems
>>>> http://www.hotwaxsystems.com/
>>>>
>>>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>>>> wrote:
>>>>
>>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>>>
>>>>> Thank you. Sent from my iPhone.
>>>>>
>>>>> Naveeno Metta
>>>>> [hidden email]
>>>>> https://www.linkedin.com/in/naveenmetta
>>>>>
>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>>>>
>>>>> wrote:
>>>>>
>>>>>> Hi all,
>>>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>>>>>
>>>>> with Cassandra Database.
>>>>>
>>>>>> Thank you.
>>>>>>
>>>>>> Naveeno Metta
>>>>>> [hidden email]
>>>>>> https://www.linkedin.com/in/naveenmetta
>>>>>>
>>>>>>
>>>>>>
>>>
>>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Naveen Metta
In reply to this post by Nicolas Malin-2
Nicolas,
Any luck on finding free time to document Cassandra integration with OFBIZ?

Thank you. Sent from my iPhone.
 
Naveeno Metta
[hidden email]
https://www.linkedin.com/in/naveenmetta

> On Jun 3, 2016, at 8:40 AM, Nicolas Malin <[hidden email]> wrote:
>
>
> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>
> :) I try to find spare time this night
>
> Nicolas
>
> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>> Hi Naveeno,
>>
>> The answer to the question-
>> Can OFBiz use CASSANDRA as Database?
>> will be Yes, but based on my understanding as of now there is no direct
>> configuration settings available in OOTB OFBiz for the same. It may require
>> some work to get it working with Cassandra.
>>
>> Let's wait and see what other community members have to say about it.
>>
>>
>> Best regards,
>>
>> Pranay Pandey
>> HotWax Systems
>> http://www.hotwaxsystems.com/
>>
>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>> wrote:
>>
>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>
>>> Thank you. Sent from my iPhone.
>>>
>>> Naveeno Metta
>>> [hidden email]
>>> https://www.linkedin.com/in/naveenmetta
>>>
>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>> wrote:
>>>> Hi all,
>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>> with Cassandra Database.
>>>> Thank you.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>
Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Nicolas Malin-2
Yes,

To deploy cassandra you can try :
1. download the cassandra jdbc driver on framework/entity/lib/jdbc
2. configure entityengine on framework/entity/config/entity-engine.xml
and add a datasource like that :
     <datasource name="localcassandra"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
             schema-name="OFBIZ"
             field-type-name="cassandra"
             check-on-start="true"
             add-missing-on-start="true"
             use-pk-constraint-names="false"
             use-indices-unique="false"
             alias-view-columns="false"
             use-order-by-nulls="true"
             offset-style="fetch">
         <read-data reader-name="tenant"/>
         <read-data reader-name="seed"/>
         <read-data reader-name="seed-initial"/>
         <read-data reader-name="demo"/>
         <read-data reader-name="ext"/>
         <read-data reader-name="ext-test"/>
         <read-data reader-name="ext-demo"/>
         <inline-jdbc
jdbc-driver="org.apache.cassandra.jdbc.EmbeddedDriver" //check the jdbc
value
                 jdbc-uri="jdbc:cassandra://127.0.0.1/ofbiz" //check the
jdbc value
                 jdbc-username="ofbiz"
                 jdbc-password-lookup="ofbiz"
                 isolation-level="ReadCommitted"
                 pool-minsize="2"
                 pool-maxsize="250"
                 time-between-eviction-runs-millis="600000"/>
     </datasource>

and set your delegator on this :
     <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="localcassandra"/>...

3. create the field type like this :
framework/entity/fieldtype/fieldtypecassandra.xml. Take inspiration from
fieldtypepostgres.xml and adapt for the cassandra data base.

I didn't test the process, just show you the way ;) and if it's works,
all contribution are welcome :)

Nicolas




Le 07/06/2016 03:56, Naveen Metta a écrit :

> Nicolas,
> Any luck on finding free time to document Cassandra integration with OFBIZ?
>
> Thank you. Sent from my iPhone.
>  
> Naveeno Metta
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>
>> On Jun 3, 2016, at 8:40 AM, Nicolas Malin <[hidden email]> wrote:
>>
>>
>> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>>
>> :) I try to find spare time this night
>>
>> Nicolas
>>
>> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>>> Hi Naveeno,
>>>
>>> The answer to the question-
>>> Can OFBiz use CASSANDRA as Database?
>>> will be Yes, but based on my understanding as of now there is no direct
>>> configuration settings available in OOTB OFBiz for the same. It may require
>>> some work to get it working with Cassandra.
>>>
>>> Let's wait and see what other community members have to say about it.
>>>
>>>
>>> Best regards,
>>>
>>> Pranay Pandey
>>> HotWax Systems
>>> http://www.hotwaxsystems.com/
>>>
>>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>>> wrote:
>>>
>>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>>
>>>> Thank you. Sent from my iPhone.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>>>>
>>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>>> wrote:
>>>>> Hi all,
>>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>>> with Cassandra Database.
>>>>> Thank you.
>>>>>
>>>>> Naveeno Metta
>>>>> [hidden email]
>>>>> https://www.linkedin.com/in/naveenmetta

Reply | Threaded
Open this post in threaded view
|

RE: How to integrate Ofbiz with Cassandra Database?

Naveen Metta
Thank you very much. I will share the outcome.

Naveeno Metta
903-484-4097
[hidden email]
https://www.linkedin.com/in/naveenmetta


-----Original Message-----
From: Nicolas Malin [mailto:[hidden email]]
Sent: Tuesday, June 07, 2016 2:24 AM
To: [hidden email]
Subject: Re: How to integrate Ofbiz with Cassandra Database?

Yes,

To deploy cassandra you can try :
1. download the cassandra jdbc driver on framework/entity/lib/jdbc 2. configure entityengine on framework/entity/config/entity-engine.xml
and add a datasource like that :
     <datasource name="localcassandra"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
             schema-name="OFBIZ"
             field-type-name="cassandra"
             check-on-start="true"
             add-missing-on-start="true"
             use-pk-constraint-names="false"
             use-indices-unique="false"
             alias-view-columns="false"
             use-order-by-nulls="true"
             offset-style="fetch">
         <read-data reader-name="tenant"/>
         <read-data reader-name="seed"/>
         <read-data reader-name="seed-initial"/>
         <read-data reader-name="demo"/>
         <read-data reader-name="ext"/>
         <read-data reader-name="ext-test"/>
         <read-data reader-name="ext-demo"/>
         <inline-jdbc
jdbc-driver="org.apache.cassandra.jdbc.EmbeddedDriver" //check the jdbc value
                 jdbc-uri="jdbc:cassandra://127.0.0.1/ofbiz" //check the jdbc value
                 jdbc-username="ofbiz"
                 jdbc-password-lookup="ofbiz"
                 isolation-level="ReadCommitted"
                 pool-minsize="2"
                 pool-maxsize="250"
                 time-between-eviction-runs-millis="600000"/>
     </datasource>

and set your delegator on this :
     <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="localcassandra"/>...

3. create the field type like this :
framework/entity/fieldtype/fieldtypecassandra.xml. Take inspiration from fieldtypepostgres.xml and adapt for the cassandra data base.

I didn't test the process, just show you the way ;) and if it's works, all contribution are welcome :)

Nicolas




Le 07/06/2016 03:56, Naveen Metta a écrit :

> Nicolas,
> Any luck on finding free time to document Cassandra integration with OFBIZ?
>
> Thank you. Sent from my iPhone.
>  
> Naveeno Metta
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>
>> On Jun 3, 2016, at 8:40 AM, Nicolas Malin <[hidden email]> wrote:
>>
>>
>> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>>
>> :) I try to find spare time this night
>>
>> Nicolas
>>
>> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>>> Hi Naveeno,
>>>
>>> The answer to the question-
>>> Can OFBiz use CASSANDRA as Database?
>>> will be Yes, but based on my understanding as of now there is no
>>> direct configuration settings available in OOTB OFBiz for the same.
>>> It may require some work to get it working with Cassandra.
>>>
>>> Let's wait and see what other community members have to say about it.
>>>
>>>
>>> Best regards,
>>>
>>> Pranay Pandey
>>> HotWax Systems
>>> http://www.hotwaxsystems.com/
>>>
>>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta
>>> <[hidden email]>
>>> wrote:
>>>
>>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>>
>>>> Thank you. Sent from my iPhone.
>>>>
>>>> Naveeno Metta
>>>> [hidden email]
>>>> https://www.linkedin.com/in/naveenmetta
>>>>
>>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta
>>>>>> <[hidden email]>
>>>>> wrote:
>>>>> Hi all,
>>>>> Is anyone can point me in right direction for how to integrate
>>>>> Ofbiz
>>>> with Cassandra Database.
>>>>> Thank you.
>>>>>
>>>>> Naveeno Metta
>>>>> [hidden email]
>>>>> https://www.linkedin.com/in/naveenmetta


Reply | Threaded
Open this post in threaded view
|

Re: How to integrate Ofbiz with Cassandra Database?

Pranay Pandey-3
In reply to this post by Nicolas Malin-2
Thanks Nicolas.

Best regards,

Pranay Pandey
HotWax Systems
http://www.hotwaxsystems.com/

On Tue, Jun 7, 2016 at 12:53 PM, Nicolas Malin <[hidden email]>
wrote:

> Yes,
>
> To deploy cassandra you can try :
> 1. download the cassandra jdbc driver on framework/entity/lib/jdbc
> 2. configure entityengine on framework/entity/config/entity-engine.xml and
> add a datasource like that :
>     <datasource name="localcassandra"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>             schema-name="OFBIZ"
>             field-type-name="cassandra"
>             check-on-start="true"
>             add-missing-on-start="true"
>             use-pk-constraint-names="false"
>             use-indices-unique="false"
>             alias-view-columns="false"
>             use-order-by-nulls="true"
>             offset-style="fetch">
>         <read-data reader-name="tenant"/>
>         <read-data reader-name="seed"/>
>         <read-data reader-name="seed-initial"/>
>         <read-data reader-name="demo"/>
>         <read-data reader-name="ext"/>
>         <read-data reader-name="ext-test"/>
>         <read-data reader-name="ext-demo"/>
>         <inline-jdbc
> jdbc-driver="org.apache.cassandra.jdbc.EmbeddedDriver" //check the jdbc
> value
>                 jdbc-uri="jdbc:cassandra://127.0.0.1/ofbiz" //check the
> jdbc value
>                 jdbc-username="ofbiz"
>                 jdbc-password-lookup="ofbiz"
>                 isolation-level="ReadCommitted"
>                 pool-minsize="2"
>                 pool-maxsize="250"
>                 time-between-eviction-runs-millis="600000"/>
>     </datasource>
>
> and set your delegator on this :
>     <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="localcassandra"/>...
>
> 3. create the field type like this :
> framework/entity/fieldtype/fieldtypecassandra.xml. Take inspiration from
> fieldtypepostgres.xml and adapt for the cassandra data base.
>
> I didn't test the process, just show you the way ;) and if it's works, all
> contribution are welcome :)
>
> Nicolas
>
>
>
>
>
> Le 07/06/2016 03:56, Naveen Metta a écrit :
>
>> Nicolas,
>> Any luck on finding free time to document Cassandra integration with
>> OFBIZ?
>>
>> Thank you. Sent from my iPhone.
>>   Naveeno Metta
>> [hidden email]
>> https://www.linkedin.com/in/naveenmetta
>>
>> On Jun 3, 2016, at 8:40 AM, Nicolas Malin <[hidden email]>
>>> wrote:
>>>
>>>
>>> Hi Naveeno, please wait I can explain howto do this but I haven't time.
>>>
>>> :) I try to find spare time this night
>>>
>>> Nicolas
>>>
>>> Le 03/06/2016 15:35, Pranay Pandey a écrit :
>>>
>>>> Hi Naveeno,
>>>>
>>>> The answer to the question-
>>>> Can OFBiz use CASSANDRA as Database?
>>>> will be Yes, but based on my understanding as of now there is no direct
>>>> configuration settings available in OOTB OFBiz for the same. It may
>>>> require
>>>> some work to get it working with Cassandra.
>>>>
>>>> Let's wait and see what other community members have to say about it.
>>>>
>>>>
>>>> Best regards,
>>>>
>>>> Pranay Pandey
>>>> HotWax Systems
>>>> http://www.hotwaxsystems.com/
>>>>
>>>> On Fri, Jun 3, 2016 at 6:24 PM, Naveen Metta <[hidden email]>
>>>> wrote:
>>>>
>>>> Can ofbiz  use CASSANDRA as DAtabase?
>>>>>
>>>>> Thank you. Sent from my iPhone.
>>>>>
>>>>> Naveeno Metta
>>>>> [hidden email]
>>>>> https://www.linkedin.com/in/naveenmetta
>>>>>
>>>>> On Jun 2, 2016, at 10:11 PM, Naveen Metta <[hidden email]>
>>>>>>>
>>>>>> wrote:
>>>>>> Hi all,
>>>>>> Is anyone can point me in right direction for how to integrate Ofbiz
>>>>>>
>>>>> with Cassandra Database.
>>>>>
>>>>>> Thank you.
>>>>>>
>>>>>> Naveeno Metta
>>>>>> [hidden email]
>>>>>> https://www.linkedin.com/in/naveenmetta
>>>>>>
>>>>>
>