I am trying to execute a query using jdbctemplate and its throwing below error
This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_SENSITIVE or TYPE_SCROLL_INSENSITIVE). ERRORCODE=-4476, SQLSTATE=null
Below the code I am trying to execute
SqlRowSet sqlrowset = jdbctemplate.queryForRowSet(sql);
Thanks for any kind of help with this.