Helen,

That is why it is puzzled me. The server has been in production for 3
years. There is nothing changed on the server machine.

The only changes are migrating firebird 1.0 to 2.0 in the new machine.

After moving, everything (Delphi ISAPI application) is working fine,
except for the java server application.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 01:10 PM 9/03/2007, you wrote:
> >Helen,
> >
> >Thank you for your quick response. This is simple statemenet:
> >
> >SELECT EMAIL
> >FROM XW_EMAIL
> >WHERE WID = 3211
>
> Sorry, but I don't believe that is the statement that is being pushed
> across the wire. Look at the error message:
>
> > >Token unknown - line 1, char 260
>
> Which says that the statement where the error occurs is longer than
> 260 characters. You have at most 42 characters in the statement that
> you are quoting.

The statement is right. That is why I could not figured out.

>
> >There is no field called "CHARACTER_LENGTH". The query is running
> >fine, except in my java code.
> >
> >Any other thought?
>
> Well, it's the same thought, actually. Find out the statement that
> is getting pushed across the wire when the substitution occurs and
> then find out where it is getting that CHARACTER_LENGTH reference
> from. Do you have an SQLMonitor tool that you can use to see what
> the *actual* statement is that your java code is pushing across?
>
> Helen

I don't have a SQLMonitor tool.