SAP Knowledge Base Article - Preview

2243469 - Large batches of JDBC prepared statements may appear to hang - SAP ASE

Symptom

  • A JDBC program using prepared statements and large batch sizes appears to hang.
  • If you run DBCC STACKTRACE from another connection:

DBCC TRACEON(3604)
go
DBCC STACKTRACE(<hung spid>)
go

   You can see the stacktrace which includes the functions:

ussflush
sendbuffer
either senddone or s_setreturns


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

jconnect, preparedStatement, callableStatement, doneinproc, java, addBatch, executeBatch, ussflush, sendbuffer, senddone, s_setreturns, 792306 , CR792306, EARLY_BATCH_READ_THRESHOLD , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.