Hi All,
We have a web app running using firebird 1.02, firebirdsql
1.0rc3 / interclient 1.6. Java 1.3.1. The database is dialect 1, as
interclient 1.6 does not support dialect 3.

We are trying to remove interclient from our system.

The following query works fine with interclient:

select cast((aa.aud_score + 1) * 20 as numeric(10,1)) as percent,
aa.*, t.*
from audit_answers aa
join question_types t on aa.qtp_id = t.qtp_id
join audit_templates l on t.lng_language = l.lng_language and
t.atp_id = l.atp_id
join audits a on a.aut_id = l.aut_id and aa.aud_id = a.aud_id
where aa.aud_id = ? and aa.qtn_id = ? and t.qtp_calculated = 'F' and
aa.aud_score is not null
order by t.qtp_id

However, if we switch the app to use firebird sql we get the
following error...

org.firebirdsql.jdbc.FBSQLException: GDS Exception. No message for
code 335544569 found.
No message for code 335544436 found.
null
No message for code 335544793 found.
null
at org.firebirdsql.jdbc.FBPreparedStatement.<init>
(FBPreparedStatement.java:81)
at org.firebirdsql.jdbc.FBConnection.prepareStatement
(FBConnection.java:223)
at uk.co.wmeng.sql2html.SQLData.<init>(SQLData.java:34)
at uk.co.wmeng.sql2html.SQLDataBand.<init>
(SQLDataBand.java:29)
at uk.co.wmeng.sql2html.HTMLReporter.createBands
(HTMLReporter.java:116)
at uk.co.wmeng.sql2html.HTMLReporter.doGet
(HTMLReporter.java:242)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:740)
at uk.co.wmeng.webframework.TemplateServlet.service
(TemplateServlet.java
:391)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:853)
at com.mortbay.HTTP.Handler.Servlet.ServletHolder.handle
(ServletHolder.j
ava:488)
at com.mortbay.HTTP.Handler.Servlet.ServletHandler.handle
(ServletHandler
.java:457)
at com.mortbay.HTTP.Handler.Servlet.ServletHandler.handle
(ServletHandler
.java:291)
at com.mortbay.HTTP.HandlerContext.handle
(HandlerContext.java:1147)
at com.mortbay.HTTP.HttpServer.service(HttpServer.java:757)
at com.mortbay.HTTP.HttpConnection.service
(HttpConnection.java:477)
at com.mortbay.HTTP.HttpConnection.handle
(HttpConnection.java:334)
at com.mortbay.HTTP.SocketListener.handleConnection
(SocketListener.java:
106)
at com.mortbay.Util.ThreadedServer.handle
(ThreadedServer.java:294)
at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run
(ThreadPool.java:59
9)
at java.lang.Thread.run(Thread.java:484)
at org.firebirdsql.gds.GDSException: No message for code 335544569
found.
No message for code 335544436 found.
null
No message for code 335544793 found.
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1683)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1636)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
(GDS_Impl.java:1171)
at org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:762)
at org.firebirdsql.jdbc.FBConnection.prepareSQL
(FBConnection.java:1082)
at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement
(FBStatement.java:942)
at
org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement(FBPrep
aredStatement.java:699)
at org.firebirdsql.jdbc.FBPreparedStatement.<init>
(FBPreparedStatement.java:78)
at org.firebirdsql.jdbc.FBConnection.prepareStatement
(FBConnection.java:223)
at uk.co.wmeng.sql2html.SQLData.<init>(SQLData.java:34)
at uk.co.wmeng.sql2html.SQLDataBand.<init>
(SQLDataBand.java:29)
at uk.co.wmeng.sql2html.HTMLReporter.createBands
(HTMLReporter.java:116)
at uk.co.wmeng.sql2html.HTMLReporter.doGet
(HTMLReporter.java:242)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:740)
at uk.co.wmeng.webframework.TemplateServlet.service
(TemplateServlet.java:391)
at javax.servlet.http.HttpServlet.service
(HttpServlet.java:853)
at com.mortbay.HTTP.Handler.Servlet.ServletHolder.handle
(ServletHolder.java:488)
at com.mortbay.HTTP.Handler.Servlet.ServletHandler.handle
(ServletHandler.java:457)
at com.mortbay.HTTP.Handler.Servlet.ServletHandler.handle
(ServletHandler.java:291)
at com.mortbay.HTTP.HandlerContext.handle
(HandlerContext.java:1147)
at com.mortbay.HTTP.HttpServer.service(HttpServer.java:757)
at com.mortbay.HTTP.HttpConnection.service
(HttpConnection.java:477)
at com.mortbay.HTTP.HttpConnection.handle
(HttpConnection.java:334)
at com.mortbay.HTTP.SocketListener.handleConnection
(SocketListener.java:106)
at com.mortbay.Util.ThreadedServer.handle
(ThreadedServer.java:294)
at com.mortbay.Util.ThreadPool$PoolThreadRunnable.run
(ThreadPool.java:599)
at java.lang.Thread.run(Thread.java:484)
13:58:41.105 WARN!! org.firebirdsql.jdbc.FBSQLException: GDS
Exception. No message for code 335544569 found.
+ No message for code 335544436 found.
+ null
+ No message for code 335544793 found.
+ null


What do I have to do to get the correct text for the error codes?

Also why is it working with interclient and not firebirdsql? When we
connect to firebirdsql we put a ?sql_dialect=1 on the end.

Regards
Ian Newby