[sqlite] PRAGMA index_list() SQLException

[da...@dandymadeproductions.com]

> On 2015-03-21 06:27 AM, danap at dandymadeproductions.com wrote:
>> Hello,
>>
>> PRAGMA index_list(table-name)
>>
>> In Sqlite's past history has PRAGMA index_list(table-name) returned a
>> SQLException indicating no ResultSet or a non-empty ResultSet that may
>> throw an exception on accessing the fields in the normal way?
>
> Nope, not in the past and not currently. (There are very many test
> suites that check for this and has to be passed before any release date).
>
> That specific pragma very often returns an empty result-set, not the
> usual case with other queries, so that might be worth testing your code
> for. Other than that it has much the same internal process than any
> other query.
>
> If you post some code, some people here are bound to use the same
> platform / wrapper / interface and may have gotten the same kind of
> thing before.
>
> Good luck,
> Ryan

Thank you for the response Ryan,

The issues I was having has been addressed by the latest code that I
found over at github, which does do the empty result-set test on PRAGMA
index_list() before returning results, getIndexInfo().

The project is for sqlite-jdbc that appears to have moved from bitbucket
to github. The latest bitbucket JAR file has issues and recommend anyone
using sqlite with Java make note to use the github code.

https://github.com/xerial/sqlite-jdbc

Dana Proctor
MyJSQLView Project Manager.

[sqlite] PRAGMA index_list() SQLException

[R.Smith]

On 2015-03-21 06:27 AM, danap at dandymadeproductions.com wrote:
> Hello,
>
> PRAGMA index_list(table-name)
>
> In Sqlite's past history has PRAGMA index_list(table-name) returned a
> SQLException indicating no ResultSet or a non-empty ResultSet that may
> throw an exception on accessing the fields in the normal way?

Nope, not in the past and not currently. (There are very many test 
suites that check for this and has to be passed before any release date).

That specific pragma very often returns an empty result-set, not the 
usual case with other queries, so that might be worth testing your code 
for. Other than that it has much the same internal process than any 
other query.

If you post some code, some people here are bound to use the same 
platform / wrapper / interface and may have gotten the same kind of 
thing before.

Good luck,
Ryan

[sqlite] PRAGMA index_list() SQLException

[da...@dandymadeproductions.com]

Hello,

PRAGMA index_list(table-name)

In Sqlite's past history has PRAGMA index_list(table-name) returned a
SQLException indicating no ResultSet or a non-empty ResultSet that may
throw an exception on accessing the fields in the normal way?

{rs.getInt(1), rs.getString(2), rs.getInt(3)}

danap.