Accessing JDBC SQLite MetaData

[Jamwa]

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?

[RupertPupkin]

Put that new println statement right before the while loop. Putting it after the loop causes an error because at that point there are no more records to point to in the ResultSet rs.

[Jamwa]

Sweet! Worked like a charm :-)