How to Handle Database Connections in Qt?

Here my problem; in such a case it complains about duplicate connections with same connection name: Test::Test(QString connectionName) { db=QSqlDatabase::addDatabase("QMYSQL",connectionName); } int main(int argc, char *argv[]) { QString connectionName=QString("test"); QCoreApplication a(argc, argv); Test myDb(connectionName); Test myDb2(connectionName); return a.exec(); } Here my solution: Test::Test(QString connectionName) { if(!QSqlDatabase::contains(connectionName)) db=QSqlDatabase::addDatabase("QMYSQL",connectionName); else db=QSqlDatabase::database(connectionName); } int main(int argc, char *argv[]) { QString connectionName=QString("test"); QCoreApplication a(argc, argv); { Test myDb(connectionName); Test myDb2(connectionName); } QSqlDatabase::removeDatabase(connectionName); return a.exec(); } 1-)Is this a good way to handle this problem? 2-)Do you have another suggestion? 3-)Do you think that this is a drawback for Qt?
Answer:

-- I would prefer adding the Database connection in a static portion of code. Not executing everytime Test class is initialized. You can have a setup function to handle all that work. No, it's not. It's by design. Usually you should not have to create/open a new DB connection every time you create a class instance.

metdos at Stack Overflow Visit the source

Was this solution helpful to you?

Other answers

Just give your connections different names: int main(int argc, char *argv[]) { QString connectionName("test"); QString connectionName2("test2"); QCoreApplication a(argc, argv); Test myDb(connectionName); Test myDb2(connectionName2); return a.exec(); }

PiedPiper

Related Q & A:

How to drop all connections to a specific database in postgres without stopping the server?Best solution by Database Administrators
How to handle CRLs correctly in long-term electronic signatures?Best solution by Information Security
How to handle a popup in selenium webdriver?Best solution by Stack Overflow
How to draw something in widget(qt?Best solution by Stack Overflow
How to link static library to QT creator project properly?Best solution by Stack Overflow

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.