Wish Enable locking for alternative SQLite JDBC drivers

Discussion in 'B4J Bugs & Wishlist' started by OliverA, Oct 17, 2019.

  1. OliverA

    OliverA Expert Licensed User

    This wish is for enabling jSQL's locking for alternative SQLite JDBC drivers. Various methods for enabling this could be (this is a repeat found in my post here: https://www.b4x.com/android/forum/t...nd-authentication-support.110565/#post-690205):

    1) If in the jSQL library (I'm looking at the source here: https://github.com/AnywhereSoftware/B4J_SQL/blob/master/src/anywheresoftware/b4j/objects/SQL.java)
    sqliteLock where public, we could also use JavaObject to set it with a "new ReentrantLock()".
    2) Or if there were an "enableSQLiteLock" method in jSQL
    3) Or if Initialize2 could just enable the lock if it sees the connection string starting with "jdbc:sqilte"
    Then we could have the best of both worlds: 1) Use different SQLite JDBC driver and 2) let jSQL handle the locking as it already does
     
    Jmu5667 and yiankos1 like this.
  2. Erel

    Erel Administrator Staff Member Licensed User

    I've added it in v1.61 of jSQL which will be included in the next version of B4J.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice