--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:

> > I am in the process of testing a application which I am migrating
> > from Interclient 1.6 to jbird 1.5. The database is Dialect 1.
>
> Did you change the server as well?

The test server is a fresh install, Mandrake 10.1, Firebird 1.5.2,
JBird 1.5.5

> Also, you should specify the sqlDialect=1 property.

Its set. The connection url is

jdbc:firebirdsql://localhost/RiskAssessment.fdb?sqldialect=1

The stack trace of the error is

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic
SQL Error
SQL error code = -804
Data type unknown
at org.firebirdsql.jdbc.AbstractPreparedStatement.
(AbstractPreparedStatement.java:88)
at org.firebirdsql.jdbc.FBPreparedStatement.
(FBPreparedStatement.java:34)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:701)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:232)
at uk.co.tpmi.aktiv.framework.StoreData.execSQL
(StoreData.java:334)
at uk.co.tpmi.sql2html.HTTPStoreData.performUpdate
(HTTPStoreData.java:299)
at uk.co.tpmi.sql2html.HTTPStoreData.doGet
(HTTPStoreData.java:337)
at uk.co.tpmi.sql2html.HTTPStoreData.doPost
(HTTPStoreData.java:367)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at uk.co.tpmi.aktiv.framework.TemplateServlet.service
(TemplateServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service
(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -804
Data type unknown
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1816)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1769)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
(GDS_Impl.java:1267)
at org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:773)
at org.firebirdsql.jdbc.AbstractConnection.prepareSQL
(AbstractConnection.java:958)
at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement
(AbstractStatement.java:1047)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement
(AbstractPreparedStatement.java:904)
at org.firebirdsql.jdbc.AbstractPreparedStatement.
(AbstractPreparedStatement.java:86)
at org.firebirdsql.jdbc.FBPreparedStatement.
(FBPreparedStatement.java:34)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:701)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:232)
at uk.co.tpmi.aktiv.framework.StoreData.execSQL
(StoreData.java:334)
at uk.co.tpmi.sql2html.HTTPStoreData.performUpdate
(HTTPStoreData.java:299)
at uk.co.tpmi.sql2html.HTTPStoreData.doGet
(HTTPStoreData.java:337)
at uk.co.tpmi.sql2html.HTTPStoreData.doPost
(HTTPStoreData.java:367)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at uk.co.tpmi.aktiv.framework.TemplateServlet.service
(TemplateServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service
(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Regards
Ian Newby