Re: list all databases in mysql server

2010-05-23 Thread Zhong Nanhai
Many thanks!!! It works. On 5/21/10, Martin Ellis wrote: > On 21 May 2010 08:17, Zhong Nanhai wrote: >> Is it possible to show all databases in a mysql server with iBatis? > > > SHOW DATABASES > > > System.out.println(session.selectList("your-namespace.showdatabases")); > > Martin > > --

Re: list all databases in mysql server

2010-05-21 Thread Martin Ellis
On 21 May 2010 08:17, Zhong Nanhai wrote: > Is it possible to show all databases in a mysql server with iBatis? SHOW DATABASES System.out.println(session.selectList("your-namespace.showdatabases")); Martin - To unsubscribe

Re: list all databases in mysql server

2010-05-21 Thread Zhong Nanhai
Hi, Then, is there any other way? On 5/21/10, Josh Kamau wrote: > IMHO opinion, its not possible because each connection is to one Database. > So your ibatis, JDBC or whatever code only knows the objects under the > database for which connection was made. > > Regards. > > On Fri, May 21, 2010 a

Re: list all databases in mysql server

2010-05-21 Thread Josh Kamau
IMHO opinion, its not possible because each connection is to one Database. So your ibatis, JDBC or whatever code only knows the objects under the database for which connection was made. Regards. On Fri, May 21, 2010 at 10:17 AM, Zhong Nanhai wrote: > Hi, > > Is it possible to show all databases