org.firebirdsql.jdbc.FBSQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • [FIREBIRD] Problem when i migrate 3.2.2 to 3.4.0
    via by Unknown author,
  • JSP + Servlet + Firebird 1.5 - Front-end - GUJ
    via by Unknown author,
  • SQL query generated by ForwardByQuery service is bad in Firebird database. "DISTINCT" must be after "FIRST" and "SKIP", not before. now it is bad: SELECT DISTINCT FIRST 1 SKIP 0 SERIES.SERIES_IUID, SERIES.RETRIEVE_AETS FROM SERIES INNER JOIN SERIES_REQ ON SERIES.PK = SERIES_REQ.SERIES_FK WHERE SERIES.SERIES_STATUS = 0 AND SERIES.EXT_RETR_AET IS NULL AND SERIES.UPDATED_TIME < ? ORDER BY SERIES.PK it should be: SELECT FIRST 1 SKIP 0 DISTINCT SERIES.SERIES_IUID, SERIES.RETRIEVE_AETS FROM SERIES INNER JOIN SERIES_REQ ON SERIES.PK = SERIES_REQ.SERIES_FK WHERE SERIES.SERIES_STATUS = 0 AND SERIES.EXT_RETR_AET IS NULL AND SERIES.UPDATED_TIME < ? ORDER BY SERIES.PK Bad query is the reason of following exception: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 23 1 at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:127) at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:41) at sun.reflect.GeneratedConstructorAccessor41.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:90) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824) at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:449) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:444) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:265) at org.dcm4chex.archive.ejb.jdbc.BaseCmd.open(BaseCmd.java:194) at org.dcm4chex.archive.ejb.jdbc.BaseCmd.<init>(BaseCmd.java:125) at org.dcm4chex.archive.ejb.jdbc.BaseCmd.<init>(BaseCmd.java:97) at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.<init>(BaseReadCmd.java:68) at org.dcm4chex.archive.ejb.jdbc.QueryForwardCmd.<init>(QueryForwardCmd.java:62)
    via by Jan Pechanec,
  • SymmetricDS Issues
    via by Unknown author,
    • org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204 Table unknown CLIENTE At line 1, column 60 at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:127)
    No Bugmate found.