1. Taro L. Saito
  2. sqlite-jdbc
Issue #97 new

SQLITE_BUSY exception when using transaction manually with multi-threads

Daisy Shang
created an issue

SQLITE_BUSY exception is thrown immediately when I use transaction manually with multi-threads, the busy time out doesn't take effect. The following are my code examples:

SQLiteConfig config = new SQLiteConfig(); config.setReadOnly(readonly); config.setReadUncommited(true); Properties prop = config.toProperties(); Connection conn = DriverManager.getConnection(url_sqlite, prop); conn.setAutoCommit(false); PreparedStatement pstmt = conn.prepareStatement("........"); pstmt.setQueryTimeout(60); .... .... .... pstmt.executeUpdate(); pstmt.close(); conn.commit(); conn.setAutoCommit(true); .... ...

Comments (0)

  1. Log in to comment