Subject | Database Introspection with Jaybird |
---|---|
Author | Fidel Viegas |
Post date | 2008-02-06T17:22:10Z |
Hello folks,
I am doing a few database introspections using Jaybird, and I have ran
into some problems. I am able to extract the metadata without any
problems, if the tables are created without delimiters. The minute I
try to introspect a database which has table whose table names and
column names are delimited with double quotes, then the whole thing
fails. That is, I am able to get the table names, but I am unable to
get the columns for that particular table. How do I write some code
that will allow me to get table names and column names with or without
delimiters?
I am using the DatabaseMetadata.getColumns
Another question is what sort of pattern shall I use to return only
the columns for user defined tables?
Thanks in advance,
Fidel.
I am doing a few database introspections using Jaybird, and I have ran
into some problems. I am able to extract the metadata without any
problems, if the tables are created without delimiters. The minute I
try to introspect a database which has table whose table names and
column names are delimited with double quotes, then the whole thing
fails. That is, I am able to get the table names, but I am unable to
get the columns for that particular table. How do I write some code
that will allow me to get table names and column names with or without
delimiters?
I am using the DatabaseMetadata.getColumns
Another question is what sort of pattern shall I use to return only
the columns for user defined tables?
Thanks in advance,
Fidel.