Return-Path: 
 <user-java-return-7387-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 11882 invoked from network); 15 Jun 2006 19:50:09 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 15 Jun 2006 19:50:09 -0000
Received: (qmail 54853 invoked by uid 500); 15 Jun 2006 19:50:06 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 54834 invoked by uid 500); 15 Jun 2006 19:50:06 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 54823 invoked by uid 99); 15 Jun 2006 19:50:06 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Jun 2006 12:50:06 -0700
X-ASF-Spam-Status: No, hits=0.6 required=10.0
	tests=NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [69.90.179.130] (HELO matrix.aladin.ca) (69.90.179.130)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Jun 2006 12:50:05 -0700
Received: from aladinc by matrix.aladin.ca with local (Exim 4.52)
	id 1Fqxqi-0001o6-MD
	for user-java@ibatis.apache.org; Thu, 15 Jun 2006 15:49:52 -0400
Received: from 127.0.0.1 ([127.0.0.1])
        (SquirrelMail authenticated user ibatis@aladin.ca)
        by www.aladin.ca with HTTP;
        Thu, 15 Jun 2006 15:49:52 -0400 (EDT)
Message-ID: <47151.127.0.0.1.1150400992.squirrel@www.aladin.ca>
In-Reply-To: <46994.127.0.0.1.1150399749.squirrel@www.aladin.ca>
References: <01db01c6901d$bd957da0$0201a8c0@spring>
    <46994.127.0.0.1.1150399749.squirrel@www.aladin.ca>
Date: Thu, 15 Jun 2006 15:49:52 -0400 (EDT)
Subject: Re: isPropertyAvailable doesn't work as expected...
From: ibatis@aladin.ca
To: user-java@ibatis.apache.org
User-Agent: SquirrelMail/1.4.4
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Aladin-ca-MailScanner-Information: Please contact the ISP for more
 information
X-Aladin-ca-MailScanner: Found to be clean
X-Aladin-ca-MailScanner-SpamCheck: 
X-Aladin-ca-MailScanner-From: ibatis@aladin.ca
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - matrix.aladin.ca
X-AntiAbuse: Original Domain - ibatis.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [32003 504] / [47 12]
X-AntiAbuse: Sender Address Domain - aladin.ca
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Problem solved: use <sql> and <include>.

Aladin


>
> I have two simple queries which I am trying to combine using
> <isPropertyAvailable...> but it doesn't seem to work as expected.
>
> Query 1: SELECT requestid FROM users WHERE name = 'test'
> Query 2: SELECT count(*) FROM users WHERE name = 'test'
>
> IN XML:
> =======
> <select id="getResult" resultClass="java.util.Hashtable"
> cacheModel="memory-cache">
> SELECT
> <isPropertyAvailable property="count"> count(*) </isPropertyAvailable>
> <isNotPropertyAvailable property="count"> requestid
> </isNotPropertyAvailable>
> FROM users WHERE name = 'test'
> </select>
>
> RESULT:
> =======
> [DEBUG] - Query key=getResult, params={} (getObjects)
> [DEBUG] - Query key=getResult, params={count=count} (getObjects)
> [ERROR] -
> --- The error occurred in queries.xml.
> --- The error occurred while applying a result map.
> --- Check the getResult-AutoResultMap.
> --- Check the result mapping for the 'requestid' property.
> --- Cause: org.postgresql.util.PSQLException: The column name requestid
> was not found in this ResultSet. (getObjects)
>
> I always get an error in the second query I call.  Am I missing something
> here?
>
> Thanks.
> Aladin
>