--- Joe Wilson <[EMAIL PROTECTED]> wrote: > There's nothing wrong with using SQLite transactions.
I should qualify that - there's nothing wrong with using SQLite transactions as long as you use the SQLiteJDBC API to do it. Explicity executing a BEGIN, COMMIT or END behind the driver's back might confuse the internal setAutoCommit state of the SQLiteJDBC driver for subsequent operations. So just use setAutoCommit() and you'll be fine. http://java.sun.com/j2se/1.3/docs/api/java/sql/Connection.html#setAutoCommit(boolean) > > --- Rod Dunne <[EMAIL PROTECTED]> wrote: > > > > Is there anything wrong with using SQLite transactions? > > > > http://www.sqlite.org/lang_transaction.html > > > > I wrap bulk writes in these, and they seem fast enough to me. ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
