hi,

at 2), i think you should cast "null" in the appropiate type.



On Thu, 10 Nov 2005 15:18:28 +0100, Marco Parmeggiani <marcopar@...>
wrote:

> Hi, back on the list after some quite time.
> I have a question on Hibernate and firebird and i've already asked on
> the hibernate forum. Maybe here there someone more firebird oriented.
>
> Hibernate 3.0.5
> Firebird 1.5.2
> I have a mapping (table-per-concrete-class, chapter 10.1.5, reference
> 3.0.5) that generates a query of this type:
>
> 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_
>
> This query is not good for Firebird...
> I can see problems in 2 diferent points:
> 1.
> select ... from (select
>
> NOT SUPPORTED AFAIK
>
> 2.
> 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
>
> executing this out of hibernate gives me syntax error.
>
>
> so, the question is: how to solve this problem?
> How to tell hibernate to generate valid firebird SQL?
>
> Thanks
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>

--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/