QSqlQuery problem

[jacek]

Thas means I am not connected to database??

Not necessarily. What does QSqlQuery::lastError() return?

[MarkoSan]

God damn, the line

qDebug() << query.lastError().text();    // debug

qDebug() << query.lastError().text();    // debug

To copy to clipboard, switch view to plain text mode 

returns

warning: "No database selected QMYSQL: Unable to execute query"

warning: "No database selected QMYSQL: Unable to execute query"

To copy to clipboard, switch view to plain text mode 

. Jacek, thanks for hints, but clear this up for me please. How is it possible that in the same object and in other method, one time the database is active and the second time, like in this problem, it goes offline. Is there any timeout setting for MySQL database???

[jacek]

What happens in removeAllMerchandize()?

[MarkoSan]

Here is code, nothing special:

void CMerchandizeBrowser::removeAllMerchandize()
{
    qDebug() << "Entered CMerchandizeBrowser::removeAllMerchandize ...";    // debug
//    qDebug() << "Number of pics: " << m_ImagesList.count();
//    for(qint16 iIndex=0; iIndex<m_ImagesList.count(); iIndex++)
//    {
//        m_ImagesList.removeAt(iIndex);    // removes item
//    }
    //clear();    // clear slides of all images
    d->slideImages.clear();    // clears intertnal pic presentation
    //update();    // updates screen
    qDebug() << "Exiting CMerchandizeBrowser::removeAllMerchandize ...";    // debug
}

void CMerchandizeBrowser::removeAllMerchandize()
{
    qDebug() << "Entered CMerchandizeBrowser::removeAllMerchandize ...";    // debug
//    qDebug() << "Number of pics: " << m_ImagesList.count();
//    for(qint16 iIndex=0; iIndex<m_ImagesList.count(); iIndex++)
//    {
//        m_ImagesList.removeAt(iIndex);    // removes item
//    }
    //clear();    // clear slides of all images
    d->slideImages.clear();    // clears intertnal pic presentation
    //update();    // updates screen
    qDebug() << "Exiting CMerchandizeBrowser::removeAllMerchandize ...";    // debug
}

To copy to clipboard, switch view to plain text mode 

And d is private class under CMerchandizeBrowser. Let me comment it and then see what happens.

[jacek]

How do you connect to the database? Do you use a named connection?

[MarkoSan]

I've coded database singleton class with your help, I think, a while ago and I am reusing it now in this application. Do you need a code?

[jacek]

No, I just want to know the line with addDatabase().

[MarkoSan]

Ok, here is the whole constructor of my CDatabaseFoundation class:

CDatabaseFoundation::CDatabaseFoundation(QString db_type, QString db_host,
                                         QString db_name, QString db_username,
                                         QString db_password): QObject()
{
  // sets up database paramaters
  m_Database=QSqlDatabase::addDatabase(db_type);
  m_Database.setHostName(db_host);
  m_Database.setUserName(db_username);
  m_Database.setPassword(db_password);
 
  // tries to connect to database
  m_bConnectionEstablished=m_Database.open();
  if(!m_bConnectionEstablished)
    qFatal("Failed to connect to database. Aborting.");
  //create database + tables if they don't exists yet
  //CreateDatabaseAndTables();
 
  //call seletedDatabase statement here because you're sure the the database exists
  m_Database.setDatabaseName(db_name);
 
 
/*
  m_pModel=new QSqlRelationalTableModel(this);
  Q_CHECK_PTR(m_pModel);
  //all changes will be cached in the model until either submitAll() or revertAll() is called
  m_pModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
*/
  //addRelations(m_pModel);
 
}

CDatabaseFoundation::CDatabaseFoundation(QString db_type, QString db_host,
                                         QString db_name, QString db_username,
                                         QString db_password): QObject()
{
  // sets up database paramaters
  m_Database=QSqlDatabase::addDatabase(db_type);
  m_Database.setHostName(db_host);
  m_Database.setUserName(db_username);
  m_Database.setPassword(db_password);

  // tries to connect to database
  m_bConnectionEstablished=m_Database.open();
  if(!m_bConnectionEstablished)
    qFatal("Failed to connect to database. Aborting.");
  //create database + tables if they don't exists yet
  //CreateDatabaseAndTables();

  //call seletedDatabase statement here because you're sure the the database exists
  m_Database.setDatabaseName(db_name);

    
/*
  m_pModel=new QSqlRelationalTableModel(this);
  Q_CHECK_PTR(m_pModel);
  //all changes will be cached in the model until either submitAll() or revertAll() is called
  m_pModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
*/
  //addRelations(m_pModel);

}

To copy to clipboard, switch view to plain text mode 

[jacek]

// tries to connect to database
m_bConnectionEstablished=m_Database.open();
if(!m_bConnectionEstablished)
qFatal("Failed to connect to database. Aborting.");
//create database + tables if they don't exists yet
//CreateDatabaseAndTables();

//call seletedDatabase statement here because you're sure the the database exists
m_Database.setDatabaseName(db_name);

As the setDatabaseName() docs say: "This must be done before the connection is opened or it has no effect;". Put that line before the call to open().

[MarkoSan]

Ok, jacek, now query works fine. But please tell me, how is it possible that the SAME CODE worked before?????

[jacek]

how is it possible that the SAME CODE worked before?????

Yesterday was the 13th.

[MarkoSan]

Hmm, you can mock at me as much as you want, but in the same object other method works without problem, I tried it now. I have to solve this mistery, anyway, jacek, thank you very very much for your guidance.