Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 15390 invoked from network); 13 Jun 2006 03:41:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 13 Jun 2006 03:41:30 -0000 Received: (qmail 23563 invoked by uid 500); 13 Jun 2006 03:41:28 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 23529 invoked by uid 500); 13 Jun 2006 03:41:28 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 23518 invoked by uid 99); 13 Jun 2006 03:41:27 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Jun 2006 20:41:27 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of mithun.ruikar@gmail.com designates 66.249.92.173 as permitted sender) Received: from [66.249.92.173] (HELO ug-out-1314.google.com) (66.249.92.173) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Jun 2006 20:41:27 -0700 Received: by ug-out-1314.google.com with SMTP id c2so2743837ugf for ; Mon, 12 Jun 2006 20:41:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MT3ye2wCkGcI7Z98g5B64a9XQZio//pQBR7cxKJ8wNSvHExdIl8PorCdoStDI5zyOrBMou/ILb2GSPwQcOpPVwurh7aGktbyHwEsnDN/ETiIZKUuYcole0sTqm3F/XXJ3y49lJxt9Yz73a0mPx98s0AIJFBaXBJBeMsfPJiFUfY= Received: by 10.67.97.7 with SMTP id z7mr5847697ugl; Mon, 12 Jun 2006 20:41:05 -0700 (PDT) Received: by 10.67.31.4 with HTTP; Mon, 12 Jun 2006 20:41:05 -0700 (PDT) Message-ID: <516f93ac0606122041o4666d54ft8c2bfc51663980ee@mail.gmail.com> Date: Tue, 13 Jun 2006 11:41:05 +0800 From: "Mithun Ruikar" To: user-java@ibatis.apache.org Subject: Selecting subset of column In-Reply-To: <516f93ac0606122006p1d33f2b1r8250c9132329648b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <516f93ac0606122006p1d33f2b1r8250c9132329648b@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello, I have resultmap mapping columns of one table to one bean. But i want to add select statement to get next sequence number. SELECT TO_CHAR(SYSDATE, 'YYYYMMDD') || LPAD(SEQ.NEXTVAL, 12, '0') TABLE_ID FROM DUAL this returns me next sequence number as value of one column named TABLE_ID which is one of column of my table whose columns i have mapped in resultmap to bean. So when i use sqlMap.queryForObject(ID, null, new BeanMapped()); should it return me BeanMapped with field tableId set to next sequence number? Because currently it is returning null. Thank you, -- Mithun