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

• 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
followed by one or more of
senddone, send_done, sendhost, s_setreturns

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

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