This looks like a Hibernate error, not a Derby error. I've been using Hibernate 3 with Derby for a few years and never had any issues. Is this query generated by Hibernate? It seems like you are using HQL (the error is in org.hibernate.hql.ast.QuerySyntax) , but you are feeding it SQL syntax. HQL syntax is similar but not equal to SQL.
Brett On Mon, May 31, 2010 at 8:00 PM, anyz <anyz...@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 > >