Code example for Connection

Methods: closecreateStatementprepareStatement

0
    } 
 
    public void test() throws SQLException { 
        deleteDb("autoRecompile"); 
        Connection conn = getConnection("autoRecompile");
        Statement stat = conn.createStatement();
        stat.execute("CREATE TABLE TEST(ID INT PRIMARY KEY)");
        PreparedStatement prep = conn.prepareStatement("SELECT * FROM TEST");
        assertEquals(1, prep.executeQuery().getMetaData().getColumnCount());
        stat.execute("ALTER TABLE TEST ADD COLUMN NAME VARCHAR(255)");
        assertEquals(2, prep.executeQuery().getMetaData().getColumnCount());
        stat.execute("DROP TABLE TEST");
        stat.execute("CREATE TABLE TEST(ID INT PRIMARY KEY, X INT, Y INT)");
        assertEquals(3, prep.executeQuery().getMetaData().getColumnCount());
        // TODO test auto-recompile with insert..select, views and so on 
 
        prep = conn.prepareStatement("INSERT INTO TEST VALUES(1, 2, 3)");
        stat.execute("ALTER TABLE TEST ADD COLUMN Z INT");
        try { 
            prep.execute();
            fail(); 
        } catch (SQLException e) {
            assertKnownException(e);
        } 
        try { 
            prep.execute();
            fail(); 
        } catch (SQLException e) {
            assertKnownException(e);
        } 
        conn.close();
        deleteDb("autoRecompile"); 
    } 
 
} 
Stop searching for code, let great code find you!  Add Codota to your java IDE