[Francesc Rosés]

Hello,

I’m using an Oracle database in one of my projects and I observed DB Explorer is unable to show Oracle tables and columns remarks.

I think may be interestig DB Explorer can show this metadata info.

I know there is a trick to obtain Oracle tables and columns names. If you use java.sql.Connection.getMetaData() method the names are missing. By default, Oracle JDBC driver do not provides the names. You must do a casting to oracle.jdbc.driver.OracleConnection class and use the method setRemarksReporting(boolean) to force the driver to provide this information:

java.sql.Connection con = ....
jdbc.driver.OracleConnection oCon = (jdbc.driver.OracleConnection) con;
oCon.setRemarksReporting(true);
DatabaseMetaData md = oCon.getMetaData();
ResultSet rs = md.getTables("null", "aSchema", "aTableName", new String[] {"TABLE"});
while (rs.next()) {
  String remarks = rs.getString("REMARKS");
}

May be the DB Explorer problem not showing Oracle remarks is not the bizarre method needed to obtain Oracle metadata. But if this is the problem, I hope this few lines of code can help you.

Best regards and thanks for your excellent work!

Francesc Rosés

[support-tony]

Francesc,

Thanks for pointing out this omission. I’ve raised a problem report for the lack of column comments and an enhancement request to show table comments.

Thanks, also, for the hints on how this may be implemented.

[Francesc Rosés]

You’re welcome!

Francesc Rosés

[Author]

Posts