Re: Use sqlite databases with SQuirreL SQL

On 2/17/07, Robert Manning <robert.m.manning@xxxxxxxxx> wrote:
> On 2/12/07, Till Biedermann <till@xxxxxxxxxxxxxxxxxxxx> wrote:
> >
> >
> > Hi there,
> >
> > i want to ask if it is possible to use sqlite databases with SQuirreL
> > SQL. If not, are there plans to supports sqlite in the future?
> >
>
> Till,
>
> In general, as long as there is a JDBC driver for a database, then
> SQuirreL can access it.  Having said that, I know of no one that has
> reported use of SQuirreL with the SQLite database.  If you have one
> already setup and would like to use a JDBC driver (maybe
> http://www.zentus.com/sqlitejdbc/) to access it, let us what your
> experience is with it.
>

I decided to try my own advice.  I downloaded the jdbc "pure" java
driver.  It looks to be an all-in-one database engine and driver that
will read sqlite database files for you.  I added the
driver to SQuirreL then made an alias using

jdbc:sqlite:test.db

The file it creates when I connect is called "test.db" and it is
located in the same dir as squirrel-sql.bat.  I tried giving an
absolute path but on WinXP it doesn't seem to like c:/test.sb (I
consistently get out of memory error SQLExceptions)

Object tree in SQuirreL seems to work for basic types (tables and
views).  Be careful though, I did notice that the developer of this
driver doesn't claim that it is complete, so there may be things that
SQuirreL asks for that aren't given.  If you notice any weird
behavior, drop us a note (Please include any exceptions from
squirrel-sql.log and tell us exactly what you did to reproduce it when
describing problems)

Enjoy!

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV