SELECT proj, prog, FROM Project proj, Program prog
but it didn't work.
Have you tried explicitly specifying the table? i.e. Project.proj
On Mon, May 31, 2010 at 7:00 AM, anyz <firstname.lastname@example.org> 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
> 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.
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: