Return-Path: 
 <user-java-return-7326-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 20077 invoked from network); 14 Jun 2006 07:53:35 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 14 Jun 2006 07:53:35 -0000
Received: (qmail 34417 invoked by uid 500); 14 Jun 2006 07:53:33 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 34240 invoked by uid 500); 14 Jun 2006 07:53:32 -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 34229 invoked by uid 99); 14 Jun 2006 07:53:32 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jun 2006 00:53:32 -0700
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=DNS_FROM_RFC_ABUSE
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
Received: from [217.146.177.62] (HELO web26515.mail.ukl.yahoo.com)
 (217.146.177.62)
    by apache.org (qpsmtpd/0.29) with SMTP; Wed, 14 Jun 2006 00:53:31 -0700
Received: (qmail 4983 invoked by uid 60001); 14 Jun 2006 07:53:09 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.it;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type;
  b=QS+OF0aULe6TizcBi+S124I8U3bdckeO6vQENCJ7OKb8AUqlH8gtfEN1Xo5rsvUAickq01uNQ/aJXnJLDUkbhZGGRof+mQsIPoqVKQvxPKl+NqOQQg9JVWjWfspKAyg7RIdMaWIpzRjlfzU65CggSz96sd+/4/nbwIfUYjWY1xw=
  ;
Message-ID: <20060614075309.4981.qmail@web26515.mail.ukl.yahoo.com>
Received: from [217.59.38.133] by web26515.mail.ukl.yahoo.com via HTTP;
 Wed, 14 Jun 2006 09:53:09 CEST
Date: Wed, 14 Jun 2006 09:53:09 +0200 (CEST)
From: gianluca bertulu <gbertulu@yahoo.it>
Subject: Curious problem using iBatis 2.0 with MySql 5.0.19
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi all,
I'm using iBatis 2.0 with MySql 5.0.19 (with driver
mysql-connector-java-3.1.12). 
I have this curious problem: when I perform a delete
(or update) and, after, I consecutively perform a
select (for example n times), for one of these times
(casually) the result is the old set of records that I
had before!
For example: I perform a select and the result is 3
records, I delete one of this: if I perform the same
select for n times, for one of these times the result
is 3 records and for the others times the result is
correctly 2 records !!
I don't use any cache model. I use this configuration
in other projects with Sybase and Sql Server without
any problems.
Here it is my code:
SqlMapConfig.xml:
<sqlMapConfig>
    <settings cacheModelsEnabled="false"
enhancementEnabled="false"
        lazyLoadingEnabled="true" maxRequests="32"
maxSessions="10"
        maxTransactions="5"
useStatementNamespaces="false" />
    <!-- Connect to Tomcat datasource -->
    <transactionManager type="JDBC">
      <dataSource type="JNDI">
  	<property name="DataSource"
value="java:comp/env/MYSQL_server"/>
      </dataSource>
    </transactionManager>

</sqlMapConfig>

Implementation of Dao:
public class AllarmeSqlMapDao extends BaseSqlMapDao
implements AllarmeDao {
  public AllarmeSqlMapDao(DaoManager daoManager) {
    super(daoManager);
  }

  public List getAllarmiAttivi (){
    return queryForList("getAllarmiAttivi", null);
  }
}

Method of Struts action:
 public List getAllarmiAttivi(Allarme allarme,
HttpServletRequest request,
                               HttpServletResponse
response) {
    try {
      daoManager.startTransaction();
..........

      HashMap map = new HashMap();
      List  result = allarmeDao.getAllarmiAttivi();

      daoManager.commitTransaction();
    }
    catch (Exception e) {
      
    }

    return result;
  }

Thanks in advance, 
Gianluca Bertulu

Chiacchiera con i tuoi amici in tempo reale! 
 http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com