db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anyz <anyz...@gmail.com>
Subject Re: Hibernate 3 Outer Join Problem
Date Mon, 31 May 2010 13:48:16 GMT
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 <
brett.wooldridge@gmail.com> 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 <anyz111@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
>>
>>
>
>

Mime
View raw message