Hi all,
I tried to use mm.mysql (2.0.14) to access the tables in mysql
(3.23.51). I can't retrieve metadata like tables' comment through the
following code:
// get connection
conn=ds.getConnection();
// get metadata
dbmd=conn.getMetaData();
//get resultset for all tables metadata
rs = dbmd.getTables(null,null,"%",null);
//print out the info through a jsp
while (rs.next()){
out.println(rs.getString("TABLE_NAME") + " -> " +
rs.getString("REMARKS"));
}
RESULTS:
tablename_1 ->
tablename_2 ->
tablename_3 ->
tablename_4 ->
....
Would someone kindly show me if there is anything I did wrong in the code
or show me the right way to obtain tables' comment through JDBC? Greatly
appreciated.
Best regards,
Michael
----------------------------------------------------------------------------
-----------------------------------------------
Michael Tam - NFI Database Developer Natural
Resources Canada
[EMAIL PROTECTED] Pacific Forestry
Center
Phone: (250) 383-8074 506 West Burnside
Road
Fax: (250) 363-0775 Victoria, BC
V8Z 1M5
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
