Return-Path: 
 <user-java-return-16545-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 99586 invoked from network); 27 Mar 2009 08:54:44 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 27 Mar 2009 08:54:44 -0000
Received: (qmail 54744 invoked by uid 500); 27 Mar 2009 08:54:44 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 54690 invoked by uid 500); 27 Mar 2009 08:54:43 -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 54682 invoked by uid 99); 27 Mar 2009 08:54:43 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 08:54:43 +0000
X-ASF-Spam-Status: No, hits=3.4 required=10.0
	tests=HTML_MESSAGE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [213.41.74.9] (HELO mail04.net-streams.fr) (213.41.74.9)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 08:54:35 +0000
Received: from ec8l7ljvo9h5dde.hosting.exch [10.16.3.20] by
 mail04.net-streams.fr with ESMTP
  (SMTPD-9.10) id A4370308; Fri, 27 Mar 2009 09:54:15 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C9AEB9.CE575042"
Subject: Problem with prepend
Date: Fri, 27 Mar 2009 09:55:01 +0100
Message-ID: 
 <55DDB08CC9CD2941A70E8D626789A2C911594DF3@ec8l7ljvo9h5dde.hosting.exch>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Problem with prepend
Thread-Index: Acmuubbls67jK85LTna5OyBqRYlUGQ==
From: "Winarto" <winarto@fermat.eu>
To: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

This is a multi-part message in MIME format.

------_=_NextPart_001_01C9AEB9.CE575042
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

=20

I'm having problem with the following select statement.

=20

        SELECT * FROM contexts

        <dynamic prepend=3D"WHERE" >

            <isNotNull property=3D"workspace_Id">

                workspace_id =3D #workspace_Id#

            </isNotNull>

            <isNotNull prepend=3D"AND" property=3D"context_Id">

                context_id =3D #context_Id#

            </isNotNull>

            <isNotNull prepend=3D"AND" property=3D"position">

                position =3D #position#

            </isNotNull>

            <isNull prepend=3D"AND" property=3D"position">

                position =3D 0

            </isNull>

        </dynamic>

=20

The data type of property position is java.lang.Integer. My intention =
is: whenever position is not null, use "AND position =3D ?" and whenever =
position is null, use "AND position =3D 0".  However what I got in my =
debug log is the prepend AND before position never come up.=20

Following is the statement generated:

When position is not null =E8 SELECT * FROM contexts WHERE workspace_Id =
=3D ?      position =3D ?

When position is null =E8 SELECT * FROM contexts WHERE workspace_Id =3D =
?      position =3D 0

=20

I was wondering what's wrong with my dynamic select statement. I'm using =
IBatis version 2.3.4.726. I tried to debug the source code and found out =
that when it is processing the <isNull> tag, it tries to get the prepend =
attribute of the <dynamic> tag.

=20

Can anyone enlighten me? Any help is very much appreciated.

=20

Cheers,

Winarto

=20


------_=_NextPart_001_01C9AEB9.CE575042
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:D=3D"DAV:" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
 xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types"=
 =
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-SG link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>Hi All,<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I&#8217;m having problem with the following select =
statement.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0 SELECT * FROM =
contexts<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0 &lt;dynamic =
prepend=3D&quot;WHERE&quot; &gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &lt;isNotNull
property=3D&quot;workspace_Id&quot;&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
workspace_id =3D #workspace_Id#<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
&lt;/isNotNull&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &lt;isNotNull =
prepend=3D&quot;AND&quot;
property=3D&quot;context_Id&quot;&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
context_id =3D #context_Id#<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
&lt;/isNotNull&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &lt;isNotNull =
prepend=3D&quot;AND&quot;
property=3D&quot;position&quot;&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
position =3D #position#<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
&lt;/isNotNull&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 &lt;isNull =
prepend=3D&quot;AND&quot;
property=3D&quot;position&quot;&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
position =3D 0<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
&lt;/isNull&gt;<o:p></o:p></p>

<p class=3DMsoNormal>=A0=A0=A0=A0=A0=A0=A0 =
&lt;/dynamic&gt;<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>The data type of property position is =
java.lang.Integer. My
intention is: whenever position is not null, use &#8220;AND position =3D =
?&#8221;
and whenever position is null, use &#8220;AND position =3D 0&#8221;.=A0 =
However
what I got in my debug log is the prepend AND before position never come =
up. <o:p></o:p></p>

<p class=3DMsoNormal>Following is the statement =
generated:<o:p></o:p></p>

<p class=3DMsoNormal>When position is not null <span =
style=3D'font-family:Wingdings'>=E8</span>
SELECT * FROM contexts WHERE workspace_Id =3D ? =A0=A0=A0=A0=A0position =
=3D ?<o:p></o:p></p>

<p class=3DMsoNormal>When position is null <span =
style=3D'font-family:Wingdings'>=E8</span>
SELECT * FROM contexts WHERE workspace_Id =3D ? =A0=A0=A0=A0=A0position =
=3D 0<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I was wondering what&#8217;s wrong with my dynamic =
select
statement. I&#8217;m using IBatis version 2.3.4.726. I tried to debug =
the source
code and found out that when it is processing the &lt;isNull&gt; tag, it =
tries
to get the prepend attribute of the &lt;dynamic&gt; tag.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Can anyone enlighten me? Any help is very much =
appreciated.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Cheers,<o:p></o:p></p>

<p class=3DMsoNormal>Winarto<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01C9AEB9.CE575042--