Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 77466 invoked from network); 11 Jan 2007 03:02:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jan 2007 03:02:48 -0000 Received: (qmail 31685 invoked by uid 500); 11 Jan 2007 03:02:55 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 31582 invoked by uid 500); 11 Jan 2007 03:02:54 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 31573 invoked by uid 99); 11 Jan 2007 03:02:54 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 19:02:54 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 19:02:47 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 779117142D4 for ; Wed, 10 Jan 2007 19:02:27 -0800 (PST) Message-ID: <24468047.1168484547485.JavaMail.jira@brutus> Date: Wed, 10 Jan 2007 19:02:27 -0800 (PST) From: "wanyna (JIRA)" To: open-jpa-dev@incubator.apache.org Subject: [jira] Created: (OPENJPA-101) enhance JPQL Constructor Expressions implementation MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org enhance JPQL Constructor Expressions implementation --------------------------------------------------- Key: OPENJPA-101 URL: https://issues.apache.org/jira/browse/OPENJPA-101 Project: OpenJPA Issue Type: Improvement Components: query Reporter: wanyna There are two tables A and B, I need to execute sql like "insert into A select ... from B". I use JPQL Constructor Expressions, select new A(...) from B, got A list then persist. But some fields of A depends on program context, not direct from B, so SELECT NEW clause should look like these : select new A(B.column1, 'xxx') from B, or select new A(null, B.column2) from B, or select new A(variable, B.column2) from B. Unfortunately, OpenJPA doesn't support this. I have to get the result object[] list and constuct A in my code now. If JPQL Constructor Expressions become more powerful, my code will be more simple then. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira