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:[email protected]] > Sent: Friday, April 24, 2009 4:08 PM > To: [email protected] > 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 >> [email protected]%3e >> >> http://lists.ofbiz.org/pipermail/users/2004-January/002819.html >> >> >> -----Original Message----- >> From: BJ Freeman [mailto:[email protected]] >> Sent: Thursday, April 23, 2009 4:23 PM >> To: [email protected] >> 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.
