-----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
