Did some research: "catalogs" are the same as "databases". The MySQL driver lists all the databases when getCatalogs() is called.
Methods like Connection.getCatalog() should return the database which the driver is currently connected to. Connection.setCatalog (String database) should connect to the specified database. The MySQL driver implements get/setCatalog() as well as getCatalogs(). Supporting catalogs is necessary for my database tool to list the databases available etc. So long Gerhard >-----Original Message----- >From: Peter Donald [mailto:[EMAIL PROTECTED] >Sent: Friday, November 09, 2001 8:43 PM >To: Avalon Developers List >Subject: Re: JDBC setCatalog(..) > > >On Sat, 10 Nov 2001 02:49, Paul Hammant wrote: >> Oracle has "Schemas", DB2 has "Collections". >> >> JDBC supports setCatalog(String) with the following javadocs : >> >> /** >> * Sets a catalog name in order to select >> * a subspace of this Connection's database in which to work. >> * If the driver does not support catalogs, it will >> * silently ignore this request. >> */ >> >> Is that the correct way to indicate "sub database" namespace? I.e. >> equivalent to the two proprietary terms above. Should AvalonDB support >> setCatalog() and call it's Schema equivalent "Catalog" or not? > >Isn't catalog just the ANSI term for database? if so +1 > >-- >Cheers, > >Pete > >-------------------------------------------------- >"An intellectual is someone who has been educated >beyond their intelligence." >-------------------------------------------------- > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
