Error retrieving TIME value

[2005 IR Help]

By: anton_phil - anton_phil

Error retrieving TIME value

2005-04-11 00:57

Hi,

 

I have a error that goes like this:

 

net.sf.jasperreports.engine.JRException: Unable to get value for field 'Time' of class 'java.util.Date'

 

I have a report that gets 'TIME' values from a PostGreSQL table. I used the Report Wizzard to create the report and display 'Time' values. It cannot get / parse the value.

 

Any input guys?

 

Thanks in advance

 

 

 

 

 

 

 

By: anton_phil - anton_phil

RE: Error retrieving TIME value

2005-04-11 20:01

Hi,

 

I've been using iReport for couple of months now and its my first time to encounter an error regarding TIME values save in a PostGresSGQ database. I have a field in table A that is of TIME property in POstGreSql. Stores TIME values. eg: 13:23:23 (1:23:23 pm). I've created Report A using Report wizzard with, say the ff query SELECT * FROM "table".

Afterwhich it correctly displays the required fields. When you click on the TIME field that the report has made, it has the Textfield Expression Class = java.util.Date by default.

But when you run the report with database data included an error comes up..

 

 

net.sf.jasperreports.engine.JRException: Unable to get value for field 'Time' of class 'java.util.Date'

 

 

Any input guys?

 

 

Thanks in advance

 

 

 

 

 

Filling report... Error filling print... java.lang.StringIndexOutOfBoundsException: String index out of range: 10 at java.lang.String.substring(String.java:1441) at org.postgresql.jdbc2.ResultSet.toDate(ResultSet.java:1570) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:372) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:607) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:164) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.lang.StringIndexOutOfBoundsException: String index out of range: 10 at java.lang.String.substring(String.java:1441) at org.postgresql.jdbc2.ResultSet.toDate(ResultSet.java:1570) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:372) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:607) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:164) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Unable to get value for field 'Time' of class 'java.util.Date' at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:279) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:890) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Thread.java:534) Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 10 at java.lang.String.substring(String.java:1441) at org.postgresql.jdbc2.ResultSet.toDate(ResultSet.java:1570) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:372) at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:607) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:164) ... 9 more