I recently switched from InterBase 6.0.1 to Firebird 1.0.

I have not had time to migrate to a different JDBC driver, although I do
plan to. In the mean time I am using out existing InterClient 2.01.


I seem to be getting some strange error that I have not ever seen
before. So I really am not sure how to fix at the moment.

I have not applied the 2.02 patch, and I am not sure if that is my
problem or something else.

Here are some of the errors I am getting taken directly from a log file.

Picture Servlet Exception
Could not retrieve the picture because :
interbase.interclient.InvalidArgumentException: [interclient] Invalid
argument: Result column name 5 is not known.
See API reference for exception
interbase.interclient.InvalidArgumentException
Database Exception
Cannot close the result set :
interbase.interclient.RemoteProtocolException: [interclient]
Client/Server protocol error: Unexpected token in network message
received from $The internal code is 101.
See API reference for exception
interbase.interclient.RemoteProtocolException
Database Exception
Could not execute the following query,
SELECT Picture4 FROM INVENTORY WHERE Part_No=1131
interbase.interclient.BugCheckException: [interclient] Bug detected.
Please send mail to interclient@...
Refer to bug code 101.
See API reference for exception interbase.interclient.BugCheckException
Picture Servlet Exception
Could not retrieve the picture because :
interbase.interclient.RemoteProtocolException: [interclient]
Client/Server protocol error: Unexpected token in network message
received from $The internal code is 103.
See API reference for exception
interbase.interclient.RemoteProtocolException
Database Exception
Could not execute the following query,
SELECT Picture1 FROM INVENTORY WHERE Part_No=21
interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL
Error
SQL error code = -504


That last errors just keep repeating themselves now, and the initial
errors at the top of this log, are not repeated again. From knowing my
code, if there were other issues with the code itself the top errors
would have been repeated.

So I am mostly concerned with the

Internal error code 103

and the SQL error code -504.


I tested out the queries above, the they do work fine. I did not get any
errors of this nature or at all before the upgrade to Firebird.

So will the patch solve this, or do I have other issues going on. I am
sorry to be vague, but any comments, opinions, or suggestions are
greatly appreciated.


--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com