Return-Path: 
 <user-java-return-8882-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 73887 invoked from network); 5 Sep 2006 15:34:48 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 5 Sep 2006 15:34:48 -0000
Received: (qmail 34275 invoked by uid 500); 5 Sep 2006 15:34:46 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 34261 invoked by uid 500); 5 Sep 2006 15:34:46 -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 34250 invoked by uid 99); 5 Sep 2006 15:34:46 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 08:34:46 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=DNS_FROM_RFC_ABUSE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.182.187 as permitted sender)
Received: from [64.233.182.187] (HELO nf-out-0910.google.com) (64.233.182.187)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 08:34:45 -0700
Received: by nf-out-0910.google.com with SMTP id l23so1437876nfc
        for <user-java@ibatis.apache.org>;
 Tue, 05 Sep 2006 08:34:23 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=KN0KVkPc13e1CFDYLVKjh2jbOYCzy2QwNLgHv1Q9fF4sBo7/ja2y0GADA61THImsys4UCughyNc1Lhtgq9Z4rZLN70Bo+iy3yjOKzOzd1V7vR+pu5fKQumTVVYSXSCXgw6ZK7ksGqN9hZ07CSyizJjt2KsCTBjCNE0RE0BRdFDk=
Received: by 10.48.220.15 with SMTP id s15mr7921269nfg;
        Tue, 05 Sep 2006 08:34:23 -0700 (PDT)
Received: by 10.49.19.13 with HTTP; Tue, 5 Sep 2006 08:34:23 -0700 (PDT)
Message-ID: <a10a823c0609050834n596c6749u4cd05f7c54d0decd@mail.gmail.com>
Date: Tue, 5 Sep 2006 09:34:23 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Exception occured in iBatis Dynamic queries and resultMap
In-Reply-To: <50CA25BD6EEA954FA592C097399942E313A80CFC@CM1.wis.local>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <50CA25BD6EEA954FA592C097399942E313A80CFC@CM1.wis.local>
X-Google-Sender-Auth: d1881cf4240410be
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Do you have the DTD stuff, too?

SqlMapConfig.xml:
---
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
---

SqlMap.xml:
---
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
---

Larry


On 9/5/06, Niels Beekman <n.beekman@wis.nl> wrote:
> And you should replace the isNotEmpty with the
> isParameterPresent-element.
>
> Niels
>
> -----Original Message-----
> From: Datta [mailto:datta.saru@gmail.com]
> Sent: dinsdag 5 september 2006 16:48
> To: user-java@ibatis.apache.org
> Subject: Exception occured in iBatis Dynamic queries and resultMap
>
>
> Hi all,
> I have just written this code for getting employee record based on
> deptno.
> plz help with some good tutorials/books on iBatis for Dynamic
> queries...........................
> My sqlMap is:
> <sqlMap namespace="Employee">
>         <resultMap id="get-employee-result" class="src.Employee">
>           <result property="empNo" column="empno" />
>           <result property="empName" column="empname" />
>           <result property="deptNo" column="deptNo" />
>           <result property="dname" column="dname" />
>          </resultMap>
>         <select id="getEmployee" resultMap="get-employee-result">
>                 SELECT * FROM MYIBATISEMP       <dynamic
> prepend="WHERE">
>                 <isNotEmpty property="deptNo">
>                         deptNo = #deptno#
>                 </isNotEmpty>
>         </dynamic>
>         </select>
> </sqlMap>
> and the corresponding java code is:
> String deptNo = "9";
> Employee emp =
>         (Employee)sqlMap.queryForObject("getEmployee",deptNo);
>         System.out.println("Employee No = " + emp.getEmpNo());
>         System.out.println("Dept Name = " + emp.getDname());
>         System.out.println("Dept No = " + emp.getDeptNo());
>         System.out.println("EmpName = " + emp.getEmpName());
> and the error am getting is:
> ======================================
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in maps/Employee.xml.
> --- The error occurred while preparing the mapped statement for
> execution.
> --- Check the getEmployee.
> --- Check the parameter map.
> --- Cause: com.ibatis.common.beans.ProbeException: There is no READABLE
> property named 'deptNo' in class 'java.lang.String'
> Caused by: com.ibatis.common.beans.ProbeException: There is no READABLE
> property named 'deptNo' in class 'java.lang.String'.............
>
> --
> View this message in context:
> http://www.nabble.com/Exception-occured-in-iBatis-Dynamic-queries-and-re
> sultMap-tf2221179.html#a6153351
> Sent from the iBATIS - User - Java forum at Nabble.com.
>
>