|
From: Joel E. L. Ph.D. <joe...@ve...> - 2008-09-13 19:16:33
|
Greetings -
I have tried to set up Squirrel 2.6.6 with SQLite 3-3.6.2 and
sqlitejdbc-v053.jar driver. The Squirrel client connects to the database and
displays tables and their contents properly in the Object Tree pane.
However, any SQL that is submitted in the SQL Worksheet pane, such as SELECT *
from FOO; or INSERT INTO FOO (col1) VALUES ('dog'); gets an error as follows:
"Error: statement is not executing
SQLState: null
ErrorCode: 0"
I registered the driver using the "Extra Class Path" tab and it said that it
registered successfully. I also tried the same tests with another generic
SQL Client (DbVisualizer), and this worked flawlessly. I would prefer to use
Squirrel but am blocked unless I can actually issue queries to the database.
Research on this and other forums suggests that the diriver that I am using is
appropriate, and Squirrel should work fine with SQLite.
Any help would be gratefully appreciated.
Joel Lieberman
|
