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.
Comments
0 comments
Please sign in to leave a comment.