QSqlDatabase: QSQLITE driver not loaded [SOLVED]

mr_wallyit

Hello,

Have you try to open database in the main class?

In the my project with Android if I don't open and close the database in main class then I can't open the db in another class, but the driver of sqlite exists.

kasun.chamara

can you please guide me to

generate missing the libraries
import the sqlite plugin

my downloaded qt 4.8.6 source is here:
(qt-everywhere-opensource-src-4.8.6.tar.gz)
@/home/ubuntu/Downloads/qt-src@

statically built Qt resides here :
@/usr/local/qt@

@
ubuntu@ubuntu:~$ dpkg -l | grep sqlite
ii libqt4-sql-sqlite 4:4.8.1-0ubuntu4.8 Qt 4 SQLite 3 database driver
ii libsqlite3-0 3.7.9-2ubuntu1.1 SQLite 3 shared library
ii libsqlite3-dev 3.7.9-2ubuntu1.1 SQLite 3 development files
ii sqlite3 3.7.9-2ubuntu1.1 Command line interface for SQLite 3
@

-thanks

SGaist

There's no missing libraries, you have built Qt statically so the plugin is also built statically.

Search for Q_IMPORT_PLUGIN in the documentation for more information about the static use of a Qt plugin.

kasun.chamara

thanks for suggessions...
i've add the lines .pro file but getting the same error
@QT += core gui sql
LIBS += -L"/usr/local/qt/plugins/sqldrivers" -lqsqlite
QTPLUGIN += qsqlite@

my /usr/local/qt/plugins/sqldrivers directory only contains libqsqlite.a libqsqlite.prl files
dosen't it require any other files?

SGaist

What about Q_IMPORT_PLUGIN in your code ?

No it doesn't, libqsqlite.a is the library containing the plugin

kasun.chamara

thanks lot...

@Q_IMPORT_PLUGIN(qsqlite)@
done the job...

just for get known
i've already installed sqlite3 libsqlite3-dev
does it help qt to works or Qt handle sqlite it self?

why is my self installed (general way) Qt5.3 sqldrivers directory contains more file then above i posted?

thank you again for great help...

SGaist

Depends on how you configured Qt. Qt comes with it's own version of sqlite and IIRC when building your own version you have to tell configure to use the system's available sqlite if you don't want to use Qt's version.

Because you didn't install all related dev packages so to the auto detection failed for the other drivers and thus you only have the sqlite plugin.

kasun.chamara

got it
thank you

Avtansh Sharma

This post is deleted!

Avtansh Sharma

@SGaist
Q_IMPORT_PLUGIN(qsqlite)
/home/user/Downloads/splinechart/main.cpp:41: error: undefined reference to 'qt_static_plugin_qsqlite()'

SGaist

@Avtansh-Sharma : ?

SGaist

Do you have a static build of Qt ?

Avtansh Sharma

@SGaist No but I want to use sqlite driver in my android app. The application works fine as desktop application on ubuntu

SGaist

Then why are you using the instructions for static plugins ? The SQLite plugin is not statically built.