Hi Ravinder,
The metadata sql for getTables has changed in 10.3 and main and that is
probably why you are seeing the error. You will have to drop and recreate
any existing 10.3 and main databases to resolve the problem.
Mamta
On 8/1/07, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
>
> > ResultSet rs1 = databaseMetaData.getTables("", null, "%", null);
> >
> > I am getting the syntax error in the last line.
> > The Error is:
> > Syntax error: Encountered "ORDER" at line 1, column 815
>
> This sounds like a build problem to me. Under the covers, the getTables()
> method invokes a system procedure to retrieve the table information
> from the system catalogs, and perhaps the syntax error is somehow coming
> from that getTables() call. Perhaps you somehow have code which doesn't
> match the proper version of the system procedure against the code stored
> in the database tables.
>
> Do you have the full stack-trace of the error?
>
> I'd suggest:
> - doing an ant clobber, then rebuilding your source tree
> - then removing and recreating all of your test databases.
>
> thanks,
>
> bryan
>
>
