Error creating data set on Vertica data source

I am using Vertica JDBC connection, Birt was able to connect to the data source correctly.
 
Then, created a data set based on the Vertica data source, just a simple "select ...from... limit 100" statement, and it errored out with the following error:
 
Cannot execute the statement. 
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. 
SQL error #1:[Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 6.0. 
; 
 java.sql.SQLException: [Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 6.0.
 
Then I changed the query to limit 5, but an error:
 
Cannot execute the statement. 
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. 
SQL error #1:[Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0. 
; 
 java.sql.SQLException: [Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.
 
Not sure what the deal is with the valid size range.
 
Has anyone used Birt with Vertica JDBC? Have you run into issues like this?
 
Thanks!

Find more posts tagged with

Comments

mwilliams

If you leave off the limit portion, do you still have issues?

mayxue

I actually started without the LIMIT clause first, and got the following error. Then I thought I probably should have put in LIMIT, but that didn't help. It does not seem to help with or without a LIMIT and how many records I limit it to.
 
Cannot execute the statement.
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. 
SQL error #1:[Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0. 
; 
java.sql.SQLException: [Vertica][JDBC](10460) Invalid fetch size: 10000. Valid size range: 0 to 500.0.

mwilliams

Is this when you're trying to run a preview of the data set or when you run the report? If just when previewing the data set, could you try dragging a table from the data set into the layout of the report and running it in the web viewer?