Hi,

you also might try to changed your SQL statements to use
SELECT 'type' FROM ...
instead of
SELECT TYPE FROM ...

This works for me using IBExpert as the frontend.
I don't know exactly but I guess I also tried it with the JDBC driver
and it worked.

Michael

> -----Original Message-----
> From: Will Sargent [mailto:will_sargent@...]
> Sent: Friday, September 12, 2003 6:27 PM
> To: Firebird-Java@yahoogroups.com
> Subject: Re: [Firebird-Java] Re: JDBC driver which implements
> XADataSource?
>
>
> Luca Lafranchi wrote:
>
> >Hi :)
> >I think that your column with name "type" is conflicting
> with Firebird's
> >reserved word ...
> >
> >Try changing the column's name.
> >
> I'll try, but this is looking dubious already. No other
> database I've
> used has forbidden 'type' to be used as a column name, and
> it's going to
> take a certain amount of pain to change this.
>
> Will.
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Upgrade to 128-Bit SSL Security!
> http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/saFolB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/
>
>