Qt 6.8.3 (MinGW) and QOCI driver

apaczenko1993

Hello All!
Does anybody has compiled QOCI (Oracle) driver for MinGW 64 bit (Qt 6.8.3) or instruction how to create this??
I tried many times to build this driver but i got to many errors.
I know that this probably possible because few months ago my friend create this for Qt 6.5, but now he's out of work :)

Christian Ehrlicher

See https://doc.qt.io/qt-6/sql-driver.html#how-to-build-the-qibase-plugin-on-windows

If you have problems there, please post the actual error message.

apaczenko1993

Ok so i tried to build, by this command:

qt-cmake -G "MinGW Makefiles" C:\Qt\6.8.3\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX="C:\Qt\6.8.3\mingw_64" -DOracle_INCLUDE_DIR="C:\oracle\oracle12\sdk\include" -DOracle_LIBRARY="C:\oracle\oracle12\sdk\lib\msvc\oci.lib"

One message from output is "WARNING: Qt does not support compiling the Oracle database driver with MinGW, due to lack of such support from Oracle. Consider disabling the Oracle driver, as the current build will most likely fail."
but I don't know how but my friend created OCI driver for Qt 6.5 MinGW

Output below:

C:\Hydra\50_Sterowniki\QOCI>qt-cmake -G "MinGW Makefiles" C:\Qt\6.8.3\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX="C:\Qt\6.8.3\mingw_64" -DOracle_INCLUDE_DIR="C:\oracle\oracle12\sdk\include" -DOracle_LIBRARY="C:\oracle\oracle12\sdk\lib\msvc\oci.lib"
-- The CXX compiler identification is GNU 13.1.0
-- The C compiler identification is GNU 13.1.0
-- The ASM compiler identification is GNU
-- Found assembler: C:/Qt/Tools/mingw1310_64/bin/gcc.exe
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: C:/Qt/Tools/mingw1310_64/bin/c++.exe - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: C:/Qt/Tools/mingw1310_64/bin/gcc.exe - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- Performing Test CMAKE_HAVE_LIBC_PTHREAD
-- Performing Test CMAKE_HAVE_LIBC_PTHREAD - Success
-- Found Threads: TRUE
-- Performing Test HAVE_STDATOMIC
-- Performing Test HAVE_STDATOMIC - Success
-- Found WrapAtomic: TRUE
CMake Warning at C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtBuildHelpers.cmake:12 (message):
  The officially supported CMake generator for building Qt is Ninja / Ninja
  Multi-Config.  You are using: 'MinGW Makefiles' instead.  Thus, you might
  encounter issues.  Use at your own risk.
Call Stack (most recent call first):
  C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtBuildHelpers.cmake:407 (qt_internal_validate_cmake_generator)
  C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtBuild.cmake:4 (qt_internal_setup_build_and_global_variables)
  C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtSetup.cmake:6 (include)
  C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtBuildRepoHelpers.cmake:21 (include)
  C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6/QtBuildRepoHelpers.cmake:232 (qt_build_internals_set_up_private_api)
  CMakeLists.txt:28 (qt_build_repo_begin)


-- Force setting build type to 'RelWithDebInfo'.

-- Configuration summary has been written to C:/Hydra/50_Sterowniki/QOCI/config.summary

WARNING: Qt does not support compiling the Oracle database driver with MinGW, due to lack of such support from Oracle. Consider disabling the Oracle driver, as the current build will most likely fail.

-- Configuring done (20.1s)
-- Generating done (2.6s)
-- Build files have been written to: C:/Hydra/50_Sterowniki/QOCI

