Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next
Subject: Notes SQL and Jasper report (descriptor out of range)
Feedback Type: Problem
Product Area: Domino Server
Technical Area: Error Message
Platform: Windows 2003 server
Release: 8.5
Reproducible: Always

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


Feedback number WEBB7STLMD created by ~Holly Cisreburoden on 06/08/2009

Status: Open
Comments:





Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS