[Qt-jambi-interest] QJDBC compatible driver list

[José Arcángel Salazar Delgado]

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.