SQLCommand ends in IndexOutOfBoundsException about jdbcslim HOT 5 CLOSED

When this issue occurs for you, are you sure the resultset (output of the query) is not empty?
I believe when the output is empty you will get that error.

If so you can try to extend public int compare in StringListComparator.java with something like

for (int i = 0; i < _SortKeys1.size(); i++) {
     if (!a1.isEmpty() && !a2.isEmpty() {
     .....
     } else if....

Otherwise you can also write your test differently (with run) and explicitly check on a rowcount.
If above is helping more people I can also create a PR for that. Or maybe @six42 has a better approach for your isse?

from jdbcslim.

@Unforgettable631, you are right. IndexOutOfBoundsException only occurs when the query is empty at that moment. I would like to see that the expected values are missing when the query gives an empty result.

from jdbcslim.

Something like this?

!|SQLCommand|TestDatabase|select ID,Name from TestData where Name in('notThere', 'unknown')|SORT|
|ID?|NAME?>|
|1|notThere|
|2|unknown|

!|SQLCommand|TestDatabase|select ID,Name from TestData where Name in('notThere', 'unknown')|SORT|
|ID?|NAME?>|
|=~/\A\z/|=~/\A\z/|

Before:

After adjustment:

from jdbcslim.

Thanks @Gertray13 for reporting this and thanks @Unforgettable631 for finding a soution and writing a test case to confirm it.

from jdbcslim.

@six42, no problem. Your fix is more robust I think. Do you have any intentions to release the latest version?

from jdbcslim.