db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Wooldridge <brett.wooldri...@gmail.com>
Subject Re: Hibernate 3 Outer Join Problem
Date Mon, 31 May 2010 14:55:49 GMT
When you say "Hibernate 3", what specific version are you talking about?
 While this is more of a Hibernate question than a Derby question, what is
the structure of the two tables (for Project and Program) and what does the
mapping look like?

Brett


On Mon, May 31, 2010 at 10:52 PM, anyz <anyz111@gmail.com> wrote:

> Its seems to be hibernate issue. Dialect in hibernate 3 is not uptodate i
> think.
>
> We tried it as below:
>
> SELECT proj, prog, FROM Project proj, Program prog
>
> but it didn't work.
>
>
> On Mon, May 31, 2010 at 6:19 PM, Donald McLean <dmclean62@gmail.com>wrote:
>
>> Have you tried explicitly specifying the table? i.e. Project.proj
>>
>> On Mon, May 31, 2010 at 7:00 AM, 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
>> >
>>
>>
>>
>> --
>> Family photographs are a critical legacy for
>> ourselves and our descendants. Protect that
>> legacy with a digital backup and recovery plan.
>>
>> Join the photo preservation advocacy Facebook group:
>> http://www.facebook.com/home.php?ref=logo#/group.php?gid=148274709288
>>
>
>

Mime
View raw message