db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anyz <anyz...@gmail.com>
Subject Re: Hibernate 3 Outer Join Problem
Date Mon, 31 May 2010 13:52:16 GMT
Its seems to be hibernate issue. Dialect in hibernate 3 is not uptodate i
think.

We tried it as below:

SELECT proj, prog, FROM Project proj, Program prog

but it didn't work.

On Mon, May 31, 2010 at 6:19 PM, Donald McLean <dmclean62@gmail.com> wrote:

> Have you tried explicitly specifying the table? i.e. Project.proj
>
> On Mon, May 31, 2010 at 7:00 AM, anyz <anyz111@gmail.com> wrote:
> > i'm trying to use hibernate 3 with Derby 10.6. Normal queries work good
> but
> > using left outer join creates problem. The query i'm trying loads project
> > program if it exists and if programm not exists the project information
> is
> > loaded:
> >
> > SELECT proj, prog FROM Project
> > LEFT OUTER JOIN Program ON Program.programId = Project.programId
> > WHERE Project.projectName = '"MyProject"
> >
> > The error on executing query is :
> >
> > unexpected token: ON near line 1, column xxx [SELECT proj, prog, FROM
> > a.b.Project LEFT OUTER JOIN Program ON Program.programId =
> Project.programId
> > WHERE Project.projectName = 'MyProject' ]
> > at org.hibernate.hql.ast.QuerySyntax
> >
> > Could you please guid if Hibernate dialect support for Derbby is not that
> > good of i'm missing something.
> >
> > thanks
> >
>
>
>
> --
> Family photographs are a critical legacy for
> ourselves and our descendants. Protect that
> legacy with a digital backup and recovery plan.
>
> Join the photo preservation advocacy Facebook group:
> http://www.facebook.com/home.php?ref=logo#/group.php?gid=148274709288
>

Mime
View raw message