Oracle: Timestamp Displays Incorrectly

This will require Data Admin privileges to setup implementation.

Summary

When certain versions of the Oracle JDBC driver are used by iDashboards, values read from TIMESTAMP columns are not displayed properly in iDashboards. Please see the attached document for more information. When certain versions of the Oracle JDBC driver are used by iDashboards, values read from TIMESTAMP columns are not displayed properly in iDashboards.

Reason

This happens because Oracle drivers return the Java type oracle.sql.TIMESTAMP for values in TIMESTAMP columns, instead of java.sql.Timestamp as mandated by the JDBC standard.

Resolution

Fortunately, Oracle provides a way to invoke the standards-compliant behavior required by iDashboards. This is accomplished by setting the following driver property for the Oracle data source:

oracle.jdbc.J2EE13Compliant=true

For an Oracle data source: iDashboards Admin edit the data source, in the Edit a Data Source window the paste the above line in the Optional Driver Properties.

If iDashboards is reading the data from its repository database, the driver property can be set by adding the following line to the ivizgroup.properties file, and restarting the application server:

db.driverProperties=oracle.jdbc.J2EE13Compliant=true

When multiple driver properties must be set, the name=value pairs should be separated by semicolons:

oracle.jdbc.J2EE13Compliant=true;oracle.jdbc.V8Compatible=true

For More Information:

• Oracle JDBC Driver Download
• Oracle Database Documentation
• Oracle JDBC Driver Documentation
• iDashboards Admin Manual 10. Managing Data Sources

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.