JDBC Error: com.ingres.gcf.util.SqlEx: Request is not supported.

[tvries]

I am configuring a Pentaho BI server under Tomcat to run reports against an Ingres DB and I am encountering the error below when the server tries to execute the report. When I access the data using the Report Designer tool via JDBC on my Windows XP machine, the report runs just fine, but when I deploy it to the server and run it, the report returns no rows. The server is running RedHat Enterprise Linux 64 bit OS and Java 1.6.0_13 . Are there any known problems using the iijdbc.jar and the edbc.jar JDBC files on a 64 bit Linux OS?

10:35:38,641 ERROR [SQLResultSet] SQLResultSet.ERROR_0001 - Could not obtain rowcount.
com.ingres.gcf.util.SqlEx: Request is not supported.
at com.ingres.gcf.util.SqlEx.get(Unknown Source)
at com.ingres.gcf.jdbc.JdbcRslt.load(Unknown Source)
at com.ingres.gcf.jdbc.JdbcRslt.last(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.last(D elegatingResultSet.java:328)
at org.pentaho.platform.plugin.services.connections.s ql.SQLResultSet.getRowCount(SQLResultSet.java:212)
at org.pentaho.platform.plugin.action.jfreereport.hel per.PentahoTableModel.getRowCount(PentahoTableMode l.java:118)
....

[thogo01]

A scrolling method, ResultSet.last(), is being called and the driver is throwing the unsupported exception. This indicates that the result-set is forward-only and not scrollable. Some difference in the two environments such as the requests going into the driver, the driver itself, or the DBMS, is restricting the ability to open a scrollable cursor.

If the DBMS installation is the same, then driver traces of the two environments should show the difference.

[shearerg]

tvries,

I had a similar problem (?) a while ago using a product called Indusoft against Ingres. ODBC functions provided by the product would not work with the Ingres ODBC driver, as scrollable cursors were not supported. Which reminds me that I must test out these functions once again, as I'm now using later client and server releases!

Apart from that experience, which may not be relevant to your problem, I'm particularly interested in this issue as I also plan to run Pentaho BI against Ingres ... as soon as I have the time to understand Pentaho a little better.

Regards,
Greg Shearer