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

0. Create report connected to Oracle through JDBC
0. Add date parameter to Records Selection formula
0. 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:

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

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