You can translate the question and the replies:

What to use instead of ResultSet.TYPE_SCROLL_INSENSITIVE

I am aware that ResultSet.TYPE_SCROLL_INSENSITIVE is not supported by denodo currently. Do you have a suggestion as to what I can use instead to retrieve the row count of the result set?
user
24-09-2019 09:13:47 -0400

3 Answers

Hi, In order to retrieve the row count of the result set, I would define another variable such that the value of this 'count' variable is incremented based on the number of rows present. For example: ``` while (resultSet.next()) { ++count; } ``` By printing this 'count' variable, I will be able to retrieve the number of records. Hope this helps!
Denodo Team
25-09-2019 07:52:07 -0400
Hi, Is there a more optimal way of doing the same?.... This wouldn't be a very good way of finding the result set size when there's like 50000 rows returned.
user
25-09-2019 07:54:56 -0400
When do you want to obtain that information and what is the purpose? For example: * If you want to obtain it for every query (e.g. when you run a query from a BI tool) you can use the Denodo logs as that information is on the queries.log as described here https://community.denodo.com/kb/view/document/Log%20column%20details?category=Operation * If you want it for a particular resultset you can use SELECT COUNT(*) FROM Table * If you are calling your views from a JAVA program you can also add the count as described in the previous answer
user
 Edited on: 09-06-2020 11:13:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here