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.

Hi. Thank you for reporting this issue. The SQL Power Wabit team tested SQLite JDBC driver 3 weeks ago and determined that we will not support this driver until the project reaches a more mature state. The exception you encountered is one of the many we encountered ourselves.

Should people ask for it more we might consider creating a special wrapper for it in the future. We are sorry you are experiencing those issues and assure you that we are keeping a close eye on the JDBC driver for SQLite. We would love nothing more to add this promising young platform to those we officially support.

Cheers!