You can translate the question and the replies:

com.denodo.vdb.jdbcdriver.VDBJDBCDriver does not support type_scroll_insensitive ResultSet .

com.denodo.vdb.jdbcdriver.VDBJDBCDriver does not support type_scroll_insensitive ResultSet . I have application that requires ResultSet to transverse back using resultSet.previous(); . but as com.denodo.vdb.jdbcdriver.VDBJDBCDriver only supports type_forward_only Resultset, the call to the method resultSet.previous(); throws an exception . Please give suggestions to solve this issue. Thanks in advance
user
13-10-2015 06:36:57 -0400

7 Answers

Hi, I'm happy to let you know that support for the type_scroll_insensitive ResultSet in the Virtual DataPort JDBC driver is planned for a future version of the Denodo Platform. Hope this helps!
Denodo Team
13-10-2015 16:16:47 -0400
What is the application that you are using? Some applications can be configured to change the resultset type so even if some functionalities will not be available the application can still be used in combination with Denodo.
user
 Edited on: 09-06-2020 11:13:22 -0400
Hi, Thanks for the reply. I am using IIQ application. I tried configuring the resultset type to scroll_insensitive but denodo JDBC driver does not support it. I wanted to know if com.denodo.vdb.jdbcdriver.VDBJDBCDriver supports CachedRowSet property.
user
15-10-2015 02:51:58 -0400
Hi, Thanks for the reply. I am using IIQ application. I tried configuring the resultset type to scroll_insensitive but denodo JDBC driver does not support it. I wanted to know if com.denodo.vdb.jdbcdriver.VDBJDBCDriver supports CachedRowSet property.
user
15-10-2015 02:52:03 -0400
Hi, I don't know if Sailpoint IIQ can be configured for using a different type of resultset, I haven't found any information online or trial version to test it. Regarding your second question, I think CachedRowSet is independent from the driver as this is something configured on the client side not on the driver/server. Can Sailpoint IIQ be configured to use cachedrowsets instead or regular resultsets?
user
 Edited on: 09-06-2020 11:13:22 -0400
Hi, I wanted to know whether the latest com.denodo.vdb.jdbcdriver.VDBJDBCDriver driver supports type_scroll_insensitive. Thanks Amogha
user
09-12-2016 04:13:33 -0500
Hi Amogha, Currently, the VDP JDBC driver does not support the type_scroll_insensitive resultset. We might consider adding it in future. Although right now is not included in the roadmap. Hope this helps!
Denodo Team
19-12-2016 08:00:15 -0500
You must sign in to add an answer. If you do not have an account, you can register here