Databases
StackOverflow2013
Postsdbo
POConversionException: Unparseable date on Jasper reports
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConversionException: Unparseable date on Jasper reports
    text
    copied!<p>I'm working on a system that uses Jasper reports. Recently it started throwing this error:</p> <pre><code>org.apache.commons.beanutils.ConversionException: Unparseable date: "03/03/1981" at org.apache.commons.beanutils.locale.BaseLocaleConverter.convert(BaseLocaleConverter.java:241) at org.apache.commons.beanutils.locale.LocaleConvertUtilsBean.convert(LocaleConvertUtilsBean.java:285) at net.sf.jasperreports.engine.data.JRAbstractTextDataSource.convertStringValue(JRAbstractTextDataSource.java:69) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:313) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1478) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:942) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:860) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) at XmlJasperInterface.report(XmlJasperInterface.java:89) at XmlJasperInterface.main(XmlJasperInterface.java:63) Caused by: java.text.ParseException: Unparseable date: "03/03/1981" at java.text.DateFormat.parse(DateFormat.java:337) at net.sf.jasperreports.engine.util.JRDateLocaleConverter.parse(JRDateLocaleConverter.java:84) at org.apache.commons.beanutils.locale.BaseLocaleConverter.convert(BaseLocaleConverter.java:232) ... 13 more </code></pre> <p>I'm not sure what caused it. We've also recently upgraded Jasper reports but I remember it was working after the upgrade.</p> <p>I've found a blog post titled <a href="http://radio.javaranch.com/jason/2004/06/09/1086797433000.html" rel="nofollow noreferrer">BeanUtils, Digester, and Type Conversion</a> which points to add these lines:</p> <pre><code>String pattern = "MM/dd/yyyy"; Locale locale = Locale.getDefault(); DateLocaleConverter converter = new DateLocaleConverter(locale, pattern); converter.setLenient(true); ConvertUtils.register(converter, java.util.Date.class); </code></pre> <p>but they've changed nothing. I still get the same error.</p> <p>The line that triggers the error is this one:</p> <pre><code>jasperPrint = JasperFillManager.fillReport(jasperReport, null, new JRXmlDataSource(System.in, selectCriteria)); </code></pre> <p>Thanks.</p> <p><strong>Update</strong>: Downgrading Jasper Reports to 1.1.0 made it work again, so it was most likely the upgrade that broke it.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload