SAP Knowledge Base Article - Preview

2832476 - jConnect heap memory issue - SDK for SAP ASE

Symptom

  • From jConnect 16.0 SP03 PL06, heap memory usage may be higher than before when either javax.sql.ConnectionPoolDataSource or javax.sql.PooledConnection is used for connection pooling.
  • java.lang.OutOfMemoryError may be seen when so many PreparedStatement objects are created on a connection before returning it to the connection pool.
  • You might see SybConnectionProxy or SybPreparedStatementProxy in a java.lang.OutOfMemoryError stack trace.

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
      at java.lang.AbstractStringBuilder.<init>(AbstractStringBuilder.java:64) at java.lang.StringBuilder.<init>(StringBuilder.java:85)
      at com.sybase.jdbc4.jdbc.SybConnection.getClientInfo(SybConnection.java:4616)
      at com.sybase.jdbc4.tds.PduOutputFormatter.isEncryptionEnabled(PduOutputFormatter.java:358)
      at com.sybase.jdbc4.tds.PduOutputFormatter.write(PduOutputFormatter.java:293)
      at com.sybase.jdbc4.tds.TdsOutputStream.write(TdsOutputStream.java:77)
      at com.sybase.jdbc4.tds.TdsOutputStream.writeInt(TdsOutputStream.java:173)
      at com.sybase.jdbc4.tds.DataFormat.send(DataFormat.java:615)
      at com.sybase.jdbc4.tds.TdsParam.sendFormat(TdsParam.java:1103)
      at com.sybase.jdbc4.tds.ParamFormatToken.sendAddBatch(ParamFormatToken.java:205)
      at com.sybase.jdbc4.tds.Tds.sendDynamicExecuteParams(Tds.java:1749)
      at com.sybase.jdbc4.tds.Tds.dynamicExecute(Tds.java:1539)
      at com.sybase.jdbc4.jdbc.SybPreparedStatement.sendQuery(SybPreparedStatement.java:3158)
      at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2642)
      at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:279)
      at com.sybase.jdbc4.jdbc.SybPreparedStatementProxy.executeQuery(SybPreparedStatementProxy.java:656)


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 (is version JDBC 7.07)
  • java

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

CR#819900, CR819900, 819900, java, jdbc, jconn4, jconn4.jar , KBA , BC-SYB-SDK , SDK , 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.