public static void main(String[] args) {
    String connUrl = "jdbc:sqlite::memory:";
    try (Connection conn = DriverManager.getConnection(connUrl)) {
        try (Statement st = conn.createStatement()) {
            st.execute("CREATE TABLE table1 (id UUID, txtcol VARCHAR(50))");
            st.execute("INSERT INTO table1 (id, txtcol) VALUES ('1e607604-f360-4fa5-863a-bc91adc70bb9', 'foo')");
        }
        try (
                Statement st = conn.createStatement();
                ResultSet rs = st.executeQuery("SELECT * FROM table1")) {
            ResultSetMetaData rsmd = rs.getMetaData();
            for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                System.out.printf("\"%s\" is type %s%n",
                        rsmd.getColumnName(i), rsmd.getColumnTypeName(i));
            }
        }
    } catch (Exception e) {
        e.printStackTrace(System.err);
    }

}