-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ian Gibbons wrote:
> On 27 Sep 2004 at 11:36, Rhino wrote:
>
> <snip>
>
>>I really have no idea how Java is getting the information. I haven't tried
>>very many of the metadata methods yet so I don't know how much Java can
>>actually see and what is hidden. But I do know that it can see the
>>descriptions of the columns.
>>
>>I had assumed that Mark Matthews, the guy who develops the JDBC drivers, had
>>persuaded the other MySQL developers that the JDBC drivers *had* to be able
>>to see the metadata and got permission to do that well in advance of the
>>developers making the metadata available via the command line in the normal
>>way for SQL catalogs. But that was strictly a wild guess; you may be totally
>>correct in your assumptions.
>
>
> Hi,
>
> Maybe the Java driver is simply running this query:
>
> USE database;
> SHOW FIELDS FROM `tablename`;
>
> and caching the result?
>
> Regards
>
> Ian
Ian,
The JDBC driver uses this form (but does not cache):
SHOW FIELDS FROM `databasename`.`tablename`
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http://www.mysql.com/it-resources/white-papers/tco.php
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBW7E3tvXNTca6JD8RAvsOAKCuZAYNMdODpmu5Nu4jUgrrYQyU/QCgugL2
53yHLg8A1r9KHTXxdMJIvv0=
=Edut
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
