Subject Re: [Firebird-Java] Firebird iBatis error
Author Roman Rokytskyy
> I am using firebird embedded and iBatis to build a small application. My
> sql Map looks like this

> <select id="validateUser" parameterClass=""
> resultClass="java.lang.String">
> </select>

> On execution, I get the below error
> SEVERE: Servlet.service() for servlet jsp threw exception
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in sql/Common.sql.
> --- The error occurred while executing query.
> --- Check the SELECT user_F_NAME from USER_MASTER where USER_ID =
> ? .
> --- Check the SQL Statement (preparation failed).
> --- Cause: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544854.
> No
> message for code 335544854 found.

Something wrong is with your configuration in the first place - it should
not say "No message for code XXXXX found" - that means that either:

a) you use your custom build and have forgotten to put in classpath
b) something wrong is with classloader that loaded Jaybird and it does not
allow access to the file.

The error you get means "CHARACTER SET {0} is not installed" and I hardly
can explain why do you get it and why removing the WHERE clause fixes the
situation. Can you provide a test case that reproduces the problem?