MyEclipse :: View topic - DB Explorer unable to show Oracle tables and columns remarks

MyEclipse: DB Explorer unable to show Oracle tables and columns remarks

froses - Sep 09, 2011 - 03:20 PM
Post subject: DB Explorer unable to show Oracle tables and columns remarks

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:

Code:

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 - Sep 12, 2011 - 11:47 AM
Post subject:

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.

froses - Sep 17, 2011 - 09:50 AM
Post subject:

You're welcome!

Francesc Rosés