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