I'm having similar messages that apear randomly in my log and can't
point to the exact statement that is causing them. Any idea why a
number or pipe is a token unknown?

2003-09-02 17:35:23,141 [AWT-EventQueue-0] ERROR - GDS Exception.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 134
321
2003-09-02 17:35:38,433 [AWT-EventQueue-0] ERROR - GDS Exception.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 134
321
2003-09-02 17:38:09,450 [AWT-EventQueue-0] ERROR - GDS Exception.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 156
|
2003-09-02 17:38:54,465 [AWT-EventQueue-0] ERROR - GDS Exception.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 137
|


--- In Firebird-Java@yahoogroups.com, "Michael Hausl" <michael@h...>
wrote:

> 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@y...]
> > 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/
> >
> >