Results 1 to 2 of 2

Thread: SQLite connection shared by several threads

  1. #1
    Join Date
    Aug 2009
    Location
    Málaga (Spain)
    Posts
    1
    Thanks
    1
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Unhappy SQLite connection shared by several threads

    Hello,

    I'm using SQLite in an application. I create two threads which will be writting and reading concurrently to and from the same database.

    How do I manage concurrency by using the API of Qt libraries for databases?

    I'm continuoslly receiving messages like: "database is locked Unable to fetch row". Is autocommit done after one-row-inserts automatically? How do I detect the "LOCKED" status?

    Thanks in advance and regards,

    Jorge-.

  2. #2
    Join Date
    Aug 2009
    Posts
    10
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Default Re: SQLite connection shared by several threads

    look for thread support in qt in assistant. It describes how each thread needs it's own connection.

  3. The following user says thank you to tanderson for this useful post:

    jorgegarciar (24th August 2009)

Similar Threads

  1. Threads and database connection
    By probine in forum Qt Programming
    Replies: 9
    Last Post: 7th August 2013, 09:30
  2. How can I send a SQLite :memory: database connection ?
    By georgep in forum Qt Programming
    Replies: 4
    Last Post: 20th July 2009, 13:07
  3. QT - SQLite Connection
    By sabeesh in forum Qt Programming
    Replies: 14
    Last Post: 3rd June 2009, 14:58
  4. Replies: 4
    Last Post: 29th December 2008, 20:50
  5. Client/Server Error: BadIDChoice
    By 3nc31 in forum Qt Programming
    Replies: 5
    Last Post: 27th November 2007, 11:22

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.