I have few reports that has queries like below
select fullName as Name, email from Person
I generate reports in html format from a java program using
jasaperreport apis. I get the resultset myself using JDBC and
construct JRResultSetDataSource from the resultSet and give that as a
datasource to jasper exporter. My database is Sybase ASE-12.5.
I designed these reports with jasperreports-0.6.1 and they worked
fine. Now I am trying to upgrade to jasperreports-0.6.8. with
jasperreports-0.6.8, when I try to generate any report, it throws
exception with the message that "Unknown column name : Name".
I looked through the source code of JRResultSetDataSource and found
that the way field Values are arrived at seem to have been changed to
base it on ResultSetMetaData as opposed to on column position. But in
case of queries like above, the aliased column name doesn't seem to be
coming in as column name in the ResultSetMetaData.
What is the best way to address this issue?