Hi Mark, Thank you for your speedy response. I'd appreciate if you can put this feature the request list. Many thanks.
By the way, is there a way I can access this metadata through sql ?? Best regards, Michael -----Original Message----- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:14 PM To: Tam, Michael Cc: '[EMAIL PROTECTED]' Subject: Re: Problem using JDBC to obtain metadata -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tam, Michael wrote: | 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 | JDBC doesn't retrieve the remarks, so you can't get to them. I'll add it into my features-request list, or if you'd like it to be tracked, add it to feature-requests at the sourceforge site (http://sourceforge.net/projects/mmmysql/) -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9MzsSlyjUJM+7nP4RAq/VAKCMK2o0FF7ajiVZ/s9MlQe4MYVdHwCfZsJt jIFjiF+N5BHEIBDqIwfFqco= =BI8w -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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