rboard dev: batch entry 0: [SQLITE_ERROR] SQL error or missing database (near "=": syntax error)

[GoogleCodeExporter]

What steps will reproduce the problem?

1. Configure SQLite driver v3.6.20 in SQuirreL client
(http://squirrel-sql.sourceforge.net/).
2. Open attached database, which came with open source Ruby on Rails
project rBoard (http://github.com/radar/rboard).

What is the expected output? What do you see instead?

Database should open so that you can browse schema and contents. Instead
SQuirrel can't open database and gives error:

rboard dev: batch entry 0: [SQLITE_ERROR] SQL error or missing database
(near "=": syntax error)

What version of the product are you using? On what operating system?
JDBC driver is 3.6.20. OS is Windows 7.

Please provide any additional information below.

Everything works with v3.6.10 of the JDBC driver. I have reverted to that
for now.

Original issue reported on code.google.com by praful...@gmail.com on 9 Dec 2009 at 5:17

Attachments:

• test.sqlite3

[GoogleCodeExporter]

changed the milestone

Original comment by taroleo on 9 Dec 2009 at 6:24

• Added labels: Milestone-sqlite-jdbc-3.6.20, Version-3.6.20
• Removed labels: Milestone-xerial-core-1.1, Version-1.0

[GoogleCodeExporter]

Thanks for the bug report. I can reproduce the problem:

java.sql.BatchUpdateException: batch entry 0: [SQLITE_ERROR] SQL error or 
missing 
database (near "=": syntax error)
    at org.sqlite.Stmt.executeBatch(Stmt.java:205)
    at org.sqlite.SQLiteConfig.apply(SQLiteConfig.java:91)
    at org.sqlite.Conn.<init>(Conn.java:65)
    at org.sqlite.JDBC.connect(JDBC.java:67)
    at 
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverMana
ger.j
ava:133)
    at 
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execu
te(Op
enConnectionCommand.java:97)
    at 
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$Sheet
Handl
er.run(ConnectToAliasCommand.java:280)
    at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Unknown Source)

Original comment by taroleo on 10 Dec 2009 at 5:53

• Changed state: Accepted

[GoogleCodeExporter]

This issue was closed by revision 714f2f56e5.

Original comment by taroleo on 10 Dec 2009 at 6:12

• Changed state: Fixed

[GoogleCodeExporter]

Use sqlite-jdbc-3.6.20.1, instead.
http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/

Original comment by taroleo on 10 Dec 2009 at 6:19

[GoogleCodeExporter]

The new version works. Thank you for the rapid response. 

Original comment by praful...@gmail.com on 10 Dec 2009 at 11:48