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

SAP Knowledge Base Article - Public

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

Symptom

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

This behavior affects reports performance.

Environment

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 

Resolution

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:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#08_01

Keywords

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

Product

SAP Crystal Reports XI