SQuirreL SQL Client

Thanks for verifying the fix.

Rob

This has been fixed in Snapshot-20081104_0124. You may close this bug
report.

That exception is familiar. Yes the driver is implemented differently than
most - some of this has to do with limitations in SQLite. However, this
problem was fixed back in June on the trunk - so if you want to try a
snapshot build I bet that problem goes away for you. The fix was done as
part of a broader refactoring to fix regressions that were introduced for
databases for which a plugin is not available. As such it was a bit too
much change to introduce on the 2.6 release branch. We are past the
halfway point for releasing 2.7 (which will come the same codebase that
snapshots are built from). There are a few new features as well as
bug-fixes for bugs like the one in this ticket. We would appreciate any
feedback you have on the snapshot release if you decide to try it out.

Rob

Following is the error as reported by the "Last log entry" dialog box:

Logged by
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
at 04/11/08 6:52 PM:

Error on Statement.setMaxRows()

java.sql.SQLException: statement is not executing
at org.sqlite.Stmt.checkOpen(Stmt.java:41)
at org.sqlite.Stmt.setMaxRows(Stmt.java:203)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:230)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)

Maybe an error in the driver itself? However, I feel that when such an
operation
fails, there should be a popup showing the error.

Curiously, this error does not show up in the "List of logs" window. It
does show in
.squirrel-sql/logs/squirrel-sql.log Should I create another bug report
for this?

Could you attach your log file (just the exceptions) to this bug ticket
(That will help us diagnose the problem)

Rob