Re: how to get db metadata

[Toby Thain]

On 24-Jun-08, at 10:45 PM, Jason Novotny wrote:

Hi,

I'm converting a nasty python script to java and they use the database metadata to determine the list of databases (the equivalent of a "show databases;" MySql command) and then connect to the appropriate one before querying on tables. Is there a way to do this using iBatis?

You can use MySQL's INFORMATION_SCHEMA.

--Toby

   Thanks, Jason