Hi ,

Does Netezza support "TYPE_SCROLL_INSENSITIVE" result set type.? If so how?

I am trying to fetch resultset as follows:

ResultSet rs=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_UPDATABLE).executeQuery(sqlQuery);

The resultSet I am getting back is 1003 (TYPE_FORWARD_ONLY) not 1005 (TYPE_SCROLL_INSENSITIVE).

If I use rs.beforeFirst() ,it's throwing me an error.

org.netezza.util.PSQLException: ResultSet is TYPE_FORWARD_ONLY

I am using JDBC driver 4.5.4.

Please let me know how I can make the result set scrollable.

Thanks in advance..