Return-Path: 
 <user-java-return-5688-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 16448 invoked from network); 25 Jan 2006 10:30:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 Jan 2006 10:30:38 -0000
Received: (qmail 82644 invoked by uid 500); 25 Jan 2006 10:30:36 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 82612 invoked by uid 500); 25 Jan 2006 10:30:36 -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 82599 invoked by uid 99); 25 Jan 2006 10:30:36 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2006 02:30:36 -0800
X-ASF-Spam-Status: No, hits=0.6 required=10.0
	tests=HTML_MESSAGE,NO_REAL_NAME,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of stevenlou@gmail.com designates
 64.233.162.198 as permitted sender)
Received: from [64.233.162.198] (HELO zproxy.gmail.com) (64.233.162.198)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2006 02:30:34 -0800
Received: by zproxy.gmail.com with SMTP id x7so67379nzc
        for <user-java@ibatis.apache.org>;
 Wed, 25 Jan 2006 02:30:13 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=QjSXZsBprOjP9Xy49UgAs49drz+5PS9LXcdnQHJnbKwuGWyEcuzkUPJ0X2LQ932PzwumOSIuLkPJ5AQbzGbEuulALQhQNUFSABDg/elZ/iQNBwnVNaNs5qnJ47JvhUs11pvQfgK/a1sHETjjjX+rcmrwyIj95n372EOBsfyTGGk=
Received: by 10.36.8.15 with SMTP id 15mr442350nzh;
        Wed, 25 Jan 2006 02:30:12 -0800 (PST)
Received: by 10.36.141.1 with HTTP; Wed, 25 Jan 2006 02:30:12 -0800 (PST)
Message-ID: <7dcc9ba80601250230h2156038fm5b0fdce6e07367a3@mail.gmail.com>
Date: Wed, 25 Jan 2006 18:30:12 +0800
From: <stevenlou@gmail.com>
To: user-java@ibatis.apache.org, lmeadors@apache.org
Subject: Problem about ibatis query result in JNDI and SIMPLE connection
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_33662_14537776.1138185012913"
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_33662_14537776.1138185012913
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

 Dear Larry,

Now I encountered one strange problem, we got different result in Jndi and
JDBC"simple" connection, the code is following:
      sqlMap.startTransaction();
      querylist=3DsqlMap.queryForList("PersonInfo.selectAll",role);
      System.out.println(querylist.size());
      ..............
      sqlMap.commitTransaction();

For this query, there are records in database, but in JDBC"JNDI" connection=
,
it can't get any record, the "querylist.size()" always return 0.
But in JDBC"simple" connection, it can return the correct records, what's
wrong? I think they should return some records.

Following are the congiguration in sql-map-config.xml

JDBC-SIMPLE:
  <transactionManager type=3D"JDBC" >
    <dataSource type=3D"SIMPLE">
      <property name=3D"JDBC.Driver" value=3D"COM.ibm.db2.jdbc.app.DB2Drive=
r"/>
   <property name=3D"JDBC.ConnectionURL" value=3D"jdbc:db2:sbb"/>
   <property name=3D"JDBC.Username" value=3D"db2admin"/>
      <property name=3D"JDBC.Password" value=3D"zaq12wsx"/>
    </dataSource>

JDBC-JNDI
 <transactionManager type=3D"JDBC" >
    <dataSource type=3D"JNDI">
      <property name=3D"DataSource" value=3D"jdbc/sbb"/>
    </dataSource>
  </transactionManager>

Look forward to receiving your reply ASAP.

THanks so much for your warm-hearted help.

Thanks and Best Regards
Steven

------=_Part_33662_14537776.1138185012913
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>
<div>Dear Larry,</div>
<div>&nbsp;</div>
<div>Now I encountered one strange problem, we got different result in Jndi=
 and JDBC&quot;simple&quot; connection, the code is following:</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqlMap.startTransaction();<br>&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;querylist=3DsqlMap.queryForList(&quot;Perso=
nInfo.selectAll&quot;,role);</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.out.println(querylist.size(=
));</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;..............&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sqlMap.commitTransaction(=
);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>
<div>&nbsp;</div>
<div>For this query, there are records in database, but in JDBC&quot;JNDI&q=
uot; connection, it can't get any record, the &quot;querylist.size()&quot; =
always return 0. </div>
<div>But in JDBC&quot;simple&quot; connection, it can return the correct re=
cords, what's wrong? I think they should return some records.</div>
<div>&nbsp;</div>
<div>Following are the congiguration in sql-map-config.xml</div>
<div>&nbsp;</div>
<div>JDBC-SIMPLE:</div>
<div>&nbsp; &lt;transactionManager type=3D&quot;JDBC&quot; &gt;<br>&nbsp;&n=
bsp;&nbsp; &lt;dataSource type=3D&quot;SIMPLE&quot;&gt;<br>&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp; &lt;property name=3D&quot;JDBC.Driver&quot; value=3D&quot;CO=
M.ibm.db2.jdbc.app.DB2Driver&quot;/&gt;<br>&nbsp;&nbsp; &lt;property name=
=3D&quot;
JDBC.ConnectionURL&quot; value=3D&quot;jdbc:db2:sbb&quot;/&gt;<br>&nbsp;&nb=
sp; &lt;property name=3D&quot;JDBC.Username&quot; value=3D&quot;db2admin&qu=
ot;/&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name=3D&quot;JDBC.P=
assword&quot; value=3D&quot;zaq12wsx&quot;/&gt;
<br>&nbsp;&nbsp;&nbsp; &lt;/dataSource&gt;</div>
<div>&nbsp;</div>
<div>JDBC-JNDI</div>
<div>&nbsp;&lt;transactionManager type=3D&quot;JDBC&quot; &gt;<br>&nbsp;&nb=
sp;&nbsp; &lt;dataSource type=3D&quot;JNDI&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; &lt;property name=3D&quot;DataSource&quot; value=3D&quot;jdbc/s=
bb&quot;/&gt;<br>&nbsp;&nbsp;&nbsp; &lt;/dataSource&gt;<br>&nbsp; &lt;/tran=
sactionManager&gt;
</div>
<div>&nbsp;</div>
<div>Look forward to receiving your reply ASAP.</div>
<div>&nbsp;</div>
<div>THanks so much for your warm-hearted help.</div>
<div>&nbsp;</div>
<div>Thanks and Best Regards</div>
<div>Steven</div></div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>

------=_Part_33662_14537776.1138185012913--