Results 1 to 5 of 5

Thread: Qdb2 driver problem

  1. #1
    Join Date
    Oct 2009
    Location
    Tbilisi, Georgia
    Posts
    3
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default Qdb2 driver problem

    we have qt4.5.2 on our server, powerpc64 opensuse 11.1. db2 driver version 9.5 fp 4.
    we have following problem:
    our server software makes connection to db2 database(remotely) for each new client thread. when thread is closed we are making database connection close.

    this->mydb->query.finish();
    this->mydb->query.clear();
    this->mydb->dbase.close();
    QSqlDatabase::removeDatabase(dbname);

    we checked client connection. the code above is being executed gracefully. connection is being closed. BUT: after about a 24 hour number of connections to the database is much more than expected. i.e. apparently some connections aren't being closed. each of excessive connections have status "connected". that should mean that after query. finish() and query.clear() dbase close doesn't work properly.\

    beyond this, when giving command in console "netstat -an |grep -i :50000 |wc | awk '{print $1}'" i give in console the output which says that number of connections to the database, which the database itself shows, including excessive connections.
    "ls /proc/{pid of my server application}/fd | wc | awk '{print $1}'" shows same number of excessive connections.

    please give advice how should we handle this problem.

  2. #2
    Join Date
    Oct 2009
    Posts
    1
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Qdb2 driver problem

    I have similar problem. It would be nice if someone could help with solution.

  3. #3
    Join Date
    Oct 2009
    Location
    Tbilisi, Georgia
    Posts
    3
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default Re: Qdb2 driver problem

    is it bug or just i have some mistake?
    please help me how to correctly use qsqldb2 driver?

  4. #4
    Join Date
    Oct 2009
    Location
    Tbilisi, Georgia
    Posts
    3
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default Re: Qdb2 driver problem

    If no one can help, than I ask to the moderators close the thread.

  5. #5
    Join Date
    Apr 2007
    Location
    Sunny Darwin, NT Australia
    Posts
    186
    Thanks
    29
    Thanked 5 Times in 5 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11

    Default Re: Qdb2 driver problem

    I'm running db2 9.7 with Debian but I don't have this problem, maybe upgrade your db2 version ? or maybe it's a problem with 64 bit Linux ?

Similar Threads

  1. Replies: 4
    Last Post: 10th November 2009, 20:48
  2. Replies: 1
    Last Post: 23rd April 2009, 10:05
  3. Qt mysql driver installation problem
    By alphajoseph in forum Installation and Deployment
    Replies: 1
    Last Post: 8th February 2009, 12:56
  4. Tricky problem with ARGB widget / UpdateLayeredWindow
    By nooky59 in forum Qt Programming
    Replies: 3
    Last Post: 21st February 2008, 11:35
  5. My Mysql 5 and Qt 4.2.2 Problem (Driver not loaded)
    By fengtian.we in forum Qt Programming
    Replies: 4
    Last Post: 9th February 2007, 09:11

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.