db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anyz <anyz...@gmail.com>
Subject Hibernate 3 Outer Join Problem
Date Mon, 31 May 2010 11:00:53 GMT
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

Mime
View raw message