SQL Server JDBC driver
Locked
 
|
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 [hidden email] www.connextions.com |
|
|
Oops. Is it possible to edit my initial message so that contact info
doesn't leak to the inernet? |
|
|
In reply to this post by bsanders1979
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
|
|
In reply to this post by bsanders1979
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 <[hidden email]>wrote: > Oops. Is it possible to edit my initial message so that contact info > doesn't leak to the inernet? > |
|
|
In reply to this post by BJ Freeman
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 >> > |
|
|
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 [hidden email]%3E http://lists.ofbiz.org/pipermail/users/2004-January/002819.html -----Original Message----- From: BJ Freeman [mailto:[hidden email]] Sent: Thursday, April 23, 2009 4:23 PM To: [hidden email] 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 >> > |
|
|
In reply to this post by bsanders1979
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 > [hidden email]%3E > > http://lists.ofbiz.org/pipermail/users/2004-January/002819.html > > > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Thursday, April 23, 2009 4:23 PM > To: [hidden email] > 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. |
|
|
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:[hidden email]] Sent: Friday, April 24, 2009 4:08 PM To: [hidden email] 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 > [hidden email]%3E > > http://lists.ofbiz.org/pipermail/users/2004-January/002819.html > > > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Thursday, April 23, 2009 4:23 PM > To: [hidden email] > 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. |
|
|
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.
|
|
|
In reply to this post by bsanders1979
Ok this is a known problem with 4.0
you have to do an upgrade of the pool. there is some docs, i think if not there was a email with the patches, but i don't have time to look it up for you. Sanders, Brian sent the following on 4/24/2009 1:33 PM: > 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:[hidden email]] > Sent: Friday, April 24, 2009 4:08 PM > To: [hidden email] > 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 >> [hidden email]%3E >> >> http://lists.ofbiz.org/pipermail/users/2004-January/002819.html >> >> >> -----Original Message----- >> From: BJ Freeman [mailto:[hidden email]] >> Sent: Thursday, April 23, 2009 4:23 PM >> To: [hidden email] >> 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. |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |