6 replies to this topic

[Mozana]

I am using sqlite for standard edition of java reason is that i did not want to use much space.
Any way so wen I try to update the info in there it says that the database has been locked, pls
give me some advice

[WingedPanther]

Without seeing any code, it's almost impossible to help you.

[Mozana]

 getDBConn();

            prep = conn.prepareStatement("insert into tblGroups values (?,?,?,?,?)");

            for (Group grp : groups)

                if (!exists(grp))

                    prep.setString(1, grp.getName());

                    prep.setString(2, grp.getDescription());

                    prep.setString(3, grp.getId() + "");

                    prep.addBatch();

                    prep.executeUpdate();

                    saveRecipients(grp.getRecipients());

                    

                }

            }


        } catch (SQLException ex) {

            Logger.getLogger(DBService.class.getName()).log(Level.SEVERE, null, ex);

        }

        closeConnDB();

[WingedPanther]

Mozana, my guess is you still have an open connection before that section. As a result, the above runs into the file lock.

[Mozana]

the thing is even if I set the connection to null and reinitialise it the exception is thrown, guess Ill try a different db, Thank you man

[wim DC]

Setting it to null is not closing it. Connection.close() is closing it.

[Mozana]

lol yea, I also kept calling the

closeConnDB();

which duz close the method, but yea I am now using sqljet