I use to use MS-SQL but stopped at ver 7. I still run them. I use the jtds drivers. I now use postgressql exclusively, so I am not much help as to quirks of 2005. on of the ways I tested if it was the SQL server is I made the SP permanent under a different name then wrote code to call them, from the SQL server it self. This let me know if the server had a problem with the procedure. I have a feeling that the problem is MS-SQL and/or the jbc driver.
mayo sent the following on 4/25/2009 6:28 AM: > Also, I am very surprised no one else has had this error. This tells me that > it is some other setting on the server or the driver, but what I've found > are definitely facts: > - OFBiz freezes in wait when it tries to execute RUNTIME_DATA through the > path of executing dispatcher.runAsync > - the database shows 2 blocked processes, the last of which was created by > runAsync > - the problem happens with 2 separate MSSQL jdbc drivers > - the blocker process last executes "sp_cursorclose" > - kill the blocker process and OFBiz unfreezes -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
