tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ralph Einfeldt" <ralph.einfe...@uptime-isc.de>
Subject AW: Code request; Code to reveal a DB schema
Date Wed, 19 Dec 2001 14:44:32 GMT
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:dreadlord76@earthlink.net]
> 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" <ralph.einfeldt@uptime-isc.de>
> To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> 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:jchees@msl.es]
> > 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:
> > jchees@msl.es - (34)(91) 724 9200 x 2360
> >               I'm still not sure
> > if I understand ambiguity.
> >
> >
> >
> > --
> > To unsubscribe:   
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
>
>
>

--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>



--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>



--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message