[Qt-jambi-interest] sqlite JDBC ?

[Bruno Janvier]

ok thanks. I had much better success with this JDBC driver:
http://www.ch-werner.de/javasqlite/

but as you said there does not seem to be a "reference" implementation of a
JDBC driver for sqlite.

Cheers,
Bruno

On Tue, Mar 25, 2008 at 3:37 PM, Eskil Abrahamsen Blomfeldt <
eblomfel at trolltech.com> wrote:

> Hi, Bruno.
>
> Bruno Janvier wrote:
> > I have spent time testing jambi 4.4 preview and I was disappointed to
> > see the sqlite dll disappear from the distribution. I understand that
> > it was certainly removed due to the new QJdbc facility.
> >
> > I have tried the following JDBC driver :
> http://www.zentus.com/sqlitejdbc/
>
> The SQLite driver was indeed removed because, with the addition of
> QJDBC, we thought it would no longer be needed.
>
> >
> >
> > but at my first attempt of sql, I get the following error:
> > SQLite only supports TYPE_FORWARD_ONLY cursors (null)
>
> If you have a JDBC driver which does not support caching, you can set
> forward-only on the queries by calling the setForwardOnly() method:
>
>
>
> http://doc.trolltech.com/qtjambi-4.4.0_01/doc/html/com/trolltech/qt/sql/QSqlQuery.html#setForwardOnly(boolean)<http://doc.trolltech.com/qtjambi-4.4.0_01/doc/html/com/trolltech/qt/sql/QSqlQuery.html#setForwardOnly%28boolean%29>
>
> However, the SQLite JDBC driver from your link does not seem to be
> feature-complete yet, so even with this flag set, you will get "not
> implemented" exceptions from the driver (unless I am misinterpreting the
> Internet, it seems to lack support for fundamental operations such as
> fetching the data of an integer column.)
>
> Since there does not seem to be any sufficient alternative JDBC drivers
> for SQLite, we'll consider putting the Qt driver back in the package.
>
> Thank you for reporting this!
>
> -- Eskil
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.trolltech.com/pipermail/qt-jambi-interest/attachments/20080325/47482d57/attachment-0001.html