Lot of sqlitejdbc.dll Temp directory

filipdns

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

SGaist

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 ?

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

SGaist

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

filipdns

@SGaist no I don't

SGaist

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

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

SGaist

And what is your project doing ?

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])
    })
}

SGaist

What dependencies does you project have ?

filipdns

@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

filipdns

@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!!!