- This topic has 4 replies, 4 voices, and was last updated 14 years, 5 months ago by
.
-
Posts
-
Is there anysupport for sqlite in db explorer? A search of the website and forums returns nothing… Does sqlite even have a JDBC driver?
As long as SQL Lite has a JDBC driver, it should work. I’m not sure if SQL Lite does have a JDBC driver, I haven’t used it.
You can try Hypersonic SQL if you need a lite in-memory DB or Derby I believe.
Ok Thanks. A google turned up this:
http://www.ch-werner.de/javasqlite/overview-summary.html
However, it isn’t in the list of supported DBs. I’m not looking at other DBs for this because I want to administer SQLite DBs that are used by other apps (trac, ruby on rails, etc).
— Chad
http://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/3.6.10/sqlite-jdbc-3.6.10.jar works with v8.0 myeclipse within the DB Browser and related tools, I tried 3.6.20 and that failed on the password logon. feel free to try the other version but the one specified is working for me… Well so far. more info on the jar can be found here http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC. It contains the DLLs for win.linux and mac I think from memory so you dont have to mess around with paths etc.. too much.
glencjones,
Thank you for posting your findings. There is a bug with version 3.6.20 –
http://code.google.com/p/xerial/issues/detail?id=54
Try using sqlite-jdbc-3.6.20.1.jar (http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/)
I have added a screen shot for your reference.
Let me know if that helps.
