Subject RE: [Firebird-Java] Firebird iBatis error
Author Sunil Sreedharan
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 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?


-----Original Message-----
[]On Behalf Of Roman Rokytskyy
Sent: Wednesday, October 25, 2006 6:35 PM
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=""
> 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?


Yahoo! Groups Links