C:\Hydra\50_Sterowniki\QOCI>cmake --build .
[  2%] Generating version linker script for target QPSQLDriverPlugin
[  2%] Built target QPSQLDriverPlugin_version_script
[  2%] Built target QPSQLDriverPlugin_autogen_timestamp_deps
[  4%] Automatic MOC for target QPSQLDriverPlugin
[  4%] Built target QPSQLDriverPlugin_autogen
[  7%] Running AUTOMOC file extraction for target QPSQLDriverPlugin
[  9%] Running moc --collect-json for target QPSQLDriverPlugin
[ 11%] Generating QPSQLDriverPlugin_resource.rc
[ 14%] Building CXX object psql/CMakeFiles/QPSQLDriverPlugin.dir/QPSQLDriverPlugin_autogen/mocs_compilation.cpp.obj
[ 16%] Building CXX object psql/CMakeFiles/QPSQLDriverPlugin.dir/main.cpp.obj
[ 19%] Building CXX object psql/CMakeFiles/QPSQLDriverPlugin.dir/qsql_psql.cpp.obj
[ 21%] Building RC object psql/CMakeFiles/QPSQLDriverPlugin.dir/QPSQLDriverPlugin_resource.rc.obj
[ 23%] Linking CXX shared module ..\plugins\sqldrivers\qsqlpsql.dll
[ 23%] Built target QPSQLDriverPlugin
[ 26%] Generating version linker script for target QODBCDriverPlugin
[ 26%] Built target QODBCDriverPlugin_version_script
[ 26%] Built target QODBCDriverPlugin_autogen_timestamp_deps
[ 28%] Automatic MOC for target QODBCDriverPlugin
[ 28%] Built target QODBCDriverPlugin_autogen
[ 30%] Running AUTOMOC file extraction for target QODBCDriverPlugin
[ 33%] Running moc --collect-json for target QODBCDriverPlugin
[ 35%] Generating QODBCDriverPlugin_resource.rc
[ 38%] Building CXX object odbc/CMakeFiles/QODBCDriverPlugin.dir/QODBCDriverPlugin_autogen/mocs_compilation.cpp.obj
[ 40%] Building CXX object odbc/CMakeFiles/QODBCDriverPlugin.dir/main.cpp.obj
[ 42%] Building CXX object odbc/CMakeFiles/QODBCDriverPlugin.dir/qsql_odbc.cpp.obj
[ 45%] Building RC object odbc/CMakeFiles/QODBCDriverPlugin.dir/QODBCDriverPlugin_resource.rc.obj
[ 47%] Linking CXX shared module ..\plugins\sqldrivers\qsqlodbc.dll
[ 47%] Built target QODBCDriverPlugin
[ 50%] Generating version linker script for target QOCIDriverPlugin
[ 50%] Built target QOCIDriverPlugin_version_script
[ 50%] Built target QOCIDriverPlugin_autogen_timestamp_deps
[ 52%] Automatic MOC for target QOCIDriverPlugin
[ 52%] Built target QOCIDriverPlugin_autogen
[ 54%] Running AUTOMOC file extraction for target QOCIDriverPlugin
[ 57%] Running moc --collect-json for target QOCIDriverPlugin
[ 59%] Generating QOCIDriverPlugin_resource.rc
[ 61%] Building CXX object oci/CMakeFiles/QOCIDriverPlugin.dir/QOCIDriverPlugin_autogen/mocs_compilation.cpp.obj
[ 64%] Building CXX object oci/CMakeFiles/QOCIDriverPlugin.dir/main.cpp.obj
[ 66%] Building CXX object oci/CMakeFiles/QOCIDriverPlugin.dir/qsql_oci.cpp.obj
[ 69%] Building RC object oci/CMakeFiles/QOCIDriverPlugin.dir/QOCIDriverPlugin_resource.rc.obj
[ 71%] Linking CXX shared module ..\plugins\sqldrivers\qsqloci.dll
[ 71%] Built target QOCIDriverPlugin
[ 73%] Generating version linker script for target QSQLiteDriverPlugin
[ 73%] Built target QSQLiteDriverPlugin_version_script
[ 73%] Built target QSQLiteDriverPlugin_autogen_timestamp_deps
[ 76%] Automatic MOC for target QSQLiteDriverPlugin
[ 76%] Built target QSQLiteDriverPlugin_autogen
[ 78%] Running AUTOMOC file extraction for target QSQLiteDriverPlugin
[ 80%] Running moc --collect-json for target QSQLiteDriverPlugin
[ 83%] Generating QSQLiteDriverPlugin_resource.rc
[ 85%] Building CXX object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/QSQLiteDriverPlugin_autogen/mocs_compilation.cpp.obj
[ 88%] Building CXX object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/qsql_sqlite.cpp.obj
[ 90%] Building CXX object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/qsql_sqlite_vfs.cpp.obj
[ 92%] Building CXX object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/smain.cpp.obj
[ 95%] Building C object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/C_/Qt/6.8.3/Src/qtbase/src/3rdparty/sqlite/sqlite3.c.obj
[ 97%] Building RC object sqlite/CMakeFiles/QSQLiteDriverPlugin.dir/QSQLiteDriverPlugin_resource.rc.obj
[100%] Linking CXX shared module ..\plugins\sqldrivers\qsqlite.dll
[100%] Built target QSQLiteDriverPlugin

