Examples of com.ibatis.common.jdbc.ScriptRunner.runScript()

Class com.ibatis.common.jdbc.ScriptRunner

Examples of com.ibatis.common.jdbc.ScriptRunner.runScript()

com.ibatis.common.jdbc.ScriptRunner.runScript()
Runs an SQL script (read in using the Reader parameter) @param reader - the source of the script @throws ClassNotFoundException if the driver class cannot be found @throws SQLException if any SQL errors occur @throws IOException if there is an error reading from the Reader @throws IllegalAccessException if there are problems creating the driver class @throws InstantiationException if there are problems creating the driver class


    ScriptRunner runner = new ScriptRunner(conn, false, false);
    runner.setLogWriter(null);
    runner.setErrorLogWriter(null);


    runner.runScript(reader);
    conn.commit();
    conn.close();
    reader.close();
  }

View Full Code Here

        }
        if (createTables) {
            ScriptRunner sr = new ScriptRunner(dataSource.getConnection(), false, false);
            sr.setLogWriter(null);
            sr.setErrorLogWriter(null);
            sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSql)));
            if (createSqlInd != null && !createSqlInd.equals("")) {
                sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSqlInd)));
            } else {
                LOG.warning("The script to create indexes has not been set. Indexes will not be created.");
            }

View Full Code Here

            ScriptRunner sr = new ScriptRunner(dataSource.getConnection(), false, false);
            sr.setLogWriter(null);
            sr.setErrorLogWriter(null);
            sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSql)));
            if (createSqlInd != null && !createSqlInd.equals("")) {
                sr.runScript(new InputStreamReader(this.getClass().getResourceAsStream("/" + createSqlInd)));
            } else {
                LOG.warning("The script to create indexes has not been set. Indexes will not be created.");
            }
        }
    }

View Full Code Here


    Integer count = getJdbcTemplate().queryForObject( SELECT, Integer.class );
    if ( count == null || count == 1 ) {
      Connection con = this.getDataSource().getConnection();
      ScriptRunner runner = new ScriptRunner( con, true, true );
      runner.runScript( Resources.getResourceAsReader( "sql/createdb_h2.sql" ) );
    }
  }
}

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.