public void setContentVersion(long version) { try { ConnectionSource connectionSource = new JdbcConnectionSource(JDBC_URL); RepositoryUtil.updateVersion(connectionSource, VERSION_ENTITY_NAME + "Content", version); } catch (SQLException ex) { ex.printStackTrace(); } }
@Test public void testStuff() throws Exception { File path = new File("/tmp/x"); JdbcConnectionSource connection = new JdbcConnectionSource("jdbc:h2:file:" + path.getAbsolutePath() + ".h2.db"); // TableUtils.createTable(connection, SomeClass.class); Dao<SomeClass, Integer> dao = DaoManager.createDao(connection, SomeClass.class); int id = 131233; SomeClass sc = new SomeClass(id, "fopewjfew"); dao.create(sc); SomeClass retrieved = dao.queryForId(id); System.out.println("" + retrieved); connection.close(); }
@Test(expected = SQLException.class) public void testGetReadOnlyConnectionBeforeInitialize() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.getReadOnlyConnection(null); sds.close(); }
@Test public void testSaveAndClear() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource("jdbc:h2:mem:baz"); DatabaseConnection conn1 = sds.getReadOnlyConnection(null); DatabaseConnection conn2 = sds.getReadOnlyConnection(null); assertSame(conn1, conn2); sds.saveSpecialConnection(conn1); sds.clearSpecialConnection(conn1); sds.releaseConnection(conn1); sds.close(); }
@Test public void testSpringWiring() throws Exception { String url = "jdbc:h2:mem:baz"; JdbcConnectionSource sds = new JdbcConnectionSource(); sds.setUrl(url); sds.initialize(); sds.close(); }
@Test public void testSetDatabaseType() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.setUrl("jdbc:h2:mem:baz"); sds.setDatabaseType(new H2DatabaseType()); sds.initialize(); assertTrue(sds.getDatabaseType() instanceof H2DatabaseType); sds.close(); }
@Test public void testGetConnectionUserPassSetters() throws Exception { String username = "user"; String password = "_secret"; String url = "jdbc:h2:mem:ormlite-up;USER=" + username + ";PASSWORD=" + password; JdbcConnectionSource sds = new JdbcConnectionSource(url); sds.setUsername(username); sds.setPassword(password); assertNotNull(sds.getReadOnlyConnection(null)); sds.close(); }
@Test public void testIsOpen() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource("jdbc:h2:mem:baz"); // no get connection yet assertFalse(sds.isOpen(null)); sds.releaseConnection(sds.getReadOnlyConnection(null)); assertTrue(sds.isOpen(null)); sds.close(); assertFalse(sds.isOpen(null)); } }
@Test(expected = SQLException.class) public void testInitNoUrl() throws Exception { JdbcConnectionSource cs = new JdbcConnectionSource(); cs.initialize(); cs.close(); }
@Test(expected = SQLException.class) public void testReleaseConnectionBeforeInitialize() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.releaseConnection(null); sds.close(); }
@Test(expected = IllegalStateException.class) public void testGetDatabaseTypeBeforeInitialize() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.getDatabaseType(); sds.close(); }
@Test(expected = SQLException.class) public void testGetReadWriteConnectionBeforeInitialize() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.getReadWriteConnection(null); sds.close(); }
@Test public void testSimpleDataSourceString() throws Exception { String url = "jdbc:h2:mem:baz"; JdbcConnectionSource sds = new JdbcConnectionSource(url); assertEquals(url, sds.getUrl()); sds.close(); }
private void doOpenConnectionSource() throws Exception { if (connectionSource == null) { isConnectionExpected = isConnectionExpected(); if (isConnectionExpected) { connectionSource = new JdbcConnectionSource(databaseUrl, userName, password); } } if (databaseType == null) { if (connectionSource != null) { databaseType = connectionSource.getDatabaseType(); } } else { if (connectionSource != null) { connectionSource.setDatabaseType(databaseType); } } }
@Test(expected = SQLException.class) public void testRemotePort() throws Exception { File dbDir = new File(DB_DIRECTORY); TestUtils.deleteDirectory(dbDir); dbDir.mkdirs(); // bad port int notTheRightPort = 12345; closeConnectionSource(); // try to disable the retry feature which delays this test failure System.setProperty("h2.socketConnectRetry", "0"); String dbUrl = "jdbc:h2:tcp://localhost:" + notTheRightPort + "/" + dbDir.getPath() + "/" + DATABASE_NAME; connectionSource = new JdbcConnectionSource(dbUrl); DatabaseConnection conn = connectionSource.getReadOnlyConnection(null); try { DatabaseTypeUtils.createDatabaseType(dbUrl); } finally { connectionSource.releaseConnection(conn); } } }
@Test public void testFileSystem() throws Exception { File dbDir = new File(DB_DIRECTORY); TestUtils.deleteDirectory(dbDir); dbDir.mkdirs(); assertEquals(0, dbDir.list().length); closeConnectionSource(); String dbUrl = "jdbc:h2:" + dbDir.getPath() + "/" + DATABASE_NAME; connectionSource = new JdbcConnectionSource(dbUrl); DatabaseConnection conn = connectionSource.getReadWriteConnection(null); try { databaseType = DatabaseTypeUtils.createDatabaseType(dbUrl); assertTrue(dbDir.list().length != 0); } finally { connectionSource.releaseConnection(conn); } }
protected void closeConnectionSource() throws Exception { if (connectionSource != null) { connectionSource.close(); connectionSource = null; } }
@Test public void testDscsDoubleInit() throws Exception { DataSource dataSource = createMock(DataSource.class); expect(dataSource.getConnection()).andReturn(null); expect(dataSource.getConnection()).andReturn(null); replay(dataSource); DataSourceConnectionSource dcs = new DataSourceConnectionSource(dataSource, connectionSource.getDatabaseType()); dcs.initialize(); assertEquals(connectionSource.getDatabaseType(), dcs.getDatabaseType()); dcs.releaseConnection(createMock(DatabaseConnection.class)); dcs.close(); verify(dataSource); }
@Test(expected = IOException.class) public void testCloseBeforeInitialize() throws Exception { JdbcConnectionSource sds = new JdbcConnectionSource(); sds.close(); }
@Test public void testSimpleDataSourceStringStringString() throws Exception { String username = "user"; String password = "_secret"; String url = "jdbc:h2:mem:ormlite-up;USER=" + username + ";PASSWORD=" + password; JdbcConnectionSource sds = new JdbcConnectionSource(url, username, password); assertNotNull(sds.getReadOnlyConnection(null)); sds.close(); }