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.
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.
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:
To set this driver property for an Oracle data source, open its properties screen in the iDashboards Admin application, and enter the above line in the field labeled "Optional Driver Properties”
If iDashboards is reading the data from its repository database (which may also be used as a data
source), the driver property can be set by adding the following line to the ivizgroup.properties file, and restarting the application server:
When multiple driver properties must be set, the "name=value" pairs should be separated by semicolons, for example:
Further information on setting driver properties is available in the iDashboards Admin manual.
- X Platform
- Enterprise Suite