SQL Power Software Forum

I have installed SQL Power Wabit 1.3.1 on Windows XP. The demo connections work fine, e.g. I can run SQL query "SELECT * FROM ACTOR". However, I cannot get it to work on a SQLite connection. I can view a list of tables in the SQLite database, but I cannot run queries on the tables, cannot expand the tables, cannot drag and drop the tables. Has anyone managed to get Wabit to work with SQLite and how?

Here are the steps I went through -->

1. Download the SQLite JDBC Driver from http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056.jar.
2. Open the the Database Connection Manager in Wabit
3. Go to JDBC Drivers > Add JAR > and select sqlitejdbc-v056.jar. The details of the driver as below:
Name: SQLite
Driver Class = org.sqlite.JDBC
3. Add database connection with the details below:
Database Type: SQLite
JDBc URL: jdbc:sqlite:C:/My Databases/test.db
4. File > New Local Workspace. With my new database connection selected, click the "Start" button.
5. Execute SQL "SELECT * FROM TESTTABLE"

I get the error below when executing SQL on a table --->

Your query could not be executed due to the following error:

java.sql.SQLException

at ca.sqlpower.wabit.rs.ResultSetHandle$Task.run(ResultSetHandle.java:381)

at ca.sqlpower.wabit.rs.ResultSetHandle.populate(ResultSetHandle.java:436)

at ca.sqlpower.wabit.rs.ResultSetProducerSupport.execute(ResultSetProducerSupport.java:166)

at ca.sqlpower.wabit.rs.query.QueryCache.execute(QueryCache.java:482)

at ca.sqlpower.wabit.rs.query.QueryCache.executeStatement(QueryCache.java:1179)

at ca.sqlpower.swingui.query.SQLQueryUIComponents$ExecuteSQLWorker.doStuff(SQLQueryUIComponents.java:435)

at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: ResultSet already requested

at org.sqlite.Stmt.getResultSet(Stmt.java:110)

at ca.sqlpower.sql.jdbcwrapper.PreparedStatementDecorator.getResultSet(PreparedStatementDecorator.java:190)

at org.apache.commons.dbcp.DelegatingStatement.getResultSet(DelegatingStatement.java:219)

at ca.sqlpower.wabit.rs.ResultSetHandle$Task.run(ResultSetHandle.java:36

... 7 more

Your query could not be executed due to the following error:

ResultSet already requested

See above for more details.

Executed at 13/06/2010 3:49:29 PM, took 31 milliseconds

SQL statement affected 0 rows.