[Qt-jambi-interest] QJDBC compatible driver list

Eskil Abrahamsen Blomfeldt eblomfel at trolltech.com
Wed Jul 2 10:08:42 CEST 2008


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






More information about the Qt-jambi-interest mailing list