Hi everyone, i’m trying to make PDF report with domino and i choose jasper report. After a bit to get it work, now i can create pdf for data on relational database from Notes Java Agent.
The next step is make report of domino data:
the only way i found is using and Lotus Notes SQL odbc connection.
The connection is working fine but as soon as i try to fill my report (getting data from the NotesSQL connection) i get this error on the JAVA CONSOLE:
net.sf.jasperreports.engine.JRException: Unable to retrieve result set metadata.
at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:364)
at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:116)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:807)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:771)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1413)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:203)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:99)
at JavaAgent.NotesMain(JavaAgent.java:63)
at lotus.domino.AgentBase.runNotes(Unknown Source)
at lotus.domino.NotesThread.run(Unknown Source)
Caused by: java.sql.SQLException: [Lotus][ODBC Lotus Notes]Descriptor type out of range
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6971)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7128)
at sun.jdbc.odbc.JdbcOdbc.SQLColAttributesString(JdbcOdbc.java:2681)
at sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColAttributeString(JdbcOdbcResultSetMetaData.java:807)
at sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColumnName(JdbcOdbcResultSetMetaData.java:369)
at net.sf.jasperreports.engine.JRResultSetDataSource.searchColumnByName(JRResultSetDataSource.java:380)
at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:338)
and I can’t get it work!
I tried to access a simple view on an existing database, fetching just one text field.
I really do not have any idea of how to get out of this, so please, does anyone know how to make it work?
What’s wrong?
Thanks a lot!
cheers bye
Marco