That was/is not the problem. All other methods we use in DatabaseMetaData work. (Like getTables(), getPrimaryKeys(), getCrossReference() and several other methods that wouldn't work without the stored procedures).
> -----Urspr�ngliche Nachricht----- > Von: James Chuang [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 19. Dezember 2001 15:11 > An: Tomcat Users List > Betreff: Re: Code request; Code to reveal a DB schema > > > For sybase, it used to be that you have to run a SQL script > to load some > system procs before the MetaData stuff would work. Their > jConnect driver > used to document this pretty well. > > jchuang > > ----- Original Message ----- > From: "Ralph Einfeldt" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Wednesday, December 19, 2001 2:00 AM > Subject: AW: Code request; Code to reveal a DB schema > > > At least in some versions of sybase > DatabaseMetaData.getColumns() doesn't > work. > > We use the following as a workaround: > > select * from 'tablename' where 1 <> 1 > > and use ResultSetMetaData to find the > columns. Dirty trick, but works with > any database we tested (Adabas D, > Oracle 8i, Sybase ASA, Interbase, > Cloudscape, Instant DB, Postgres, > MS SQL) > > > -----Urspr�ngliche Nachricht----- > > Von: Jim Cheesman [mailto:[EMAIL PROTECTED]] > > Gesendet: Mittwoch, 19. Dezember 2001 09:42 > > An: Tomcat Users List > > Betreff: Re: Code request; Code to reveal a DB schema > > > > > > At 06:04 AM 19/12/01, you wrote: > > >I'm looking for some dynamic code that will reveal all > > libraries, files, > > >fields in a DB Does anyone have an example or can you point > > me in the right > > >direction? > > > > > > java.sql.DatabaseMetaData is your friend! > > > > > > > > > > > > -- > > > > * Jim Cheesman * > > Trabajo: > > [EMAIL PROTECTED] - (34)(91) 724 9200 x 2360 > > I'm still not sure > > if I understand ambiguity. > > > > > > > > -- > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
