You can pass true as a parameter to setRemarksReporting to enable obtaining remarks information through metadata methods such as getColumns.
Example:
public void testRemarksAndCaseIdentifiers() {
try {
Connection conn = sharedConnection;
DatabaseMetaData metaData = conn.getMetaData();
Assert.assertEquals(true, metaData.storesUpperCaseIdentifiers());
Assert.assertEquals(false, metaData.storesLowerCaseIdentifiers());
Assert.assertEquals(false, metaData.storesMixedCaseIdentifiers());
try {
conn.createStatement().execute("drop table testcolumns");
} catch (SQLException e) {
}
conn.createStatement().execute("create table testcolumns (c1 int)");
conn.createStatement().execute("COMMENT on column TESTCOLUMNS.C1 is 'column comment'");
((OceanBaseConnection) conn).setRemarksReporting(true);
ResultSet rs = metaData.getColumns(null, null, "testcolumns".toUpperCase(), "%");
Assert.assertTrue(rs.next());
Assert.assertEquals("column comment", rs.getString("REMARKS"));
} catch (SQLException e) {
e.printStackTrace();
Assert.fail();
}
}