Subject Re: [Firebird-Java] Re: FBDatabaseMetaData and underscores
Author Blas Rodriguez Somoza
Hello

Which version of the driver are you using? and which FB dialect?.

I run jDataMaster tests before the last commit and getColumns works OK, the tests include that getColumns return not empty
resultSet for a table created in the test.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "David Jencks" <davidjencks@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Wednesday, June 05, 2002 6:15 PM
Subject: Re: [Firebird-Java] Re: FBDatabaseMetaData and underscores


> Looks like there is a genuine problem.
>
> I wonder if the empty result sets are related to the recent change in
> char(n) treatment from padding with spaces to padding with nulls? If the
> system tables are padded with spaces they would not match a null-padded
> string.
>
> david jencks
>
> On 2002.06.05 11:31:18 -0400 llafranc78 wrote:
> > I've done two or three tests, and here is the scenario:
> >
> > a) if tableName contains underscores and it's short enough, no
> > Exception is thrown and I get the right ResultSet;
> >
> > b) if tableName contains underscores and it's long enough, the
> > Exception is thrown;
> >
> > c) if tableName doesn't contain underscores there is no Exception but
> > I get an empty ResultSet;
> >
> > So after escaping the underscores the Exception is gone, but ALL
> > ResultSets are empty!
> >
> > Regards
> > Luca
> >
> >
> >
> >
> > > I believe my implementation is spec compliant. It would certainly be
> > > simpler not to handle wildcards at all. Try escaping them like this:
> > >
> > > column\_name
> > >
> > > or if you a literal string
> > >
> > > "column\\_name"
> > >
> > > Then you shouldn't see the extra spaces or the LIKE used either.
> > >
> > > There are tests for this in jca/TestDataBaseMetaData.java
> > >
> > > david jencks
> > >
> > > On 2002.06.05 10:29:02 -0400 llafranc78 wrote:
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>