You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2008/05/22 13:53:58 UTC
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Hi Eric,
Is it some code you could throw in trunk ?
Jacques
From: "Eric DE MAULDE" <er...@free.fr>
> My Response Servlet works well.
> I mixed between WorldPay and Paypal examples.
> I use the "LinkedList" of the PaypalExample in the "setPaymentPreference"
> method.
>
> Sherlocks works !!!
> It's very effective for European webmasters
>
> Thanks
>
> Eric
>
>
>>I think your payment details (Credit card number etc.) are collected by
>>Shelocks. If this the case, I would suggest you to look at how Paypal
>>works. I never did this kind of integration before.
>>
>> Thanks,
>>
>> Raj
>>
>> Eric wrote:
>>> Raj, everybody,
>>>
>>> When I process to a purchase in the ecommerce web site,
>>> on the "Final Checkout Review" page (with Payment Information :
>>> "Sherlocks")
>>> here I click on "Submit order" button.
>>> This act creates a recording in the "OrderPaymentPreference" table with
>>> the statusId field "PAYMENT_NOT_RECEIVED"
>>> The next pages are my Sherlocks Request Servlet to begin the payment,
>>> then the bank server pages and at least my Sherlocks Response Servlet.
>>> Here I want to modify the same recording in order to modify the statusId
>>> field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or another
>>> status,
>>> with my Sherlocks Response Servlet (in a second time this will be an
>>> AutoResponse Servlet from bank server to Ofbiz server).
>>>
>>> My question is the same : what class / service can I use in order to
>>> modify a recording in the "OrderPaymentPreference" table ?
>>>
>>> Thank you very much
>>>
>>> Eric
>>>
>>>
>>>> Eric,
>>>>
>>>> I don't think you need to modify any of the OFBiz classes to implement a
>>>> payment processor service. The error you are getting may be due to
>>>> misconfiguration or wrong implementation for service.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>> Eric wrote:
>>>>> Hello
>>>>>
>>>>> I'm trying to implement this service.
>>>>> I'm following the WorldPay example.
>>>>> In the response (file : applications/accounting/src ...
>>>>> /thirdparty/worldpay/SelectRespServlet.java)
>>>>> I get an error (line 284) because the request to modify the
>>>>> ORDER_PAYMENT_PREFERENCE table
>>>>> is a INSERT query and not an UPDATE query, so I get
>>>>> ERROR: duplicate key violates unique constraint
>>>>> "pk_order_payment_preference"
>>>>>
>>>>> How can I use an UDPATE query in order to modify the defined row (in
>>>>> ORDER_PAYMENT_PREFERENCE table)
>>>>> and update with the external credit card payment datas from the bank
>>>>>
>>>>> What class / service have I to use in order to record external payments
>>>>> ?
>>>>>
>>>>> Thanks
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> No virus found in this incoming message.
>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>>>> Release Date: 20/05/2008 16:45
>>>>
>>>>
>>>
>>>
>>
>>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>> Release Date: 20/05/2008 16:45
>>
>>
>
IMPLEMENTATION : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Eric DE MAULDE <er...@free.fr>.
In order to implement this service to the OFBiz trunk,
I sent a request to my French bank (LCL, Le Crédit Lyonnais) and Atos Origin
_ Bank : I use the demontration key (certificate) of my bank
Their business designation of this service is "Sherlocks"
_ Atos Origin : this company is the owner of this service.
It rents this service to another banks.
Their business designation of this service is "SIPS"
I keep you up-to-date.
Eric DE MAULDE
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Jacques Le Roux <ja...@les7arts.com>.
All is very easy as soon as you have understood what you need to know (like a lot of things actually but not all ;o)
Please follow carefully http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices
Thanks
Jacques
From: "Eric DE MAULDE" <er...@free.fr>
> Yes, of course
>
> I'm not a good developer because I'm beginning to study Java
> Today I improve the management of the different banking responses
> This weekend I summarize my implementation
> And I must use the OFBiz trunk instead the Release.4.0 branch
> And after I post my "patch"
> I don't know the JIRA webtool
>
> Eric
>
>
>> Hi Eric,
>>
>> Is it some code you could throw in trunk ?
>>
>> Jacques
>>
>> From: "Eric DE MAULDE" <er...@free.fr>
>>> My Response Servlet works well.
>>> I mixed between WorldPay and Paypal examples.
>>> I use the "LinkedList" of the PaypalExample in the "setPaymentPreference"
>>> method.
>>>
>>> Sherlocks works !!!
>>> It's very effective for European webmasters
>>>
>>> Thanks
>>>
>>> Eric
>>>
>>>
>>>>I think your payment details (Credit card number etc.) are collected by
>>>>Shelocks. If this the case, I would suggest you to look at how Paypal
>>>>works. I never did this kind of integration before.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>> Eric wrote:
>>>>> Raj, everybody,
>>>>>
>>>>> When I process to a purchase in the ecommerce web site,
>>>>> on the "Final Checkout Review" page (with Payment Information :
>>>>> "Sherlocks")
>>>>> here I click on "Submit order" button.
>>>>> This act creates a recording in the "OrderPaymentPreference" table with
>>>>> the statusId field "PAYMENT_NOT_RECEIVED"
>>>>> The next pages are my Sherlocks Request Servlet to begin the payment,
>>>>> then the bank server pages and at least my Sherlocks Response Servlet.
>>>>> Here I want to modify the same recording in order to modify the
>>>>> statusId field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or
>>>>> another status,
>>>>> with my Sherlocks Response Servlet (in a second time this will be an
>>>>> AutoResponse Servlet from bank server to Ofbiz server).
>>>>>
>>>>> My question is the same : what class / service can I use in order to
>>>>> modify a recording in the "OrderPaymentPreference" table ?
>>>>>
>>>>> Thank you very much
>>>>>
>>>>> Eric
>>>>>
>>>>>
>>>>>> Eric,
>>>>>>
>>>>>> I don't think you need to modify any of the OFBiz classes to implement
>>>>>> a payment processor service. The error you are getting may be due to
>>>>>> misconfiguration or wrong implementation for service.
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Raj
>>>>>>
>>>>>> Eric wrote:
>>>>>>> Hello
>>>>>>>
>>>>>>> I'm trying to implement this service.
>>>>>>> I'm following the WorldPay example.
>>>>>>> In the response (file : applications/accounting/src ...
>>>>>>> /thirdparty/worldpay/SelectRespServlet.java)
>>>>>>> I get an error (line 284) because the request to modify the
>>>>>>> ORDER_PAYMENT_PREFERENCE table
>>>>>>> is a INSERT query and not an UPDATE query, so I get
>>>>>>> ERROR: duplicate key violates unique constraint
>>>>>>> "pk_order_payment_preference"
>>>>>>>
>>>>>>> How can I use an UDPATE query in order to modify the defined row (in
>>>>>>> ORDER_PAYMENT_PREFERENCE table)
>>>>>>> and update with the external credit card payment datas from the bank
>>>>>>>
>>>>>>> What class / service have I to use in order to record external
>>>>>>> payments ?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> No virus found in this incoming message.
>>>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>>>>>> Release Date: 20/05/2008 16:45
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> No virus found in this incoming message.
>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>>>> Release Date: 20/05/2008 16:45
>>>>
>>>>
>>>
>>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.0/1459 - Release
>> Date: 21/05/2008 17:34
>>
>>
>
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Eric DE MAULDE <er...@free.fr>.
Yes, of course
I'm not a good developer because I'm beginning to study Java
Today I improve the management of the different banking responses
This weekend I summarize my implementation
And I must use the OFBiz trunk instead the Release.4.0 branch
And after I post my "patch"
I don't know the JIRA webtool
Eric
> Hi Eric,
>
> Is it some code you could throw in trunk ?
>
> Jacques
>
> From: "Eric DE MAULDE" <er...@free.fr>
>> My Response Servlet works well.
>> I mixed between WorldPay and Paypal examples.
>> I use the "LinkedList" of the PaypalExample in the "setPaymentPreference"
>> method.
>>
>> Sherlocks works !!!
>> It's very effective for European webmasters
>>
>> Thanks
>>
>> Eric
>>
>>
>>>I think your payment details (Credit card number etc.) are collected by
>>>Shelocks. If this the case, I would suggest you to look at how Paypal
>>>works. I never did this kind of integration before.
>>>
>>> Thanks,
>>>
>>> Raj
>>>
>>> Eric wrote:
>>>> Raj, everybody,
>>>>
>>>> When I process to a purchase in the ecommerce web site,
>>>> on the "Final Checkout Review" page (with Payment Information :
>>>> "Sherlocks")
>>>> here I click on "Submit order" button.
>>>> This act creates a recording in the "OrderPaymentPreference" table with
>>>> the statusId field "PAYMENT_NOT_RECEIVED"
>>>> The next pages are my Sherlocks Request Servlet to begin the payment,
>>>> then the bank server pages and at least my Sherlocks Response Servlet.
>>>> Here I want to modify the same recording in order to modify the
>>>> statusId field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or
>>>> another status,
>>>> with my Sherlocks Response Servlet (in a second time this will be an
>>>> AutoResponse Servlet from bank server to Ofbiz server).
>>>>
>>>> My question is the same : what class / service can I use in order to
>>>> modify a recording in the "OrderPaymentPreference" table ?
>>>>
>>>> Thank you very much
>>>>
>>>> Eric
>>>>
>>>>
>>>>> Eric,
>>>>>
>>>>> I don't think you need to modify any of the OFBiz classes to implement
>>>>> a payment processor service. The error you are getting may be due to
>>>>> misconfiguration or wrong implementation for service.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Raj
>>>>>
>>>>> Eric wrote:
>>>>>> Hello
>>>>>>
>>>>>> I'm trying to implement this service.
>>>>>> I'm following the WorldPay example.
>>>>>> In the response (file : applications/accounting/src ...
>>>>>> /thirdparty/worldpay/SelectRespServlet.java)
>>>>>> I get an error (line 284) because the request to modify the
>>>>>> ORDER_PAYMENT_PREFERENCE table
>>>>>> is a INSERT query and not an UPDATE query, so I get
>>>>>> ERROR: duplicate key violates unique constraint
>>>>>> "pk_order_payment_preference"
>>>>>>
>>>>>> How can I use an UDPATE query in order to modify the defined row (in
>>>>>> ORDER_PAYMENT_PREFERENCE table)
>>>>>> and update with the external credit card payment datas from the bank
>>>>>>
>>>>>> What class / service have I to use in order to record external
>>>>>> payments ?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> No virus found in this incoming message.
>>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>>>>> Release Date: 20/05/2008 16:45
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>> --
>>> No virus found in this incoming message.
>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 -
>>> Release Date: 20/05/2008 16:45
>>>
>>>
>>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.0/1459 - Release
> Date: 21/05/2008 17:34
>
>