Integration Issues(REST/SOAP) for the latest version 16.11 release in SVN

[Lanzjess]

Hi OFBiz Dev/Admin Team,

Good day! Currently, most of my concern is to integrate our company system
to
OFBiz Accounting module. I am following the tutorial but I am currently
experiencing bugs/bottlenecks such as in connecting to a legacy db and the
the SOAP RPC example integration with LifeRay(https://cwiki.apache.
org/confluence/display/OFBIZ/Calling+OFBiz+services+from+Liferay+using+SOAP).
I am missing the correct jars. As I see there are deprecated tutorials, I
don't know which one will fit the release 16.11 svn release. For this, I
created an issue in stackoverflow.com which is
https://stackoverflow.com/questions/45569501/how-to-pass-dat
a-from-a-remote-database-into-ofbiz-database

Now, I am trying the REST approach in https://cwiki.apache.org/confl
uence/display/OFBIZ/REST+Service+Implementation


As a summary, I am passing payment info from a separate JSF application
towards OFBiz Accounting module. So as I look in the OFBiz documentation,
there are several ways... 1. By reading XML file 2. Via connecting to a
legacy db 3. By SOAP RPC 4. Via REST. So the tutorials from 2,3,4 methods
are very limited and missing details. And I don't know even it works in the
latest version of 16.11 updated svn link.

Platform Summary:

Eclipse Oxygen(OFBiz)
Netbeans IDE(Remote Application/Our PrimeFace-JSF application)
Ubuntu 16.04
For SOAP RPC client :
     -jaxrpc-api-1.1.jar
     -wsdl4j.jar
     -axis-1.4.jar
     -commons-discovery-0.5.jar

I hope you can help me find the necessary tutorial for the integration.
Thanks a lot!

Regards,

--
*Allan L. Zarsuela*

[Nicolas Malin-2]

Hi Allan,

I look your issue on Stackoverflow and I not understand what you tried
to do with the legacy-db.

How you connect on this db, where is define the data model relative to
this db. Do you define some crud service relative to entities that you
want to expose ?

Nicolas

Le 10/08/2017 à 08:12, Allan Zarsuela a écrit :

> Hi OFBiz Dev/Admin Team,
>
> Good day! Currently, most of my concern is to integrate our company system
> to
> OFBiz Accounting module. I am following the tutorial but I am currently
> experiencing bugs/bottlenecks such as in connecting to a legacy db and the
> the SOAP RPC example integration with LifeRay(https://cwiki.apache.
> org/confluence/display/OFBIZ/Calling+OFBiz+services+from+Liferay+using+SOAP).
> I am missing the correct jars. As I see there are deprecated tutorials, I
> don't know which one will fit the release 16.11 svn release. For this, I
> created an issue in stackoverflow.com which is
> https://stackoverflow.com/questions/45569501/how-to-pass-dat
> a-from-a-remote-database-into-ofbiz-database
>
> Now, I am trying the REST approach in https://cwiki.apache.org/confl
> uence/display/OFBIZ/REST+Service+Implementation
>
>
> As a summary, I am passing payment info from a separate JSF application
> towards OFBiz Accounting module. So as I look in the OFBiz documentation,
> there are several ways... 1. By reading XML file 2. Via connecting to a
> legacy db 3. By SOAP RPC 4. Via REST. So the tutorials from 2,3,4 methods
> are very limited and missing details. And I don't know even it works in the
> latest version of 16.11 updated svn link.
>
> Platform Summary:
>
> Eclipse Oxygen(OFBiz)
> Netbeans IDE(Remote Application/Our PrimeFace-JSF application)
> Ubuntu 16.04
> For SOAP RPC client :
>       -jaxrpc-api-1.1.jar
>       -wsdl4j.jar
>       -axis-1.4.jar
>       -commons-discovery-0.5.jar
>
> I hope you can help me find the necessary tutorial for the integration.
> Thanks a lot!
>
> Regards,
>

[Michael Brohl-3]

Hi Allan,

to find the best solution, it would be helpful to know your requirements
for the interface between your system and OFBiz.

In some cases, it might be a good solution to have an asynchronous
interface like a file import (e.g. if you have thousands of payment
infos in a short amount of time, or if you want to be able to preserve
and reimport your data in case of failure, etc.).

In other cases, a web service interface like REST or a messaging
solution like JMS can be helpful. It depends on your requirements and
environment parameters...

It's easy to provide your own services as REST services taking JSON data
from a specific URL, read, parse and convert it and call the standard
services to write data to the OFBiz database. You don't necessarily need
a REST framework for this (although it would be great if we have a
standard OFBiz way to deal with REST).

I think connecting to a legacy db (which should be read only if updated
from other applications than OFBiz) is uncommon in your case. You would
have to monitor the legacy db or put some ECA's/triggers on it to be
noticed about the changes and write the data to the OFBiz database on
these events. For my taste it would tie the systems together instead of
having them loosely coupled.

Best regards,

Michael Brohl
ecomify GmbH
www.ecomify.de


Am 10.08.17 um 08:12 schrieb Allan Zarsuela:

