Example usage for org.apache.ibatis.session SqlSession commit

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession commit.

Prototype

void commit(boolean force);

Source Link

Document

Flushes batch statements and commits database connection.

Usage

From source file:org.activiti.engine.impl.persistence.db.DbSqlSessionFactory.java

License:Apache License

public static void executeSchemaResource(String operation, String databaseName,
        SqlSessionFactory sqlSessionFactory) {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    boolean success = false;
    try {/*from   ww  w .j  a v a 2 s  . c om*/
        Connection connection = sqlSession.getConnection();
        ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
        String resource = "org/activiti/db/" + operation + "/activiti." + databaseName + "." + operation
                + ".sql";
        InputStream inputStream = classLoader.getResourceAsStream(resource);
        if (inputStream == null) {
            throw new ActivitiException("resource '" + resource + "' is not available for creating the schema");
        }

        Exception exception = null;
        byte[] bytes = IoUtil.readInputStream(inputStream, resource);
        String ddlStatements = new String(bytes);
        StringTokenizer tokenizer = new StringTokenizer(ddlStatements, ";");
        while (tokenizer.hasMoreTokens()) {
            String ddlStatement = tokenizer.nextToken().trim();
            if (!ddlStatement.startsWith("#")) {
                Statement jdbcStatement = connection.createStatement();
                try {
                    log.finest("\n" + ddlStatement);
                    jdbcStatement.execute(ddlStatement);
                    jdbcStatement.close();
                } catch (Exception e) {
                    if (exception == null) {
                        exception = e;
                    }
                    log.log(Level.SEVERE, "problem during schema " + operation + ", statement '" + ddlStatement,
                            e);
                }
            }
        }

        if (exception != null) {
            throw exception;
        }

        success = true;

    } catch (Exception e) {
        throw new ActivitiException("couldn't create db schema", e);

    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    log.fine("activiti db schema " + operation + " successful");
}

---

From source file:org.activiti.impl.db.Db.java

License:Apache License

public static void dbSchemaCheckVersion(SqlSessionFactory sqlSessionFactory) {
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH); // Not quite sure if this is the right setting? We do want multiple updates to be batched for performance ...
    boolean success = false;
    try {/* w  ww . j av a2  s .  c o  m*/
        String dbVersion = (String) sqlSession.selectOne("selectDbSchemaVersion");
        if (!ProcessEngine.VERSION.equals(dbVersion)) {
            throw new ActivitiWrongDbException(ProcessEngine.VERSION, dbVersion);
        }

        success = true;

    } catch (Exception e) {
        String exceptionMessage = e.getMessage();
        if ((exceptionMessage.indexOf("Table") != -1) && (exceptionMessage.indexOf("not found") != -1)) {
            throw new ActivitiException(
                    "no activiti tables in db.  set property 'db.schema.strategy' to value 'create-drop' in activiti.properties for automatic schema creation",
                    e);
        } else {
            if (e instanceof RuntimeException) {
                throw (RuntimeException) e;
            } else {
                throw new ActivitiException("couldn't get db schema version", e);
            }
        }
    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    log.fine("activiti db schema check successful");
}

---

From source file:org.activiti.impl.db.Db.java

License:Apache License

public static void executeSchemaResource(String operation, SqlSessionFactory sqlSessionFactory) {
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH); // Not quite sure if this is the right setting? We do want multiple updates to be batched for performance ...
    boolean success = false;
    try {/*from   w ww.j  ava  2 s . c  om*/
        Connection connection = sqlSession.getConnection();
        ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
        String resource = "org/activiti/db/" + operation + "/activiti.h2." + operation + ".sql";
        InputStream inputStream = classLoader.getResourceAsStream(resource);
        if (inputStream == null) {
            throw new ActivitiException("resource '" + resource + "' is not available for creating the schema");
        }

        Exception exception = null;
        byte[] bytes = IoUtil.readInputStream(inputStream, resource);
        String ddlStatements = new String(bytes);
        StringTokenizer tokenizer = new StringTokenizer(ddlStatements, ";");
        while (tokenizer.hasMoreTokens()) {
            String ddlStatement = tokenizer.nextToken().trim();
            if (!ddlStatement.startsWith("#")) {
                Statement jdbcStatement = connection.createStatement();
                try {
                    log.fine("\n" + ddlStatement);
                    jdbcStatement.execute(ddlStatement);
                    jdbcStatement.close();
                } catch (Exception e) {
                    if (exception == null) {
                        exception = e;
                    }
                    log.log(Level.SEVERE, "problem during schema " + operation + ", statement '" + ddlStatement,
                            e);
                }
            }
        }

        if (exception != null) {
            throw exception;
        }

        success = true;

    } catch (Exception e) {
        throw new ActivitiException("couldn't create db schema", e);

    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    log.fine("activiti db schema creation successful");
}

---

From source file:org.activiti.impl.persistence.IbatisPersistenceSessionFactory.java

License:Apache License

public void dbSchemaCheckVersion() {
    /*//from w  w  w  .  j  a  v a 2  s  .c om
     * Not quite sure if this is the right setting? We do want multiple updates
     * to be batched for performance ...
     */
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
    boolean success = false;
    try {
        String dbVersion = (String) sqlSession.selectOne(statement("selectDbSchemaVersion"));
        if (!ProcessEngine.VERSION.equals(dbVersion)) {
            throw new ActivitiWrongDbException(ProcessEngine.VERSION, dbVersion);
        }

        success = true;

    } catch (Exception e) {
        String exceptionMessage = e.getMessage();
        if ((exceptionMessage.indexOf("Table") != -1) && (exceptionMessage.indexOf("not found") != -1)) {
            throw new ActivitiException(
                    "no activiti tables in db.  set property db.schema.strategy=create-drop in activiti.properties for automatic schema creation",
                    e);
        } else {
            if (e instanceof RuntimeException) {
                throw (RuntimeException) e;
            } else {
                throw new ActivitiException("couldn't get db schema version", e);
            }
        }
    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    log.fine("activiti db schema check successful");
}

---

From source file:org.activiti.impl.persistence.IbatisPersistenceSessionFactory.java

License:Apache License

public void executeSchemaResource(String operation, SqlSessionFactory sqlSessionFactory) {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    boolean success = false;
    try {//from  w  w  w .  ja v  a  2  s  . c om
        Connection connection = sqlSession.getConnection();
        ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
        String resource = "org/activiti/db/" + operation + "/activiti." + databaseName + "." + operation
                + ".sql";
        InputStream inputStream = classLoader.getResourceAsStream(resource);
        if (inputStream == null) {
            throw new ActivitiException("resource '" + resource + "' is not available for creating the schema");
        }

        Exception exception = null;
        byte[] bytes = IoUtil.readInputStream(inputStream, resource);
        String ddlStatements = new String(bytes);
        StringTokenizer tokenizer = new StringTokenizer(ddlStatements, ";");
        while (tokenizer.hasMoreTokens()) {
            String ddlStatement = tokenizer.nextToken().trim();
            if (!ddlStatement.startsWith("#")) {
                Statement jdbcStatement = connection.createStatement();
                try {
                    log.fine("\n" + ddlStatement);
                    jdbcStatement.execute(ddlStatement);
                    jdbcStatement.close();
                } catch (Exception e) {
                    if (exception == null) {
                        exception = e;
                    }
                    log.log(Level.SEVERE, "problem during schema " + operation + ", statement '" + ddlStatement,
                            e);
                }
            }
        }

        if (exception != null) {
            throw exception;
        }

        success = true;

    } catch (Exception e) {
        throw new ActivitiException("couldn't create db schema", e);

    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    log.fine("activiti db schema " + operation + " successful");
}

---

From source file:org.activiti.test.db.ProcessEngineInitializationTest.java

License:Apache License

@Test
public void testVersionMismatch() {
    // first create the schema
    ProcessEngineImpl processEngine = (ProcessEngineImpl) new DbProcessEngineBuilder()
            .configureFromPropertiesResource("org/activiti/test/db/activiti.properties")
            .setDbSchemaStrategy(DbSchemaStrategy.CREATE_DROP).buildProcessEngine();

    // then update the version to something that is different to the library
    // version//w w w . ja v  a 2s  .co m
    PersistenceSessionFactory persistenceSessionFactory = processEngine.getPersistenceSessionFactory();
    SqlSessionFactory sqlSessionFactory = ((IbatisPersistenceSessionFactory) persistenceSessionFactory)
            .getSqlSessionFactory();
    SqlSession sqlSession = sqlSessionFactory.openSession();
    boolean success = false;
    try {
        Map<String, Object> parameters = new HashMap<String, Object>();
        parameters.put("name", "schema.version");
        parameters.put("value", "25.7");
        parameters.put("revision", new Integer(1));
        parameters.put("newRevision", new Integer(2));
        sqlSession.update("updateProperty", parameters);
        success = true;
    } catch (Exception e) {
        throw new ActivitiException("couldn't update db schema version", e);
    } finally {
        if (success) {
            sqlSession.commit(true);
        } else {
            sqlSession.rollback(true);
        }
        sqlSession.close();
    }

    exception.expect(ActivitiWrongDbException.class);
    exception.expect(new TypeSafeMatcher<ActivitiWrongDbException>() {

        @Override
        public boolean matchesSafely(ActivitiWrongDbException e) {
            return e.getMessage().contains("version mismatch") && "25.7".equals(e.getDbVersion())
                    && ProcessEngine.VERSION == e.getLibraryVersion();
        }

        public void describeTo(Description description) {
            description.appendText("'version mismatch' with dbVersion=25.7 and libraryVersion=")
                    .appendValue(ProcessEngine.VERSION);
        }
    });

    // now we can see what happens if when a process engine is being
    // build with a version mismatch between library and db tables
    new DbProcessEngineBuilder().configureFromPropertiesResource("org/activiti/test/db/activiti.properties")
            .setDbSchemaStrategy(DbSchemaStrategy.CHECK_VERSION).buildProcessEngine();

    // closing the original process engine to drop the db tables
    processEngine.close();
}

---

From source file:org.jessma.dao.mybatis.MyBatisSessionMgr.java

License:Apache License

/**
 * /*from   w w w .  j  a  v  a 2  s  . c  om*/
 * ??
 * 
 */
public final void commit(boolean force) {
    SqlSession session = localSession.get();

    if (session != null)
        session.commit(force);
}

---

• «
• 1
• 2
• »