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.
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.QuerySyntaxCould you please guid if Hibernate dialect support for Derbby is not that good of i'm missing something.thanks