I'm doing my best to force Qt to static link SQLite into the executable I'm building using Eclipse and the Qt development plug-in.

I am on KUbuntu 10.10 64-bit AMD and have rebuilt from source the Qt libraries using -qt-sql-sqlite to force the sqlite plug-in to be static inside of the Qt libraries. I even renamed the stale plug-in which was out in the plugins directory so I'm absolutely certain the plugin isn't being called. Here is my .PRO

Qt Code: 
  1. TEMPLATE = app
  2. TARGET = xpnsqtsql
  3. QT += core \
  4.     gui \
  5.     sql   
  6. HEADERS += XpnsBrowseWindow.h \
  7.     YNValidator.h \
  8.     categoryDialog.h \
  9.     payeeDialog.h \
  10.     ReportBrowserDialog.h \
  11.     SplashDialog.h \
  12.     TaxYearDialog.h \
  13.     XpnsLogonDialog.h \
  14.     xpnsform.h
  15. SOURCES += categoryDialog.cpp \
  16.     payeeDialog.cpp \
  17.     XpnsBrowseWindow.cpp \
  18.     ReportBrowserDialog.cpp \
  19.     SplashDialog.cpp \
  20.     TaxYearDialog.cpp \
  21.     XpnsLogonDialog.cpp \
  22.     main.cpp \
  23.     xpnsform.cpp
  24. FORMS += CategoryDialog.ui \
  25.     PayeeDialog.ui \
  26.     ReportBrowserDialog.ui \
  27.     SplashDialog.ui \
  28.     TaxYearDialog.ui \
  29.     XpnsLogonDialog.ui \
  30.     xpnsform.ui
  31. RESOURCES +=
  32. LIBS += -L/usr/lib/libsqlite3.a
To copy to clipboard, switch view to plain text mode 

I have tried every possible thing I could think of with LIBS, but no matter what, I see this on the link

g++ -m64 -o xpnsqtsql debug/categoryDialog.o debug/payeeDialog.o debug/XpnsBrowseWindow.o debug/ReportBrowserDialog.o debug/SplashDialog.o debug/TaxYearDialog.o debug/XpnsLogonDialog.o debug/main.o debug/xpnsform.o debug/moc_XpnsBrowseWindow.o debug/moc_categoryDialog.o debug/moc_payeeDialog.o debug/moc_ReportBrowserDialog.o debug/moc_SplashDialog.o debug/moc_TaxYearDialog.o debug/moc_XpnsLogonDialog.o debug/moc_xpnsform.o -L/usr/lib -L/usr/lib/libsqlite3.a -lQtSql -L/usr/lib -lsqlite3 -lQtGui -L/usr/X11R6/lib64 -lQtDBus -lQtXml -lQtCore -lfontconfig -lpthread
make[1]: Leaving directory `/home/roland/workspace/xpnsqtsql'

Yes, my static library is linked in front of the dynamic, but I would like a way to _only_ link the static lib.

Is there something obvious that I'm missing?