Accessing JDBC SQLite MetaData

[Arthur Buliva]

Having followed the example given at http://www.zentus.com/sqlitejdbc/ I was able to run it successfully. A little modification however:

while (rs.next())
{
    System.out.println("name = " + rs.getString("name"));
    System.out.println("job = " + rs.getString("occupation"));
}
System.out.println(rs.getMetaData().getColumnCount()); // <- MODIFIED
rs.close();
conn.close();

Throws this Exception:

Exception in thread "main" java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state
        at org.sqlite.RS.checkCol(RS.java:62)
        at org.sqlite.RS.getColumnCount(RS.java:319)
        at workshop.Test.main(Test.java:53)
Java Result: 1

I have Googled around but no fix I find. Any help please?

[Stephan Mueller]

You should give us an idea to what line of your code the exceptions belongs.

at workshop.Test.main(Test.java:53)

EDIT:
and additionally, I've found the following, similar (your?) post in the sun forums:
http://forums.sun.com/thread.jspa?threadID=5448054

To me, this looks like a flaw in the driver - but I haven't verified the behaviour on another DBMS.

[Jan Cumps]

Stephan Mueller wrote:...
and additionally, I've found the following, similar (your?) post in the sun forums:
http://forums.sun.com/thread.jspa?threadID=5448054

I would not call it similar
Arthur, please follow this advise if you post the same question on several fora:
Be Forthright When Cross Posting To Other Sites