> I am using firebird embedded and iBatis to build a small application. My
> sql Map looks like this

> <select id="validateUser" parameterClass="com.esq.intr.to.UserTo"
> resultClass="java.lang.String">
> SELECT USER_F_NAME from USER_MASTER where USER_ID = #userId#
> </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
isc_error_msg.properties in classpath
b) something wrong is with classloader that loaded Jaybird and it does not
allow access to the isc_error_msg.properties 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?

Roman