Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 81909 invoked from network); 31 May 2010 13:52:46 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 31 May 2010 13:52:46 -0000 Received: (qmail 63674 invoked by uid 500); 31 May 2010 13:52:45 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 63647 invoked by uid 500); 31 May 2010 13:52:45 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 63640 invoked by uid 99); 31 May 2010 13:52:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 13:52:45 +0000 X-ASF-Spam-Status: No, hits=4.4 required=10.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of anyz111@gmail.com designates 74.125.83.44 as permitted sender) Received: from [74.125.83.44] (HELO mail-gw0-f44.google.com) (74.125.83.44) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 May 2010 13:52:39 +0000 Received: by gwj19 with SMTP id 19so2797556gwj.31 for ; Mon, 31 May 2010 06:52:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=8qITXmTotpGTyI2Buoe2qvXjoxMTeXdiQVbICu795hY=; b=hjMrJF/3lIv1X+PSNpjGe/V4TySTy1wzkna3VQFnV/2R8Alq/NR4ilVG8yO2VZdPSV F2V64e9glwVXqzlti0nxZbLreFESoyJCN7gCsefQndOtpQh9NYlPpA0khJcUryPT27AV D9jmOQnQApTbWkeeUE8Fq/ZE+WFh+pMduD7wk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=UJ/EiJ0P2M3oruqdyhB0xrLk3AUkyuCtH9W+wR1bFP2EYp69+V1xzDB//75n9urReY Gg2AcvKBDMb8hCp1N38LUFHa5NGlUc/ogdJV+TPWnSHrxapO8PNsfaeyzaRo+NXIUNCj T7orQczVPK2ugdKPnpiOqzX7Z577XJLXBLlE0= MIME-Version: 1.0 Received: by 10.91.162.16 with SMTP id p16mr2356611ago.101.1275313938194; Mon, 31 May 2010 06:52:18 -0700 (PDT) Received: by 10.90.49.12 with HTTP; Mon, 31 May 2010 06:52:16 -0700 (PDT) In-Reply-To: References: Date: Mon, 31 May 2010 18:52:16 +0500 Message-ID: Subject: Re: Hibernate 3 Outer Join Problem From: anyz To: Derby Discussion Content-Type: multipart/alternative; boundary=001485f7cad6435fd80487e42aef X-Virus-Checked: Checked by ClamAV on apache.org --001485f7cad6435fd80487e42aef Content-Type: text/plain; charset=ISO-8859-1 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 wrote: > Have you tried explicitly specifying the table? i.e. Project.proj > > On Mon, May 31, 2010 at 7:00 AM, anyz 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 > --001485f7cad6435fd80487e42aef Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Its seems to be hibernate issue. Dialect in hibernate 3 is not uptodat= e i think.
=A0
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 <= span dir=3D"ltr"><dmclean62@gmail= .com> wrote:
Have you tried explicitly specif= ying 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 Proj= ect
> LEFT OUTER JOIN Program ON Program.programId =3D Project.programId
= > WHERE Project.projectName =3D '"MyProject"
>
&g= t; The error on executing query is :
>
> unexpected token: ON n= ear line 1, column=A0xxx [SELECT proj, prog, FROM
> a.b.Project LEFT OUTER JOIN Program ON Program.programId =3D Project.p= rogramId
> WHERE Project.projectName =3D 'MyProject' ]
>= ; at org.hibernate.hql.ast.QuerySyntax
>
> Could you please gui= d if Hibernate dialect support for Derbby is not that
> good of i'm missing something.
>
> thanks
>
<= br>

--
Family photographs are= a critical legacy for
ourselves and our descendants. Protect that
legacy with a digital backup and recovery plan.

Join the photo prese= rvation advocacy Facebook group:
http://www= .facebook.com/home.php?ref=3Dlogo#/group.php?gid=3D148274709288

--001485f7cad6435fd80487e42aef--