Return-Path: Delivered-To: apmail-openjpa-users-archive@locus.apache.org Received: (qmail 91742 invoked from network); 28 Nov 2008 15:18:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Nov 2008 15:18:35 -0000 Received: (qmail 57799 invoked by uid 500); 28 Nov 2008 15:18:46 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 57649 invoked by uid 500); 28 Nov 2008 15:18:46 -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 57635 invoked by uid 99); 28 Nov 2008 15:18:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 07:18:46 -0800 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists+1214986160035-208411@n2.nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 28 Nov 2008 15:17:18 +0000 Received: from tervel.nabble.com ([192.168.236.150]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1L656a-0002oq-AQ for users@openjpa.apache.org; Fri, 28 Nov 2008 07:18:04 -0800 Message-ID: <1227885484318-1589541.post@n2.nabble.com> Date: Fri, 28 Nov 2008 07:18:04 -0800 (PST) From: piltrafeta To: users@openjpa.apache.org Subject: Call Stored Procedures hibernate annotations MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: piltrafeta@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org I'm using hibernate annotations and i'd like to use a stored procedure which returns a resultset. I kow to do it whit hbm files but i'd like directly by createSQLQuery. Maybe something like this is possible: List list = session.createSQLQuery("call PK_TRUCK_APPOINT_ORDER.FN_TRABA_CHKCTR_resulset(?,?)") .setParameter(0, container) .setParameter(1, user) .list(); Thanks in advance! -- View this message in context: http://n2.nabble.com/Call-Stored-Procedures-hibernate-annotations-tp1589541p1589541.html Sent from the OpenJPA Users mailing list archive at Nabble.com.