I used the same HQL sysntax for mySQL and it worked. Further Derby manuall lists the same syntax for join.
On Mon, May 31, 2010 at 6:45 PM, Brett Wooldridge < [email protected]> wrote: > 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 <[email protected]> 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 >> >> > >