> Hi OFBiz Dev/Admin Team,
>
> Good day! Currently, most of my concern is to integrate our company system
> to
> OFBiz Accounting module. I am following the tutorial but I am currently
> experiencing bugs/bottlenecks such as in connecting to a legacy db and the
> the SOAP RPC example integration with LifeRay(https://cwiki.apache.
> org/confluence/display/OFBIZ/Calling+OFBiz+services+from+Liferay+using+SOAP).
> I am missing the correct jars. As I see there are deprecated tutorials, I
> don't know which one will fit the release 16.11 svn release. For this, I
> created an issue in stackoverflow.com which is
> https://stackoverflow.com/questions/45569501/how-to-pass-dat
> a-from-a-remote-database-into-ofbiz-database
>
> Now, I am trying the REST approach in https://cwiki.apache.org/confl
> uence/display/OFBIZ/REST+Service+Implementation
>
>
> As a summary, I am passing payment info from a separate JSF application
> towards OFBiz Accounting module. So as I look in the OFBiz documentation,
> there are several ways... 1. By reading XML file 2. Via connecting to a
> legacy db 3. By SOAP RPC 4. Via REST. So the tutorials from 2,3,4 methods
> are very limited and missing details. And I don't know even it works in the
> latest version of 16.11 updated svn link.
>
> Platform Summary:
>
> Eclipse Oxygen(OFBiz)
> Netbeans IDE(Remote Application/Our PrimeFace-JSF application)
> Ubuntu 16.04
> For SOAP RPC client :
>       -jaxrpc-api-1.1.jar
>       -wsdl4j.jar
>       -axis-1.4.jar
>       -commons-discovery-0.5.jar
>
> I hope you can help me find the necessary tutorial for the integration.
> Thanks a lot!
>
> Regards,
>

[Lanzjess]

Hi Nicholas and Michael,

Thank you for your response! The basic requirement is to push the values
from a real estate application necessary for OFBiz accounting.So obviously
this requires web services triggered in client remote app(real estate
property manager) controller action(per payment) or in it's schedule
jobs(passing payment data by bulk). Then I checked some tutorial of OFBiz
about web services: It includes this example of legacy db as datasource;
the next one is using Axis to access via rpc wsdl to access the OFBiz
webservice. I was also trying to do the REST where in I would create a
resource POJOs in a OFBiz customize component, but it was not clear yet for
me.

Lately, I was able to make the Axis2 web service via creating a client
program to insert record to OFBiz accounting tables.
I followed this tutorial
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=9798255.

So at first, I was just trying out how to make a simple connection via web
service following OFBiz Documentation
to trace how creating a payment transaction works. I am still have to check
deeper in using ECA and JMS.
But as of now, I already tested inserting record for payment, person, fixed
asset via Axis2 web service client.

Regards,

On Sat, Aug 12, 2017 at 5:08 AM, Michael Brohl <[hidden email]>
wrote:

> Hi Allan,
>
> to find the best solution, it would be helpful to know your requirements
> for the interface between your system and OFBiz.
>
> In some cases, it might be a good solution to have an asynchronous
> interface like a file import (e.g. if you have thousands of payment infos
> in a short amount of time, or if you want to be able to preserve and
> reimport your data in case of failure, etc.).
>
> In other cases, a web service interface like REST or a messaging solution
> like JMS can be helpful. It depends on your requirements and environment
> parameters...
>
> It's easy to provide your own services as REST services taking JSON data
> from a specific URL, read, parse and convert it and call the standard
> services to write data to the OFBiz database. You don't necessarily need a
> REST framework for this (although it would be great if we have a standard
> OFBiz way to deal with REST).
>
> I think connecting to a legacy db (which should be read only if updated
> from other applications than OFBiz) is uncommon in your case. You would
> have to monitor the legacy db or put some ECA's/triggers on it to be
> noticed about the changes and write the data to the OFBiz database on these
> events. For my taste it would tie the systems together instead of having
> them loosely coupled.
>
> Best regards,
>
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
>
>
> Am 10.08.17 um 08:12 schrieb Allan Zarsuela:
>
> Hi OFBiz Dev/Admin Team,
>>
>> Good day! Currently, most of my concern is to integrate our company system
>> to
>> OFBiz Accounting module. I am following the tutorial but I am currently
>> experiencing bugs/bottlenecks such as in connecting to a legacy db and the
>> the SOAP RPC example integration with LifeRay(https://cwiki.apache.
>> org/confluence/display/OFBIZ/Calling+OFBiz+services+from+Lif
>> eray+using+SOAP).
>> I am missing the correct jars. As I see there are deprecated tutorials, I
>> don't know which one will fit the release 16.11 svn release. For this, I
>> created an issue in stackoverflow.com which is
>> https://stackoverflow.com/questions/45569501/how-to-pass-dat
>> a-from-a-remote-database-into-ofbiz-database
>>
>> Now, I am trying the REST approach in https://cwiki.apache.org/confl
>> uence/display/OFBIZ/REST+Service+Implementation
>>
>>
>> As a summary, I am passing payment info from a separate JSF application
>> towards OFBiz Accounting module. So as I look in the OFBiz documentation,
>> there are several ways... 1. By reading XML file 2. Via connecting to a
>> legacy db 3. By SOAP RPC 4. Via REST. So the tutorials from 2,3,4 methods
>> are very limited and missing details. And I don't know even it works in
>> the
>> latest version of 16.11 updated svn link.
>>
>> Platform Summary:
>>
>> Eclipse Oxygen(OFBiz)
>> Netbeans IDE(Remote Application/Our PrimeFace-JSF application)
>> Ubuntu 16.04
>> For SOAP RPC client :
>>       -jaxrpc-api-1.1.jar
>>       -wsdl4j.jar
>>       -axis-1.4.jar
>>       -commons-discovery-0.5.jar
>>
>> I hope you can help me find the necessary tutorial for the integration.
>> Thanks a lot!
>>
>> Regards,
>>
>>
>
>

--
*Allan L. Zarsuela*

*Software Developer*