QThread and PostgreSQL - a problem

[Lesiok]

OK, all code related to creating connection to database is moved to run() method :

void KonwertBJM::run(void)
{
 
    QSettings settings( "dworzec.ini", QSettings::IniFormat);
    settings.beginGroup("DbSetup");
    db_connection_name = UniqueDbName();
    db = QSqlDatabase::addDatabase(settings.value("DbType").toString(),db_connection_name);
 
    db.setHostName(settings.value("HostName").toString());
    db.setDatabaseName(settings.value("DatabaseName").toString());
    db.setUserName(settings.value("UserName").toString());
    db.setPassword(settings.value("Password").toString());
    if( !db.open() )
    {
        qDebug() << "KonwerterBJM"
                    << QObject::tr("Can't connect to database")
                    << db.lastError().text();
        return;
    }
    char miesiac[7];
 
    strcpy_s(miesiac,sizeof(miesiac),bazaDBF.mid(1,6 ).toLocal8Bit().data());
    robKonwersje(katDBF.toLocal8Bit().data(),miesiac);
 
    db.close();
}

void KonwertBJM::run(void)
{

    QSettings settings( "dworzec.ini", QSettings::IniFormat);
    settings.beginGroup("DbSetup");
    db_connection_name = UniqueDbName();
    db = QSqlDatabase::addDatabase(settings.value("DbType").toString(),db_connection_name);

    db.setHostName(settings.value("HostName").toString());
    db.setDatabaseName(settings.value("DatabaseName").toString());
    db.setUserName(settings.value("UserName").toString());
    db.setPassword(settings.value("Password").toString());
    if( !db.open() )
    {
        qDebug() << "KonwerterBJM"
                    << QObject::tr("Can't connect to database")
                    << db.lastError().text();
        return;
    }
    char miesiac[7];

    strcpy_s(miesiac,sizeof(miesiac),bazaDBF.mid(1,6 ).toLocal8Bit().data());
    robKonwersje(katDBF.toLocal8Bit().data(),miesiac);

    db.close();
}

To copy to clipboard, switch view to plain text mode 

No difference.

[jpn]

char miesiac[7];
strcpy_s(miesiac,sizeof(miesiac),bazaDBF.mid(1,6).toLocal8Bit().data());

char miesiac[7];
strcpy_s(miesiac,sizeof(miesiac),bazaDBF.mid(1,6).toLocal8Bit().data());

To copy to clipboard, switch view to plain text mode 

Doesn't this leave the last character uninitialized? What does KonwertBJM::robKonwersje() do? Why does it take char* and not QString in the first place?

[Lesiok]

Doesn't this leave the last character uninitialized? What does KonwertBJM::robKonwersje() do? Why does it take char* and not QString in the first place?

1. No, strcpy_s writes to the new location string WITH ending 0x00 byte.

2. KonwertBJM::robKonwersje() is a main method to doing conversion from DBF to SQL. It opens 3 DBF files named as Byyyymm.DBF, KByyyymm.DBF and Pyyyymm.DBF, where yyyymm is saved in var miesiac, and record by record convert it to SQL INSERT statements. A few records from KB and P is related to one record in B. So every record from B produce some INSERT statements in one transaction.

As I wrote in post opening this thread, on Firebird I can do this in many threads and all is OK. Problem is only with PostgreSQL.

[C167]

In addition, the third party libraries used by the QSqlDrivers can impose further restrictions on using the SQL Module in a multithreaded program. Consult the manual of your database client for more information

This may be the problem

[Lesiok]

This may be the problem

Yes I know.
Theoretically libpq is compiled in thread-safe mode. PQisthreadsafe() returns 1 (the libpq is thread-safe).