Eskil Abrahamsen Blomfeldt escribió: > José Arcángel Salazar Delgado wrote: >> finding a JDBC compliant driver. I tried with the following drivers: >> SQLITE (2 different drivers), JayBird(the one for firebird), Apache >> Derby and SmallSQL. >> > > Hi, José. > > I know there has been some issues with certain implementations of JDBC > over SQLite (some features that are documented not to be implemented, > since the drivers were in an unfinished state.) If there are drivers > out there that claim to be JDBC compliant but are not compatible with > Qt Jambi, we'd like to know about them, as this means it's either a > problem with the driver or with Qt Jambi itself. If it's the latter we > will make an effort to fix it. > > The drivers I know have been tested are the current versions of the > PostgreSQL and MySQL drivers: > > http://jdbc.postgresql.org/ > http://www.mysql.com/products/connector/j/ > > I also believe that Microsoft SQL server has been tested and proven to > work. > > Again, any information you can give us about the driver you are using, > and any exceptions or SQL error messages would be helpful. > > You can use the following method to retrieve information about errors > that have happened in the database: > > http://doc.trolltech.com/qtjambi-4.4/html/com/trolltech/qt/sql/QSqlDatabase.html#lastError() > > > > -- Eskil > Ok, I can give you information about the drivers that I tested. Especially 2 that are JDCB compliant.
First, JAVA DB (apache derby) The 'first()' method is only allowed on scroll cursors. (XJ061) Unable to fetch first I´m surprising that JAVA DB don´t work property with QJDBC, because is JDBC compliant and support the scroll cursors. Next, the SmallSql driver: [SmallSQL]ResultSet is forward only. (01000) Unable to fetch first SmallSql said that is JBDC 2.0 compliant and implements the scrollable ResultSets. I don´t know why fails to use the scrollable ResultSets. Next, the H2 DB driver The H2 driver work as expected in every test that I use, except one. The QSqlQuery.last() function is broken with this driver. returns null in every case that I tested. A workaround is changing the SQL query and use the QSqlQuery.first(). The SQLite and firebird Drivers that I test wasn´t JDBC compliant (they don´t implement the scroll cursors). Well, this is my experience. Now I´m using H2 DB to work with QJDBC and its ok for what I need. Thanks for the time. P.D: I miss a lot the old QSQLITE driver. _______________________________________________ Qt-jambi-interest mailing list [email protected] http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
