Jump to content
Changes to the Jaspersoft community edition download ×

Handling oracle.sql.TIMESTAMP in JasperReports Server?


Recommended Posts


I am currently evaluating JasperReports Server for upgrading our existing JasperReports module in an existing governemental managmenet software ecosystem. So far we have generated all reports through a custom (in-house development) reporting server and we would like to move some functionality away from reports and towards interactive dashboards. In order to do so we need to be able to re-use our existing reports (500+). We mainly use Oracle 12 databases. When working with timestamp data values it is necessary to use the oracle.sql.TIMESTAMP class / data type which is defined in the oracle jdbc driver jar. While using our custom reporting servlet I have never had any trouble using this data type, but with JRS I keep getting exceptions when running such a report:

java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to oracle.sql.TIMESTAMP

It sounds to me like a driver version issue, but there is only one version of the jdbc driver installed and if I remove it I get a corresponding error message, so that should be fine.

Any pointers?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic


 We are a group of OSBI consulatning professionals and a Jaspersoft integration partner. If you need any kind of consulting service related to open source BI and ETL we can help you as we have already done some works on custom coding and drilled down multiple reporting on Jaspersoft. 

For any further query you can contact me at: kaushik@helicaltech.com


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...