Hello,

first thanks for your great libary and your time!

Im wondering if it is possible to catch a SQL_BUSY Exception because i
have several writers at the same time.
Example:

boolean retry = true;
        while (retry) {
            try {
                ResultSet temp = getLastId.executeQuery();
                temp.next();
                int idTicket = temp.getInt("id");
                temp.close();
                retry = false;
                return idTicket;
            } catch (SQLException ex) {
                Logger.getLogger(DB.class.getName()).log(Level.SEVERE,
null, ex);
            }
        }

I am looping until the query was executed - but if the query is wrong
im in a deadlock. is there a way to detect if another writer locked
the database ?

Thx for your help
K.
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---

Reply via email to