QT sql programming

Question

include "mythread.h

mythread::mythread(int ID, QObject *parent) :
QThread(parent)


{
    this->socketDescriptor = ID;
    db = QSqlDatabase::addDatabase("QODBC");
    db.setHostName("127.0.0.1");
    db.setDatabaseName("mydsn");



    if (db.open())
    {
        qDebug() << "DB is connected!";
        myquery->clear();
        myquery->exec("INSERT INTO phone_table(name_) VALUES ('asdhjs')");
        db.close();
    }
    else
    {
        qDebug() << "Db is not connected!" << db.lastError();
    }
}

When I insert data its getting error Myserver.exe Myserver.exe has stopped working Windows is checking for a solution to the problem... Can anyone help me ?

@cmannett85, since `myquery` is most likely a member of `mythread` and since we're looking at constructor, I'd guess that debugger says segmentation fault or so, tracing it to the `myquery->clear()` call ;-) — Michael Krelin - hacker, Sep 26 '12 at 10:22

score 0 · Answer 1 · answered Sep 26 '12 at 12:30

You'll want to initialize your myquery object with your database.

Try changing your code to this.

if (db.open())
{
    qDebug() << "DB is connected!";

    // Allocate the query object.
    myquery = new QSqlQuery( db ); 
    myquery->clear();
    myquery->exec("INSERT INTO phone_table(name_) VALUES ('asdhjs')");
    db.close();
}
else
{
    qDebug() << "Db is not connected!" << db.lastError();
}

score 0 · Answer 2 · answered Sep 26 '12 at 12:42

0

Try this instead of your two myquery lines:

    QSqlQuery q(db);
    q.exec("INSERT INTO phone_table(name_) VALUES ('asdhjs')");

answered Sep 26 '12 at 12:42

Michael Krelin - hacker

138,757
24
193
173

You should probably get more information about the error. like why is it unable to execute. – Michael Krelin - hacker Sep 26 '12 at 13:13

QT sql programming

2 Answers2