[hibernate-dev] derby support
Emmanuel Bernard
emmanuel at hibernate.org
Tue Aug 1 14:07:42 EDT 2006
https://issues.apache.org/jira/browse/DERBY-1624
and also regarding some decent JPA certification
https://issues.apache.org/jira/browse/DERBY-1623
There are probably other limitations hidden
Steve Ebersole wrote:
> I am working on enhancing Derby support a little bit, but have run into
> an issue with their syntax that I am unable to figure out. I was hoping
> someone on this list was familiar enough with Derby to point me in the
> right direction.
>
> Specifically, I am trying to properly deal with the manner in which
> Derby (and also DB2 largely) expects columns to be referenced in certain
> clauses. For example, because Hibernate always aliases columns in the
> select clause, derby requires that those aliases be used in certain
> later clauses. The query I am trying to work through right now is as
> follows:
> select
> model0_.name as col_0_0_,
> count(*) as col_1_0_
> from
> Model model0_
> group by
> model0_.name
> having
> count(*) > 1
>
> However, I get errors from Derby when passing this to the DB:
> ERROR 42X04: Column 'MODEL0_.COL_0_0_' is either not in any table in the
> FROM list or appears within a join specification and is outside the
> scope of the join specification or appears in a HAVING clause and is not
> in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then
> 'MODEL0_.COL_0_0_' is not a column in the target table.
>
> If the having clause is removed, the query parses fine; I have tried
> various incantations regarding how to define the having clause without
> avail.
>
> This query seems taken almost verbatim from their reference docs, yet I
> cannot get this to work...
> http://db.apache.org/derby/docs/10.1/ref/rrefselectexpression.html
>
> Any thoughts?
>
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>
>
More information about the hibernate-dev
mailing list