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)
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
_______________________________________________
Qt-jambi-interest mailing list
[email protected]
http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
