SAP Knowledge Base Article - Public

1491915 - How to suppress TimeStamp function in SQL statement for JDBC connection to Oracle


Crystal Reports adds a timestamp {ts ...} to date parameter in SQL statement sent through JDBC connection to Oracle database.

This behavior affects reports performance.


Java application

Reproducing the Issue

  1. Create report connected to Oracle through JDBC
  2. Add date parameter to Records Selection formula
  3. Evaluate the SQL Query sent to the database

There is a timestamp {ts..} in date parameter 


It could be resolved by adding the following line to Java application:

            java -Doracle.jdbc.V8Compatible="true" ProgramName

See the following link for more details:


KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , How To


SAP Crystal Reports XI