Question & Answer > View Question

How can I create a DB Transaction with Joget BeanShell Script

Confluence User - 22 Oct, 2016

Dear Expert,

I would like to make a db transaction with the following code.

Connection con = null;
DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
con = ds.getConnection();
try{
	if (!con.isClosed()){
		con.setAutoCommit(false);
		// Some code to select a Record for checking!
		// sql = "select * from tables for update";
		...
		if (checking == true) {
			result = true;
		} else {
			// Some code update another db record here!
			...
        };
		con.commit();
} catch (Exception e) {
	LogUtil.error("Application",e, "Error updateing data");
} finally {
	if (con !=null) {
		con.close();
	};
}

However, I get the error of "java.sql.SQLException: Auto-commit can not be set while enrolled in a transaction"

Everyone can point me how to solve this problem.

Many Thanks!

Best Regards

Tony Chu

beanshell;record;locking;jdbc

1

Confluence User •

23 Oct, 2016 •

confluenceUser •

1 •

confluenceUser •

Ok I found out the answer and here is the Code by using:

con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

and not

con.setAutoCommit(false);

Connection con = null;
DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
con = ds.getConnection();
try{
    if (!con.isClosed()){
        con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
        // Some code to select a Record for checking!
        // sql = "select * from tables for update";
        ...
        if (checking == true) {
            result = true;
        } else {
            // Some code update another db record here!
            ...
        };
        con.close();
} catch (Exception e) {
    LogUtil.error("Application",e, "Error updateing data");
} finally {
    if (con !=null) {
        con.close();
    };
}

1

CSV | Excel | XML | PDF

Your answer

Print

How can I create a DB Transaction with Joget BeanShell Script

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-d1bd31c7-9c8a-495e-99f0-f53d44143381{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-d6ac0561-e995-484d-86cf-820a40d27aea{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer