You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Sanders, Brian" <BS...@connextions.com> on 2009/04/21 18:32:46 UTC
SQL Server JDBC driver
I just wanted to get some feedback as to which JDBC driver anyone would
recommend to use for SQL Server.
Brian Sanders
Application Support Analyst
Connextions, Inc.
3600 eCommerce Place
Orlando, FL 32808
main: 407.926.2400
cell: 407.765.9817
bsanders@connextions.com
www.connextions.com
RE: SQL Server JDBC driver
Posted by "Sanders, Brian" <BS...@connextions.com>.
I meant in regards to OFBiz. I went ahead and used the official driver,
installed the XA and now we have a new issue. We wrote some custom code
which takes XML order data to create an order. The app gets stuck when
trying to authorize the card because AIMPaymentServices.
buildCustomerBillingInfo() is attempting to get the postal address
associated with the credit card (GenericValue address =
creditCard.getRelatedOne("PostalAddress");). While I'm not quite sure
what the issue is, I suspect that is has something to do with XA. Our
import process creates all this info, then calls the service to create
the order. It seems that it hangs when getting the postal address
because that data is in another transaction that has not been committed.
Basically, it seems that distributed transactions are not working/being
used. I found some similar posts on the internet, but no solutions. BTW,
I'm using 4.0. Thanks.
http://mail-archives.apache.org/mod_mbox/ofbiz-user/200708.mbox/%3C46CC3
BBB.2050705@salmonllc.com%3E
http://lists.ofbiz.org/pipermail/users/2004-January/002819.html
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Thursday, April 23, 2009 4:23 PM
To: user@ofbiz.apache.org
Subject: Re: SQL Server JDBC driver
that is best ask at the forum for the particular SQL server your are
going to use.
Sanders, Brian sent the following on 4/21/2009 9:32 AM:
>> I just wanted to get some feedback as to which JDBC driver anyone
would
>> recommend to use for SQL Server.
>>
>>
>>
>> Brian Sanders
>>
>> Application Support Analyst
>>
>
Re: SQL Server JDBC driver
Posted by BJ Freeman <bj...@free-man.net>.
that is best ask at the forum for the particular SQL server your are
going to use.
Sanders, Brian sent the following on 4/21/2009 9:32 AM:
>> I just wanted to get some feedback as to which JDBC driver anyone would
>> recommend to use for SQL Server.
>>
>>
>>
>> Brian Sanders
>>
>> Application Support Analyst
>>
>
Re: SQL Server JDBC driver
Posted by BJ Freeman <bj...@free-man.net>.
that is best ask at the forum for the particular SQL server your are
going to use.
Sanders, Brian sent the following on 4/21/2009 9:32 AM:
> I just wanted to get some feedback as to which JDBC driver anyone would
> recommend to use for SQL Server.
>
>
>
> Brian Sanders
>
> Application Support Analyst
>
Re: SQL Server JDBC driver
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
No option to edit the message that has been sent on the mailing list.
One way traffic ... so be careful from next time ;).
--
Ashish
On Tue, Apr 21, 2009 at 10:08 PM, Sanders, Brian
<BS...@connextions.com>wrote:
> Oops. Is it possible to edit my initial message so that contact info
> doesn't leak to the inernet?
>
RE: SQL Server JDBC driver
Posted by mayo <al...@hotmail.com>.
Sorry for the lack of details BJ. I have started a new thread with some more
details for our issue:
http://www.nabble.com/MS-SQL-and-OFBiz%2C-database-locks-on-transactions-td23225473.html
We would really appreciate it if you could give us your thoughts.
bsanders1979 wrote:
>
> where are you hooking into the order processing? Not quite sure what you
> mean, but it's an OFBiz service which accepts/processes the XML.
>
> are you following the flow of the normal order processing? Works fine
> with MySql
>
> is the payment processing using the ProductStore for determining the
> payment processor Aim? I believe so because the import code is calling
> CheckoutHelper.processPayment().
>
> All this stuff works fine with MySql, but we are opting to go with Sql
> Server 2005 in order to gain support from our DBAs.
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Friday, April 24, 2009 4:08 PM
> To: user@ofbiz.apache.org
> Subject: Re: SQL Server JDBC driver
>
> Little more clarity if you don't mind
> where are you hooking into the order processing?
> are you following the flow of the normal order processing?
> is the payment processing using the ProductStore for determining the
> payment processor Aim.
>
> Sanders, Brian sent the following on 4/24/2009 12:49 PM:
>> I meant in regards to OFBiz. I went ahead and used the official
> driver,
>> installed the XA and now we have a new issue. We wrote some custom
> code
>> which takes XML order data to create an order. The app gets stuck when
>> trying to authorize the card because AIMPaymentServices.
>> buildCustomerBillingInfo() is attempting to get the postal address
>> associated with the credit card (GenericValue address =
>> creditCard.getRelatedOne("PostalAddress");). While I'm not quite sure
>> what the issue is, I suspect that is has something to do with XA. Our
>> import process creates all this info, then calls the service to create
>> the order. It seems that it hangs when getting the postal address
>> because that data is in another transaction that has not been
> committed.
>> Basically, it seems that distributed transactions are not
> working/being
>> used. I found some similar posts on the internet, but no solutions.
> BTW,
>> I'm using 4.0. Thanks.
>>
>>
> http://mail-archives.apache.org/mod_mbox/ofbiz-user/200708.mbox/%3C46CC3
>> BBB.2050705@salmonllc.com%3E
>>
>> http://lists.ofbiz.org/pipermail/users/2004-January/002819.html
>>
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: Thursday, April 23, 2009 4:23 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: SQL Server JDBC driver
>>
>> that is best ask at the forum for the particular SQL server your are
>> going to use.
>>
>> Sanders, Brian sent the following on 4/21/2009 9:32 AM:
>>>> I just wanted to get some feedback as to which JDBC driver anyone
>> would
>>>> recommend to use for SQL Server.
>>>>
>>>>
>>>>
>>>> Brian Sanders
>>>>
>>>> Application Support Analyst
>>>>
>>
>>
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
> Systems Integrator.
>
>
>
--
View this message in context: http://www.nabble.com/SQL-Server-JDBC-driver-tp23160037p23225557.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: SQL Server JDBC driver
Posted by "Sanders, Brian" <BS...@connextions.com>.
Oops. Is it possible to edit my initial message so that contact info
doesn't leak to the inernet?