Thanks for the quick reply.

My original problem was resolved as I figured out that the character set was
the culprit.

The jar jaybird-full-2.0.1.jar is in tomcat lib folder and I also checked
that the isc_error_msg.properties file is contained in it. However, I
searched in the properties file and found that the error code that I was
getting (335544854) was not present in the file.

Am I using a wrong file?

Regards,
Sunil

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com]On Behalf Of Roman Rokytskyy
Sent: Wednesday, October 25, 2006 6:35 PM
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Firebird iBatis error

> 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




Yahoo! Groups Links