@BeforeClass public static void setUp() throws Exception { // create a SqlSessionFactory Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/foreach/mybatis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); reader.close(); // populate in-memory database SqlSession session = sqlSessionFactory.openSession(); Connection conn = session.getConnection(); reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/foreach/CreateDB.sql"); ScriptRunner runner = new ScriptRunner(conn); runner.setLogWriter(null); runner.runScript(reader); reader.close(); session.close(); }
@Before public void init() { SqlSession session = MyBatisTestUtil.getSession(); Connection c = session.getConnection(); Statement s = null; try { s = c.createStatement(); s.execute("TRUNCATE TABLE entity"); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (s != null && !s.isClosed()) { s.close(); } if (c != null && c.isClosed()) { c.close(); } } catch (SQLException e) { e.printStackTrace(); } if (session != null) { session.close(); } } }
@BeforeClass public static void setUp() throws Exception { Reader reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/multipleresultsetswithassociation/mybatis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); reader.close(); // populate in-memory database // Could not get the table creation, procedure creation, and data population to work from the // same script. // Once it was in three scripts, all seemed well. SqlSession session = sqlSessionFactory.openSession(); Connection conn = session.getConnection(); reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB1.sql"); runReaderScript(conn, session, reader); reader.close(); reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB2.sql"); runReaderScript(conn, session, reader); reader.close(); reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB3.sql"); runReaderScript(conn, session, reader); reader.close(); session.close(); }
// main method for testing public static void main(String... args) { SqlSession session = CrdbSessionManager.INSTANCE.getCrdbSession(); try { logger.info("The session is open? " + !session.getConnection().isClosed()); } catch (SQLException e) { e.printStackTrace(); } CrdbSessionManager.INSTANCE.closeSession(); }
@BeforeClass public static void setup() throws Exception { SqlSession session = IbatisConfig.getSession(); Connection conn = session.getConnection(); ScriptRunner runner = new ScriptRunner(conn); runner.setLogWriter(null); runner.setErrorLogWriter(null); Reader reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/primitive_result_type/create.sql"); runner.runScript(reader); }
public static SqlSession openSqlSession() throws SQLException, IOException { try { if (inputStream == null) { inputStream = Resources.getResourceAsStream(resource); } if (sqlSessionFactory == null) { sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } } catch (IOException e) { throw e; } SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH, false); session.getConnection().setAutoCommit(false); return session; }
/** @throws java.lang.Exception */ @Before public void setUpBefore() throws Exception { mockedRequest = Mockito.mock(HttpServletRequest.class); mockedResponse = Mockito.mock(HttpServletResponse.class); URL testfile = NewModelHandlerTest.class.getResource("/data/newmodelhandler/test1_svg.xml"); File file = new File(testfile.toURI()); svg = FileUtils.readFileToString(file, "UTF-8"); testfile = NewModelHandlerTest.class.getResource("/data/newmodelhandler/test1_content_json.txt"); file = new File(testfile.toURI()); data = FileUtils.readFileToString(file, "UTF-8"); // -- // DataDefaults.all(); Reader reader = Resources.getResourceAsReader("org/b3mn/poem/tests/myibitis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); reader.close(); SqlSession session = sqlSessionFactory.openSession(); Connection conn = session.getConnection(); reader = Resources.getResourceAsReader("org/b3mn/poem/tests/test_reset_mysql_db_schema.sql"); ScriptRunner runner = new ScriptRunner(conn); runner.setErrorLogWriter(null); runner.runScript(reader); reader.close(); reader = Resources.getResourceAsReader("org/b3mn/poem/tests/test_data.sql"); runner = new ScriptRunner(conn); runner.setErrorLogWriter(null); runner.runScript(reader); reader.close(); session.close(); title = "Job #1"; type = "http://b3mn.org/stencilset/reporting#"; summary = ""; newModelIdentity = null; user = new User("public"); handler = new NewModelHandler(); assertNotNull(handler); handler.init(); }
@Test( groups = {"tidb"}, expectedExceptions = PersistenceException.class) public void shouldFailBecauseThereIsAPropertyWithoutTypeHandler() throws Exception { // create a SqlSessionFactory Reader reader = Resources.getResourceAsReader( "org/apache/ibatis/submitted/unknownobject/mybatis-config.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); reader.close(); // populate in-memory database SqlSession session = sqlSessionFactory.openSession(); Connection conn = session.getConnection(); reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/unknownobject/CreateDB.sql"); ScriptRunner runner = new ScriptRunner(conn); runner.setLogWriter(null); runner.runScript(reader); reader.close(); session.close(); }
public Connection getConnection() { return session.getConnection(); }