C:\Hydra\50_Sterowniki\QOCI>cmake --install .
-- Install configuration: "RelWithDebInfo"
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginConfig.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlpsql.dll
-- Old export file "C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginTargets.cmake" will be replaced.  Removing files [C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginTargets-relwithdebinfo.cmake].
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginTargets.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginTargets-relwithdebinfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlpsql.debug
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QPSQLDriverPluginAdditionalTargetInfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfig.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlodbc.dll
-- Old export file "C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets.cmake" will be replaced.  Removing files [C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets-relwithdebinfo.cmake].
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets-relwithdebinfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlodbc.debug
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginAdditionalTargetInfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginConfig.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqloci.dll
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginTargets.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginTargets-relwithdebinfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqloci.debug
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QOCIDriverPluginAdditionalTargetInfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfig.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlite.dll
-- Old export file "C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets.cmake" will be replaced.  Removing files [C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets-relwithdebinfo.cmake].
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets-relwithdebinfo.cmake
-- Installing: C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqlite.debug
-- Installing: C:/Qt/6.8.3/mingw_64/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginAdditionalTargetInfo.cmake
-- Starting SBOM generation in build dir: C:/Hydra/50_Sterowniki/QOCI/qt_sbom/staging-qsqlitedriverplugins.spdx.in
-- Finalizing SBOM generation in install dir: C:/Qt/6.8.3/mingw_64/sbom/qsqlitedriverplugins-6.8.3.spdx

C:\Hydra\50_Sterowniki\QOCI>

During the building I has no error, but after while testing driver :

qt.sql.qsqldatabase: QSqlDatabase: QOCI driver not loaded
qt.sql.qsqldatabase: QSqlDatabase: available drivers: QSQLITE QMIMER QOCI QODBC QPSQL
Blad polaczenia SQL hyd:  "Driver not loaded Driver not loaded"

jsulm

@apaczenko1993 Set QT_DEBUG_PLUGINS env variable before running your app and check the output. See https://doc.qt.io/qt-6/debug.html

Christian Ehrlicher

And make sure the dependent dlls from oracle are in your path env variable as written in the documentation: "Note that C:\interbase\bin must be in the PATH."

btw: the documentation also stated to use ninja instead makefile generator...

apaczenko1993

@jsulm I set the env and got this:

qt.core.library: "C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqloci.dll" cannot load: Cannot load library C:\Qt\6.8.3\mingw_64\plugins\sqldrivers\qsqloci.dll: %1 nie jest prawidlowa aplikacja systemu Win32.
qt.core.plugin.loader: QLibraryPrivate::loadPlugin failed on "C:/Qt/6.8.3/mingw_64/plugins/sqldrivers/qsqloci.dll" : "Cannot load library C:\\Qt\\6.8.3\\mingw_64\\plugins\\sqldrivers\\qsqloci.dll: %1 nie jest prawidlowa aplikacja systemu Win32."
qt.sql.qsqldatabase: QSqlDatabase: QOCI driver not loaded

Probably because OCI driver is compiled using MinGW instead MSVC, but there should be method to compile OCI driver for programs using MinGW compilator

Edit:
After adding C:\oracle\oracle12 do PATH env, connection work