select for update doesn't lock the record with Base.OpenTransaction

[jye...@gmail.com]

I have to add the statement of Base.exec("start transaction") to get the select for update locking work as expected. Does Base.openTransaction() perform sql's start transaction? 

Why does the code below doesn't lock the record select without adding Base.exec("start transaction")?

Is it a known issue in ActiveJDBC?

try {
    Base.openTransaction();
    Base.exec("start transaction");
    List<Map> res = Base.findAll("select 1 from example_table where table_id = 1");
    Logger.info("get the lock: " + res);
    Base.commitTransaction();
    Logger.info("done commit");
} catch (Exception e) {
    e.printStackTrace();
    Base.rollbackTransaction();
    throw e;
}

[Julia]

Correct the typo in the code:

List<Map> res = Base.findAll("select 1 from example_table where table_id = 1 for update");

[Igor Polevoy]

Julia, this code has nothing to do with record locking. These are simple convenience methods that start/commit  and rollback transactions. 

Please, see implementation here: https://github.com/javalite/activejdbc/blob/master/activejdbc/src/main/java/org/javalite/activejdbc/DB.java#L664

Also, see DB.exec() implementation here: https://github.com/javalite/activejdbc/blob/master/activejdbc/src/main/java/org/javalite/activejdbc/DB.java#L531

tx

[Igor Polevoy]

you might also want to read this: 

http://javalite.io/transactions

tx