Hi have a problem with a "table pre concrete class" inheritance mapping using firebird 1.5 and hibernate 3.0.5.
When i select data from tables Hibernate generates a query that does not work with firebird. The query uses the syntax "select * from (select ...) that is not supported on firebird 1.5. Is there a way to tell Hibernate to use some other method to select data from that "mapping"?

Hibernate version:
3.0.5
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at testhibernate.Main.main(Main.java:55)
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 129
select
at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:88)
at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:701)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 6 more
Java Result: 1
Name and version of the database you are using:
Firebird 1.5
The generated SQL (show_sql=true):
Hibernate: select plottable0_.PL_ID as PL1_, plottable0_.AR_CX as AR1_2_, plottable0_.LI_X1 as LI1_3_, plottable0_.clazz_ as clazz_ from ( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ) plottable0_
WARN - SQL Error: 335544569, SQLState: HY000
ERROR - GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 129
select
WARN - SQL Error: 335544569, SQLState: HY000
ERROR - GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 129
select
Debug level Hibernate log excerpt:
DEBUG - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (Plottable,ARCO,LINEA)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'plottable0_.PL_ID as PL1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ),tableAlias=plottable0_,colums={,className=testhibernate.Plottable}}}
| \-[SQL_TOKEN] SqlFragment: 'plottable0_.AR_CX as AR1_2_, plottable0_.LI_X1 as LI1_3_, plottable0_.clazz_ as clazz_'
\-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[plottable0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
\-[FROM_FRAGMENT] FromElement: '( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ) plottable0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ),tableAlias=plottable0_,colums={,className=testhibernate.Plottable}}

DEBUG - throwQueryException() : no errors
DEBUG - HQL: from testhibernate.Plottable
DEBUG - SQL: select plottable0_.PL_ID as PL1_, plottable0_.AR_CX as AR1_2_, plottable0_.LI_X1 as LI1_3_, plottable0_.clazz_ as clazz_ from ( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ) plottable0_
DEBUG - throwQueryException() : no errors
DEBUG - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG - select plottable0_.PL_ID as PL1_, plottable0_.AR_CX as AR1_2_, plottable0_.LI_X1 as LI1_3_, plottable0_.clazz_ as clazz_ from ( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ) plottable0_
Hibernate: select plottable0_.PL_ID as PL1_, plottable0_.AR_CX as AR1_2_, plottable0_.LI_X1 as LI1_3_, plottable0_.clazz_ as clazz_ from ( select null as AR_CX, null as LI_X1, PL_ID, 0 as clazz_ from Plottable union select AR_CX, null as LI_X1, PL_ID, 1 as clazz_ from ARCO union select null as AR_CX, LI_X1, PL_ID, 2 as clazz_ from LINEA ) plottable0_
DEBUG - preparing statement
DEBUG - SQL Exception
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 129
select