[OFBiz] Dev - MS SQL Server and Cancel Orders

[bjfree at free-man.net]

looks like your using the TDS driver, you might check that you have the
latest version.
or use the MS-SQL server drivers for 2K and above.

-----Original Message-----
From: Denny Breitenfeld [mailto:denny at exlcom.com]
Sent: Monday, April 04, 2005 1:50 PM
To: dev at lists.ofbiz.org
Subject: [OFBiz] Dev - MS SQL Server and Cancel Orders 


Hi, 

  I've searched the wiki, the mailing list, google, MSN's new search server,
and I've also debuged the problem. Unfortunatly I can't find an answer to
the problem.  When I cancel an order I'm getting the following hang:  (this
is the stack trace). 

Thread [PoolThread-4] (Suspended) 
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int, int)   
line: not available [native method] 
SocketInputStream.read(byte[], int, int) line: not available 
UtilSocketDataProvider.getArrayOfBytes(byte[], int, int) line: not   
available 
UtilBufferedDataProvider.cacheNextBlock() line: not available 
UtilBufferedDataProvider.getArrayOfBytes(byte[], int, int) line: not   
available 
SQLServerDepacketizingDataProvider.signalStartOfPacket() line: not   
available 

SQLServerDepacketizingDataProvider(UtilDepacketizingDataProvider).getAr 
rayOfBytes(byte[], int, int) line: not available 
UtilPagedTempBuffer.write(long, UtilDataProvider, int) line: not   
available 
UtilPagedTempBuffer.write(UtilDataProvider) line: not available 
UtilByteArrayDataProvider.receive() line: not available 
UtilByteOrderedDataReader.receive() line: not available 
TDSCursorRequest(TDSRPCRequest).submitRequest() line: not available 
TDSCursorRequest.sendCursorFetch(int, int, BaseWarnings) line: not   
available 
TDSCursorRequest.openCursor(BaseWarnings) line: not available 
SQLServerImplStatement.execute() line: not available 
BasePreparedStatement(BaseStatement).commonExecute() line: not   
available 
BasePreparedStatement(BaseStatement).executeQueryInternal() line: not   
available 
BasePreparedStatement.executeQuery() line: not available 
SQLProcessor.executeQuery() line: 373 
GenericDAO.selectListIteratorByCondition(ModelEntity,   
EntityCondition, EntityCondition, Collection, List, EntityFindOptions)   
line: 831 
GenericDAO.selectByAnd(ModelEntity, Map, List) line: 632 
GenericHelperDAO.findByAnd(ModelEntity, Map, List) line: 147 
GenericDelegator.findByAnd(ModelEntity, Map, List) line: 852 
GenericDelegator.findByAnd(String, Map, List) line: 837 
GenericDelegator.getRelated(String, Map, List, GenericValue) line:   
1338 
GenericDelegator.getRelated(String, GenericValue) line: 1284 
GenericValue.getRelated(String) line: 125 
OrderReadHelper.getOrderItems() line: 687 
OrderReadHelper.getValidOrderItems() line: 699 
OrderReadHelper.getOrderGrandTotal() line: 655 
OrderServices.resetGrandTotal(DispatchContext, Map) line: 581 
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not   
available [native method] 
NativeMethodAccessorImpl.invoke(Object, Object[]) line: not available   
[local variables unavailable] 
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: not   
available [local variables unavailable] 
Method.invoke(Object, Object[]) line: not available [local variables   
unavailable] 
StandardJavaEngine.serviceInvoker(String, ModelService, Map) line: 101 
StandardJavaEngine.runSync(String, ModelService, Map) line: 63 
ServiceDispatcher.runSync(String, ModelService, Map, boolean) line:   
280 
ServiceDispatcher.runSync(String, ModelService, Map) line: 171 
WebAppDispatcher(GenericDispatcher).runSync(String, Map) line: 110 
ServiceEcaAction.runAction(String, DispatchContext, Map, Map) line: 77 
ServiceEcaRule.eval(String, DispatchContext, Map, Map, boolean, Set)   
line: 124 
ServiceEcaUtil.evalRules(String, Map, String, DispatchContext, Map,   
Map, boolean) line: 165 
ServiceDispatcher.runSync(String, ModelService, Map, boolean) line:   
304 
ServiceDispatcher.runSync(String, ModelService, Map) line: 171 
WebAppDispatcher(GenericDispatcher).runSync(String, Map) line: 110 
ServiceEventHandler.invoke(String, String, HttpServletRequest,   
HttpServletResponse) line: 178 
RequestHandler.runEvent(HttpServletRequest, HttpServletResponse,   
String, String, String) line: 363 
RequestHandler.doRequest(HttpServletRequest, HttpServletResponse,   
String, GenericValue, GenericDelegator) line: 238 
ControlServlet.doGet(HttpServletRequest, HttpServletResponse) line:   
187 
ControlServlet(HttpServlet).service(HttpServletRequest,   
HttpServletResponse) line: 740 
ControlServlet(HttpServlet).service(ServletRequest, ServletResponse)   
line: 853 
ServletHolder.handle(ServletRequest, ServletResponse) line: 354 
WebApplicationHandler$Chain.doFilter(ServletRequest, ServletResponse)   
line: 342 
ContextFilter.doFilter(ServletRequest, ServletResponse, FilterChain)   
line: 228 
WebApplicationHandler$Chain.doFilter(ServletRequest, ServletResponse)   
line: 334 
WebApplicationHandler.dispatch(String, HttpServletRequest,   
HttpServletResponse, ServletHolder) line: 286 
WebApplicationHandler(ServletHandler).handle(String, String,   
HttpRequest, HttpResponse) line: 567 
WebApplicationContext(HttpContext).handle(String, String,   
HttpRequest, HttpResponse) line: 1808 
WebApplicationContext.handle(String, String, HttpRequest,   
HttpResponse) line: 525 
WebApplicationContext(HttpContext).handle(HttpRequest, HttpResponse)   
line: 1758 
Server(HttpServer).service(HttpRequest, HttpResponse) line: 879 
HttpConnection.service(HttpRequest, HttpResponse) line: 790 
HttpConnection.handleNext() line: 952 
HttpConnection.handle() line: 807 
SunJsseListener(SocketListener).handleConnection(Socket) line: 197 
SunJsseListener(ThreadedServer).handle(Object) line: 289 
ThreadPool$PoolThread.run() line: 501 


I'm using MSSQL Server 8.0 and it has unlimited connections.  I read in a
previous mailing that there is a lock on one of the rows, and this caused a
hang before. However I then read a fix was put in, and this was in 2004 so
i'm not sure if it is the same problem. 

Thanks for your help! 

Denny 
 
_______________________________________________
Dev mailing list
Dev at lists.ofbiz.org
http://lists.ofbiz.org/mailman/listinfo/dev