You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Eric <er...@free.fr> on 2008/05/21 02:49:16 UTC
external banking service of credit card payment (Sherlocks by Atos Origin)
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
Re: Re : CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Jacopo Cappellato <ja...@gmail.com>.
This is good news.
If you are willing to contribute your work, just create a new Jira
issue and attach your patch to it.
Kind regards,
Jacopo
On May 22, 2008, at 12:45 PM, Eric DE MAULDE wrote:
> 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
>
>
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Jacques Le Roux <ja...@les7arts.com>.
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
>>
>>
>
Re : CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by 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
>
>
Re: external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Jacques Le Roux <ja...@les7arts.com>.
And please use rather user ML for such questions :
http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@ofbiz.apache.org
Thanks
Jacques
From: "Raj Saini" <ra...@gmail.com>
>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
>>>
>>>
>>
>>
>
Re: external banking service of credit card payment (Sherlocks by
Atos Origin)
Posted by Raj Saini <ra...@gmail.com>.
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
>>
>>
>
>
Re: external banking service of credit card payment (Sherlocks by Atos Origin)
Posted by Eric <er...@free.fr>.
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
>
>
Re: external banking service of credit card payment (Sherlocks by
Atos Origin)
Posted by Raj Saini <ra...@gmail.com>.
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
>