Created my first Jasper report this morning (see attached) using Studio 6.2.0. I tried adding some sort fields, but when I then try to preview or run the report, I get the following Java exception:
java.lang.ClassCastException: org.postgresql.util.PGobject cannot be cast to java.lang.Comparable
at net.sf.jasperreports.engine.fill.DataSourceComparator.compare(DatasetSortUtil.java:245)
at net.sf.jasperreports.engine.fill.DataSourceComparator.compare(DatasetSortUtil.java:220)
at java.util.TimSort.mergeHi(TimSort.java:837)
at java.util.TimSort.mergeAt(TimSort.java:516)
at java.util.TimSort.mergeCollapse(TimSort.java:441)
at java.util.TimSort.sort(TimSort.java:245)
at java.util.Arrays.sort(Arrays.java:1438)
at net.sf.jasperreports.engine.fill.DatasetSortUtil.getSortedDataSource(DatasetSortUtil.java:123)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:703)
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:164)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:474)
at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:225)
at com.jaspersoft.studio.property.dataset.dialog.DataPreviewTable$4.run(DataPreviewTable.java:241)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Recommended Comments