Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Update: Forum Guidelines & Code of Conduct


    Qt World Summit: Early-Bird Tickets

    Solved Lot of sqlitejdbc.dll Temp directory

    3rd Party Software
    2
    12
    1337
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      filipdns last edited by

      Hello,

      I made project using Sqlite and it create lot of sqlite-3.8.11.1 sqlitejdbc.dll in temp folder directory, I don't know why, could you help me?...

      Thanks a lot

      Philippe

      1 Reply Last reply Reply Quote 0
      • SGaist
        SGaist Lifetime Qt Champion last edited by

        Hi,

        Not without more details.

        How are you using SQLite ?
        What is sqlitejdbc.dll ?
        What are you doing with your application ?
        What version of Windows are you running ?
        What version of Qt are you using ?

        Interested in AI ? www.idiap.ch
        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

        F 1 Reply Last reply Reply Quote 0
        • F
          filipdns @SGaist last edited by filipdns

          @SGaist Hello, I don't know what is sqlitejdbc.dll I know only it's created each time my app open the database. And the main problem is that one different dll is created each time.

          sqlite-3.8.11.1-3675c7ed-18f4-4d50-83e3-a51fe25c52c9-sqlitejdbc.dll
          sqlite-3.8.11.1-55df0ab0-989b-4485-b61c-889420a2ec7d-sqlitejdbc.dll

          the begin and end still the same, only the midle part of the name change.

          I'm using SQLite with Qt 5.10.1 on Windows 7 (can not have Win 10 in my office, company choice)

          My application is mix with C++/QML and JS to record some data and manage it.

          I found someone had same problem on https://github.com/xerial/sqlite-jdbc/issues/80

          and

          https://groups.google.com/forum/#!topic/xerial/2TIvp-u9JdI

          but I don't know how to transpose the solution to Qt

          1 Reply Last reply Reply Quote 0
          • SGaist
            SGaist Lifetime Qt Champion last edited by

            Qt doesn't use sqlite-jdbc. How are you using it ?

            Interested in AI ? www.idiap.ch
            Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

            F 1 Reply Last reply Reply Quote 1
            • F
              filipdns @SGaist last edited by

              @SGaist no I don't

              1 Reply Last reply Reply Quote 0
              • SGaist
                SGaist Lifetime Qt Champion last edited by

                Then how did you associate the creation of these files with your Qt Application ? sqlite-jdbc is a Java package.

                Interested in AI ? www.idiap.ch
                Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                F 1 Reply Last reply Reply Quote 1
                • F
                  filipdns @SGaist last edited by filipdns

                  @SGaist Because only my project use SQLite and I open the temp folder and my project at same time and I seen dll creation when I use my project

                  1 Reply Last reply Reply Quote 0
                  • SGaist
                    SGaist Lifetime Qt Champion last edited by

                    And what is your project doing ?

                    Interested in AI ? www.idiap.ch
                    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                    F 1 Reply Last reply Reply Quote 0
                    • F
                      filipdns @SGaist last edited by filipdns

                      @SGaist my project read / write some data in SQLite database to say it simple.

                      here small part of my .js, all the rest is different data and table but same structure

                      
                      function dbGetHandle()
                      {
                          try {
                              var db = LocalStorage.openDatabaseSync("Kardex", "1.0", "Kardex", 1000000)
                          } catch (err) {
                      
                              console.log("Error opening database: " + err)
                      
                          }
                          return db
                      }
                      
                      function dbInitflightlog()
                      {
                          var db = LocalStorage.openDatabaseSync("Kardex", "1.0", "Kardex", 1000000)
                          try {
                              db.transaction(function (tx) {
                                  tx.executeSql('CREATE TABLE IF NOT EXISTS flight_log (immatriculation TEXT, date_etape TEXT, pilot1 TEXT, pilot2 TEXT, pilot3 TEXT, photo1 TEXT, photo2 TEXT, photo3 TEXT, aeroport_depart TEXT, aeroport_arrivee TEXT, heure_depart TEXT,heure_arrivee TEXT, sunrise TEXT, sunset TEXT, temps_bloc_jour TEXT, temps_bloc_nuit TEXT, temps_bloc_etape TEXT, cycle_etape TEXT, aircrafttype TEXT, numerodeserie TEXT, dateconstruction TEXT, numerocertificatimmat TEXT, numerocertificatLSA TEXT, dateLSA TEXT, numeroCDN TEXT, dateCDN TEXT, datecertificatassurance TEXT, datepesee TEXT, marquemoteur TEXT, marquehelice TEXT, fwdtrappe TEXT, bwdtrappe TEXT, heurecellule TEXT, cyclecellule TEXT, heure_SN_moteur_1 TEXT, cycle_SN_moteur_1 TEXT, heure_SN_moteur_2 TEXT, cycle_SN_moteur_2 TEXT, flightmanual_date TEXT, flightmanual_rev TEXT, flightmanualapprob_date TEXT, emptyweight TEXT,entretien_hors_cadre_approb TEXT, edprent TEXT, amdtprent TEXT, pedateed TEXT, peapprobdate TEXT, periodcheck1 TEXT, periodcheck2 TEXT, periodcheck3 TEXT, periodcheck4 TEXT, periodcheck5 TEXT, periodcheck6 TEXT)')
                              })
                          } catch (err) {
                              console.log("Error creating table in database: " + err)
                          };
                      }
                      
                      function dbInsertflightlog(Pimmatriculation, Pdate_etape, Ppilot1, Ppilot2, Ppilot3, Pphoto1, Pphoto2, Pphoto3, Paeroport_depart, Paeroport_arrivee, Pheure_depart, Pheure_arrivee,  Psunrise , Psunset, Ptemps_bloc_jour, Ptemps_bloc_nuit, Ptemps_bloc_etape, Pcycle_etape, Paircrafttype, Pnumerodeserie, Pdateconstruction, Pnumerocertificatimmat, PnumerocertificatLSA, PdateLSA, PnumeroCDN, PdateCDN, Pdatecertificatassurance, Pdatepesee, Pmarquemoteur, Pmarquehelice, Pfwdtrappe, Pbwdtrappe, Pheurecellule, Pcyclecellule, Pheure_SN_moteur_1, Pcycle_SN_moteur_1, Pheure_SN_moteur_2, Pcycle_SN_moteur_2, Pflightmanual_date, Pflightmanual_rev, Pflightmanualapprob_date, Pemptyweight, Pentretien_hors_cadre_approb, Pedprent, Pamdtprent, Ppedateed, Ppeapprobdate, Pperiodcheck1, Pperiodcheck2, Pperiodcheck3, Pperiodcheck4, Pperiodcheck5, Pperiodcheck6)
                      {
                          var db = dbGetHandle()
                          var rowid = 0;
                          db.transaction(function (tx) {
                              tx.executeSql('INSERT INTO flight_log VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
                                            [Pimmatriculation, Pdate_etape, Ppilot1, Ppilot2, Ppilot3, Pphoto1, Pphoto2, Pphoto3, Paeroport_depart, Paeroport_arrivee, Pheure_depart, Pheure_arrivee,  Psunrise, Psunset, Ptemps_bloc_jour, Ptemps_bloc_nuit, Ptemps_bloc_etape, Pcycle_etape, Paircrafttype, Pnumerodeserie, Pdateconstruction, Pnumerocertificatimmat, PnumerocertificatLSA, PdateLSA, PnumeroCDN, PdateCDN, Pdatecertificatassurance, Pdatepesee, Pmarquemoteur, Pmarquehelice, Pfwdtrappe, Pbwdtrappe, Pheurecellule, Pcyclecellule, Pheure_SN_moteur_1, Pcycle_SN_moteur_1, Pheure_SN_moteur_2, Pcycle_SN_moteur_2, Pflightmanual_date, Pflightmanual_rev, Pflightmanualapprob_date, Pemptyweight, Pentretien_hors_cadre_approb, Pedprent, Pamdtprent, Ppedateed, Ppeapprobdate, Pperiodcheck1, Pperiodcheck2, Pperiodcheck3, Pperiodcheck4, Pperiodcheck5, Pperiodcheck6])
                              var result = tx.executeSql('SELECT last_insert_rowid()')
                              rowid = result.insertId
                          })
                          return rowid;
                      }
                      
                      
                      function dbUpdateflightlog(Pimmatriculation, Pdate_etape, Ppilot1, Ppilot2, Ppilot3, Pphoto1, Pphoto2, Pphoto3, Paeroport_depart, Paeroport_arrivee, Pheure_depart, Pheure_arrivee,  Psunrise , Psunset, Ptemps_bloc_jour, Ptemps_bloc_nuit, Ptemps_bloc_etape, Pcycle_etape, Paircrafttype, Pnumerodeserie, Pdateconstruction, Pnumerocertificatimmat, PnumerocertificatLSA, PdateLSA, PnumeroCDN, PdateCDN, Pdatecertificatassurance, Pdatepesee, Pmarquemoteur, Pmarquehelice, Pfwdtrappe, Pbwdtrappe, Pheurecellule, Pcyclecellule, Pheure_SN_moteur_1, Pcycle_SN_moteur_1, Pheure_SN_moteur_2, Pcycle_SN_moteur_2, Pflightmanual_date,	Pflightmanual_rev,	Pflightmanualapprob_date,	Pemptyweight,	Pentretien_hors_cadre_approb, Pedprent,	Pamdtprent,	Ppedateed, Ppeapprobdate, Pperiodcheck1, Pperiodcheck2,	Pperiodcheck3, Pperiodcheck4,	Pperiodcheck5,	Pperiodcheck6, Prowid)
                      {
                          var db = dbGetHandle()
                          db.transaction(function (tx) {
                              tx.executeSql(
                                          'update flight_log set immatriculation=?, date_etape=?, pilot1=?,  pilot2=?,  pilot3=?,  photo1=?,  photo2=?,  photo3=?,  aeroport_depart=?,  aeroport_arrivee=?,  heure_depart=?, heure_arrivee=?, sunrise=?, sunset=?, temps_bloc_jour=?, temps_bloc_nuit=?, temps_bloc_etape=?,  cycle_etape=?, aircrafttype=? ,numerodeserie=? ,dateconstruction=? ,numerocertificatimmat=? ,numerocertificatLSA=? ,dateLSA=? ,numeroCDN=? ,dateCDN=? ,datecertificatassurance=? ,datepesee=? ,marquemoteur=?, marquehelice=?, fwdtrappe=?, bwdtrappe=?, heurecellule=? ,cyclecellule=? ,heure_SN_moteur_1=?, cycle_SN_moteur_1=?, heure_SN_moteur_2=? , cycle_SN_moteur_2=?, flightmanual_date=?,	flightmanual_rev=?,	flightmanualapprob_date=?,	emptyweight=?,	entretien_hors_cadre_approb=?,	edprent=?,	amdtprent=?, pedateed=?, peapprobdate=?, periodcheck1=?,	periodcheck2=?,	periodcheck3=?,	periodcheck4=?,	periodcheck5=?,	periodcheck6=? where rowid = ? ', [Pimmatriculation, Pdate_etape, Ppilot1, Ppilot2, Ppilot3, Pphoto1, Pphoto2, Pphoto3, Paeroport_depart, Paeroport_arrivee, Pheure_depart, Pheure_arrivee, Psunrise, Psunset, Ptemps_bloc_jour, Ptemps_bloc_nuit, Ptemps_bloc_etape, Pcycle_etape,Paircrafttype, Pnumerodeserie, Pdateconstruction, Pnumerocertificatimmat, PnumerocertificatLSA, PdateLSA, PnumeroCDN, PdateCDN, Pdatecertificatassurance, Pdatepesee, Pmarquemoteur, Pmarquehelice, Pfwdtrappe, Pbwdtrappe, Pheurecellule, Pcyclecellule, Pheure_SN_moteur_1, Pcycle_SN_moteur_1, Pheure_SN_moteur_2, Pcycle_SN_moteur_2, Pflightmanual_date,	Pflightmanual_rev,	Pflightmanualapprob_date,	Pemptyweight,	Pentretien_hors_cadre_approb,	Pedprent,	Pamdtprent, Ppedateed, Ppeapprobdate,	Pperiodcheck1,	Pperiodcheck2,	Pperiodcheck3,	Pperiodcheck4,	Pperiodcheck5,	Pperiodcheck6 ,Prowid])
                      
                          })
                      }
                      
                      function dbDeleteRowflightlog(Prowid)
                      {
                          var db = dbGetHandle()
                          db.transaction(function (tx) {
                              tx.executeSql('delete from flight_log where rowid = ?', [Prowid])
                          })
                      }
                      
                      1 Reply Last reply Reply Quote 0
                      • SGaist
                        SGaist Lifetime Qt Champion last edited by

                        What dependencies does you project have ?

                        Interested in AI ? www.idiap.ch
                        Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                        F 2 Replies Last reply Reply Quote 0
                        • F
                          filipdns @SGaist last edited by

                          @SGaist hello, here what is used on my project:
                          in pro file:

                          QT += qml quick printsupport sql gui widgets
                          

                          in cpp

                          #include <QAbstractItemModel>
                          #include <QApplication>
                          #include <QCoreApplication>
                          #include <QDate>
                          #include <QDebug>
                          #include <QFont>
                          #include <QImage>
                          #include <QObject>
                          #include <QPagedPaintDevice>
                          #include <QPainter>
                          #include <QPixmap>
                          #include <QPrintDialog>
                          #include <QPrinter>
                          #include <QQmlApplicationEngine>
                          #include <QQmlContext>
                          #include <QSqlDatabase>
                          #include <QSqlError>
                          #include <QSqlTableModel>
                          #include <QStandardPaths>
                          #include <QString>
                          #include <QTableView>
                          #include <QtMath>
                          #include <QtSql>
                          #include <QtWidgets>
                          #include <QVariant>
                          

                          in qml:

                          import QtGraphicalEffects 1.0
                          import QtQml 2.2
                          import QtQuick 2.2
                          import QtQuick 2.9
                          import QtQuick.Controls 1.2
                          import QtQuick.Controls 1.4
                          import QtQuick.Controls 2.1
                          import QtQuick.Controls.Private 1.0
                          import QtQuick.Controls.Styles 1.1
                          import QtQuick.Extras 1.4
                          import QtQuick.Layouts 1.3
                          import QtQuick.LocalStorage 2.0
                          import QtQuick.Window 2.3
                          
                          1 Reply Last reply Reply Quote 0
                          • F
                            filipdns @SGaist last edited by

                            @SGaist After all night pc powered without any programs running I found lot of dll created then, qt project is not the origin of them, I close this topic, thank you very much for your help!!!

                            1 Reply Last reply Reply Quote 0
                            • First post
                              Last post