Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Database Performance Analyzer (DPA) > Sybase DYNAMIC_SQL (No SQL text reported by database)

Sybase DYNAMIC_SQL (No SQL text reported by database)

Updated March 14, 2017


SQL texts are missing for some items in Sybase ASE 15.7.


  • Sybase ASE 15.7
  • All DPA versions 


This behavior is normally seen with Java and jTDS when specific options are used and the same session executes more than one query, one of which is a prepared statement. The options are: jTDS property: "prepareSQL=1" session property: "SET QUOTED_IDENTIFIER OFF"

It has to do with how jTDS is using Sybase's prepared SQL and it seems to occur when you use the same session to run the the same query multiple times 
(ie. they are probably using a connection pool). It is an optimization that occurs.


Request the Java developers to change the jTDS connection.
URL to specify prepareSQL=2 or prepareSQL=3 rather than the default of 1. 

You can find more information about jTDS and prepareSQL here:


prepareSQL (default - 3 for SQL Server, 1 for Sybase)
This parameter specifies the mechanism used for Prepared Statements.
    Value Description
    0 SQL is sent to the server each time without any preparation, literals are inserted in the SQL (slower)
    1 Temporary stored procedures are created for each unique SQL statement and parameter combination (faster)
    2 sp_executesql is used (fast)
    3 sp_prepare and sp_cursorprepare are used in conjunction with sp_execute and sp_cursorexecute (faster, SQL Server only)


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.



Last modified