Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"set term" via JDBC

4 views
Skip to first unread message

Jörg Fröber

unread,
Dec 14, 2004, 10:20:23 AM12/14/04
to
Hello,

I´m working on a Java Application, in which I connect to an Interbase
Database (Version 6) via JDBC-Driver and pass orders to the database
by statement.execute(). Everything works fine, but when I want to send
a stored procedure to the database I get the following error:

interbase.interclient.SQLException: [interclient][interbase] Dynamic
SQL Error
SQL error code = -104
Token unknown - line 1, char 4
term

at interbase.interclient.RecvMessage.createSQLException(Unknown
Source)
at interbase.interclient.RecvMessage.makeSQLException(Unknown Source)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(Unknown Source)
at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown
Source)
at interbase.interclient.Statement.execute(Unknown Source)
[...]

The procedure begins with:

set term ^;

When I execute the statement via IBConsole or isql everything works as
expected.

Can anybody offer a solution for this problem?

Kind regards,
Jörg Fröber

0 new messages