Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 800C811073 for ; Thu, 24 Jul 2014 12:30:37 +0000 (UTC) Received: (qmail 48693 invoked by uid 500); 24 Jul 2014 12:30:37 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 48655 invoked by uid 500); 24 Jul 2014 12:30:37 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 48639 invoked by uid 99); 24 Jul 2014 12:30:36 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jul 2014 12:30:36 +0000 X-ASF-Spam-Status: No, hits=3.4 required=5.0 tests=FORGED_HOTMAIL_RCVD2,FSL_HELO_BARE_IP_2,RCVD_IN_DNSWL_LOW,RCVD_NUMERIC_HELO,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gcaou-users@m.gmane.org designates 80.91.229.3 as permitted sender) Received: from [80.91.229.3] (HELO plane.gmane.org) (80.91.229.3) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Jul 2014 12:30:32 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1XAI9t-0002c9-91 for users@openjpa.apache.org; Thu, 24 Jul 2014 14:30:05 +0200 Received: from 32.104.18.240 ([32.104.18.240]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Jul 2014 14:30:05 +0200 Received: from guilherangel by 32.104.18.240 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 24 Jul 2014 14:30:05 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: users@openjpa.apache.org From: Guilherme Ferreira Subject: Re: JPQL and DB2 native code Date: Thu, 24 Jul 2014 12:26:29 +0000 (UTC) Lines: 39 Message-ID: References:

Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: sea.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 32.104.18.240 (Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Firefox/24.0) X-Virus-Checked: Checked by ClamAV on apache.org Christophe Marcourt writes: > > Hi Kevin, > > yes I'm using temporal data from DB2 . > I'm already querying DB2 in SQL native and I had to do a "mapper" for my > entities as my DAO is a generic one. Quite tough. My problem is the > Inheritance annotation for the joined strategy. In JPA it's automatic but > in pure SQL : nada ! > > So that's why I was asking for a way to intercept JPQL parsing. But it > seems it's not possible. > > I'm afraid I have to do it on my own. > > Cheers. > > Christophe Marcourt > Hi Christophe, Have you been able to figure out a way of using DB2 temporal queries with JPA? I've been facing a similar issue, where I've also been able to issue pure, native SQL queries containing the temporal capabilities, but can't figure out a way of using JPQL with temporal. One of the things I''m trying now is to use the "set special register command", which in some cases might work well, but so far no luck either. Best Regards, Guilherme Ferreira