PS: that was taken from a newsgroup discussion, should be a quotation! >-----Original Message----- >From: Gerhard Froehlich [mailto:[EMAIL PROTECTED] >Sent: Saturday, November 10, 2001 7:49 PM >To: Avalon Developers List >Subject: RE: JDBC setCatalog(..) > > >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]> >
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
