View Issue Details

IDProjectCategoryView StatusLast Update
0005237SymmetricDS ProBugpublic2022-07-27 20:54
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.13.0 
Target Version3.14.0Fixed in Version3.14.0 
Summary0005237: SQL Explorer queries on SQLite get IllegalStateException
DescriptionRunning queries on SQLite database get an exception. It appears that asking for metadata, then reading the result set, then asking for metadata again causes the exception. Asking for metadata once at the beginning seems to solve it.

SQLite JDBC: inconsistent internal statejava.lang.IllegalStateException: SQLite JDBC: inconsistent internal state
    at org.sqlite.core.CoreResultSet.checkCol(CoreResultSet.java:88)
    at org.sqlite.jdbc3.JDBC3ResultSet.getColumnCount(JDBC3ResultSet.java:710)
    at org.jumpmind.vaadin.ui.sqlexplorer.TabularResultLayout.createTabularResultLayout(TabularResultLayout.java:163)
    at org.jumpmind.vaadin.ui.sqlexplorer.TabularResultLayout.(TabularResultLayout.java:142)
    at org.jumpmind.vaadin.ui.sqlexplorer.SqlRunner.run(SqlRunner.java:256)
Tagsdialect: sqlite, sql explorer

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 d79bc3fb

2022-03-07 17:22:43

admin

Details Diff
0005237: SQL Explorer queries on SQLite get IllegalStateException Affected Issues
0005237
mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/TabularResultLayout.java Diff File

Issue History

Date Modified Username Field Change
2022-03-07 17:21 elong New Issue
2022-03-07 17:21 elong Status new => assigned
2022-03-07 17:21 elong Assigned To => elong
2022-03-07 17:21 elong Tag Attached: dialect: sqlite
2022-03-07 17:21 elong Tag Attached: sql explorer
2022-03-07 17:23 elong Status assigned => resolved
2022-03-07 17:23 elong Resolution open => fixed
2022-03-07 17:23 elong Fixed in Version => 3.14.0
2022-03-07 18:00 admin Changeset attached => SymmetricDS 3.14 d79bc3fb
2022-07-27 20:54 admin Status resolved => closed