DataGrip / cassandra-jdbc-driver

Forked from https://bitbucket.org/dbschema/cassandra-jdbc-driver/
Apache License 2.0
8 stars 7 forks source link

Connection.close() does not work #4

Closed hangum closed 4 years ago

hangum commented 4 years ago

Connection.close() does not work with the v1.3.5 driver.

// test code public static void main(String[] args) { try { Statement stmt = null;

        ResultSet rs = null;

        String url = "jdbc:cassandra://127.0.0.1:9042/cycling";
        String usr = "cassandra";
        String pwd = "cassandra";

        Class.forName("com.dbschema.CassandraJdbcDriver");

        // -- 1
        Connection conn = DriverManager.getConnection(url, usr, pwd);
        String sql = "SELECT * FROM system_schema.tables";

        System.out.println(sql);

        stmt = conn.createStatement();
        rs = stmt.executeQuery(sql);

        int columnCnt = rs.getMetaData().getColumnCount();
        for(int i=0; i<columnCnt; i++) {
            System.out.println(rs.getMetaData().getColumnLabel(i+1) + ": " + rs.getMetaData().getColumnTypeName(i+1));
        }

        System.out.println("-----------------------");
        while (rs.next()) {
            for(int i=0; i<columnCnt; i++) {
                System.out.print(rs.getString(i+1) + ":" );
            }
            System.out.println();
            System.out.println("================");
        }

        rs.close();
        stmt.close();
        conn.close();
    } catch(Exception e) {
        e.printStackTrace();
    }

    test2();
}
kornilova203 commented 4 years ago

Hello @hangum, thank you for the PR