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 ONE Support launchpad (Login required).

Search for additional results

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