Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 39654 invoked from network); 17 Jul 2008 13:12:35 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Jul 2008 13:12:35 -0000 Received: (qmail 49111 invoked by uid 500); 17 Jul 2008 13:12:31 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 48908 invoked by uid 500); 17 Jul 2008 13:12:30 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 48897 invoked by uid 99); 17 Jul 2008 13:12:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Jul 2008 06:12:30 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of degaetano@pitagora.it designates 151.9.129.69 as permitted sender) Received: from [151.9.129.69] (HELO allserv.pitagora.it) (151.9.129.69) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Jul 2008 13:11:32 +0000 Received: from smtptointernet.pitagora.it (mercurius.pitagora.it [193.227.64.120]) by allserv.pitagora.it (8.12.11.20060308/8.12.11) with ESMTP id m6HDAmBX013283 for ; Thu, 17 Jul 2008 15:10:49 +0200 Received: from mercurius.pitagora.it ([193.227.64.120]) by mercurius.pitagora.it ([193.227.64.120]) with mapi; Thu, 17 Jul 2008 15:10:48 +0200 From: De Gaetano Giuseppe To: "user-java@ibatis.apache.org" Date: Thu, 17 Jul 2008 15:10:46 +0200 Subject: R: chache problem Thread-Topic: chache problem Thread-Index: AcjoDdZyS2HAHzadTPG9/IyZBpiWSQAAGkbA Message-ID: References: In-Reply-To: Accept-Language: it-IT, en-US Content-Language: it-IT X-MS-Has-Attach: yes X-MS-TNEF-Correlator: acceptlanguage: it-IT, en-US Content-Type: multipart/mixed; boundary="_004_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_" MIME-Version: 1.0 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on allserv.pitagora.it X-Virus-Scanned: ClamAV 0.92/7734/Thu Jul 17 13:02:31 2008 on allserv.pitagora.it X-Virus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-4.1 required=5.5 tests=ALL_TRUSTED,AWL,BAYES_00, HTML_MESSAGE autolearn=ham version=3.2.4 --_004_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_ Content-Type: multipart/alternative; boundary="_000_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_" --_000_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Sorry for chache in the subject :) I attach also the java code I use as parameter class ________________________________ Da: De Gaetano Giuseppe [mailto:degaetano@pitagora.it] Inviato: gioved=EC 17 luglio 2008 15.06 A: user-java@ibatis.apache.org Oggetto: chache problem Hi guys I have a problem using the cache. This is my configuration: sql-map-config.xml TMP_TEST_CACHE_IBATIS_SqlMap.xml This is the db configuration CREATE TABLE TMP_TEST_CACHE_IBATIS ( AAA VARCHAR2(1) , BBB VARCHAR2(2) ); insert into TMP_TEST_CACHE_IBATIS (AAA, BBB ) values ('A', null); insert into TMP_TEST_CACHE_IBATIS (AAA, BBB ) values (null, 'B'); insert into TMP_TEST_CACHE_IBATIS (AAA, BBB ) values (null,null); If I execute the following code TmpTestCacheIbatis searchParam =3D new TmpTestCacheIbatis(); searchParam.setAaa("A"); List list =3D (List)sqlMap.queryFor= List("TMP_TEST_CACHE_IBATIS.selectByAllPropertiesConCache", searchParam); System.out.println("params=3D"+searchParam+" --> result=3D"+list); TmpTestCacheIbatis searchParam2 =3D new TmpTestCacheIbatis(); searchParam2.setBbb("A"); List list2 =3D (List)sqlMap.queryFo= rList("TMP_TEST_CACHE_IBATIS.selectByAllPropertiesConCache", searchParam2); System.out.println("params=3D"+searchParam2+" --> result=3D"+list2); I get a wrong result as you can see from the following log: MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,340;{conn-100000} Connection MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,418;{conn-100000} Preparing Statement: select AAA, BBB from TMP_TE= ST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (BBB= =3D ? or BBB is null) MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,652;{pstm-100001} Executing Statement: select AAA, BBB from TMP_TE= ST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (BBB= =3D ? or BBB is null) MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,652;{pstm-100001} Parameters: [A, null] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,652;{pstm-100001} Types: [java.lang.String, null] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,684;{rset-100002} ResultSet MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,777;{rset-100002} Header: [AAA, BBB] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,777;{rset-100002} Result: [A, null] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,777;{rset-100002} Result: [null, null] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,777;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored obje= ct '[[aaa=3DA,bbb=3Dnull], [aaa=3Dnull,bbb=3Dnull]]' params=3D[aaa=3DA,bbb=3Dnull] --> result=3D[[aaa=3DA,bbb=3Dnull], [aaa=3Dnu= ll,bbb=3Dnull]] MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15:03= :26,777;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': retrieved o= bject '[[aaa=3DA,bbb=3Dnull], [aaa=3Dnull,bbb=3Dnull]]' params=3D[aaa=3Dnull,bbb=3DA] --> result=3D[[aaa=3DA,bbb=3Dnull], [aaa=3Dnu= ll,bbb=3Dnull]] ERRORE If I execute the following code, I don't get the problem anymore as you can= see: TmpTestCacheIbatis searchParam1 =3D new TmpTestCacheIbatis(); searchParam1.setBbb("B"); List list1 =3D (List)sqlMap.queryFo= rList("TMP_TEST_CACHE_IBATIS.selectByAllPropertiesConCache", searchParam1); System.out.println("params=3D"+searchParam1+" --> result=3D"+list1); TmpTestCacheIbatis searchParam2 =3D new TmpTestCacheIbatis(); searchParam2.setBbb("A"); List list2 =3D (List)sqlMap.queryFo= rList("TMP_TEST_CACHE_IBATIS.selectByAllPropertiesConCache", searchParam2); System.out.println("params=3D"+searchParam2+" --> result=3D"+list2); MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:42,934;{conn-100000} Connection MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:42,980;{conn-100000} Preparing Statement: select AAA, BBB from TMP= _TEST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (= BBB =3D ? or BBB is null) MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,230;{pstm-100001} Executing Statement: select AAA, BBB from TMP= _TEST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (= BBB =3D ? or BBB is null) MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,230;{pstm-100001} Parameters: [null, B] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,230;{pstm-100001} Types: [null, java.lang.String] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,246;{rset-100002} ResultSet MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,340;{rset-100002} Header: [AAA, BBB] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,340;{rset-100002} Result: [null, B] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{rset-100002} Result: [null, null] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored o= bject '[[aaa=3Dnull,bbb=3DB], [aaa=3Dnull,bbb=3Dnull]]' params=3D[aaa=3Dnull,bbb=3DB] --> result=3D[[aaa=3Dnull,bbb=3DB], [aaa=3Dnu= ll,bbb=3Dnull]] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': cache mi= ss MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{conn-100003} Connection MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{conn-100003} Preparing Statement: select AAA, BBB from TMP= _TEST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (= BBB =3D ? or BBB is null) MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{pstm-100004} Executing Statement: select AAA, BBB from TMP= _TEST_CACHE_IBATIS where (AAA =3D ? or AAA is null) and (= BBB =3D ? or BBB is null) MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{pstm-100004} Parameters: [null, A] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{pstm-100004} Types: [null, java.lang.String] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{rset-100005} ResultSet MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{rset-100005} Header: [AAA, BBB] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;{rset-100005} Result: [null, null] MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;17/07/2008 15= :00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored o= bject '[[aaa=3Dnull,bbb=3Dnull]]' params=3D[aaa=3Dnull,bbb=3DA] --> result=3D[[aaa=3Dnull,bbb=3Dnull]] Is there anyone that could help me. Thanks in advance. Giuseppe Ps. I am using ibatis 2.3.3, but I also tried 2.3.2 and 2.2.0 --_000_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Sorry for chache in= the subject J=

I attach also the j= ava code I use as parameter class

 

Da: De Gaetano Giuseppe [mailto:degaetano@pitagora.it]
Inviato: gioved=EC 17 luglio= 2008 15.06
A: user-java@ibatis.apache.o= rg
Oggetto: chache problem

 

Hi guys I have a problem using the cache.

 

This is my configuration:

 

sql-map-config.xml

 

&nbs= p;

  settings useStatementNamespaces=3D"true"/>

&nbs= p;

  transactionManager <= /font>type=3D"JDBC">

    <dataSource type=3D"SIMPLE">

      <property value=3D"${driver}" name=3D"JDBC.Driver"/>

      <property value=3D"${url}" <= font size=3D2 color=3D"#7f007f" face=3D"Courier New">name=3D"JDBC.ConnectionURL"/>

      <property value=3D"${username}" name=3D"JDBC.Username"/>

      <property value=3D"${password}" name=3D"JDBC.Password"/>

      </dataSour= ce>

  </transactionManager>

     

<= sqlMap resource=3D"TMP_TEST_CACHE_IBATIS_SqlMap= .xml" />

 

 

TMP_TEST_CACHE_IBATIS_SqlMap.xml

 

<sqlMap namespac= e=3D"TMP_TEST_CACHE_IBATIS" = >

  cacheModel id=3D"TmpTestCacheIbatis_cache&quo= t; type=3D"MEMORY" <= font size=3D2 color=3D"#7f007f" face=3D"Courier New">readOnly=3D"true" serialize=3D"false" >

    <flushInterval hours=3D"1" />

    <property name=3D"size" value=3D"100" />

  cacheModel>

  resultMap id=3D"TmpTestCacheIbatisResult&quo= t; class=3D"it.pitagora.ibatis.TmpTestCa= cheIbatis" >=

    <result column=3D"AAA" property=3D"aaa" jdbcType=3D"VARCHAR" = />

    <result column=3D"BBB" property=3D"bbb" jdbcType=3D"VARCHAR" = />

  resultMap>

 

   <select id=3D"selectByAllPropertiesConCach= e" resultMa= p=3D"TmpTestCacheIbatisResult&quo= t; parameterClass=3D"it.pitagora.ibatis.TmpTestCa= cheIbatis" cacheMod= el=3D"TmpTestCacheIbatis_cache&quo= t;>

    select AAA, BBB from TMP_TEST_CACHE_IBATIS<= /span>

    where

    (AAA =3D #aaa:VARCHAR# or AAA is null)

    and

    (BBB =3D #bbb:VARCHAR# or BBB is null)

  select>

  

 

This is the db configuration

      CREATE TABLE TMP_TEST_CACHE_IBATIS

      (

        AAA            VARCHAR2(1) ,

        BBB            VARCHAR2(2)

      );

     

      insert into TMP_TEST_CACHE_IB= ATIS (AAA, BBB ) values ('A', null);

      insert into TMP_TEST_CACHE_IB= ATIS (AAA, BBB ) values (null, 'B');

      insert into TMP_TEST_CACHE_IB= ATIS (AAA, BBB ) values (null,null);

&nbs= p;

 

If I execute the following code=

 

TmpTestCacheIbatis searchParam =3D new= TmpTestCacheIbatis();=

searchParam.setAaa("A");          =       

List<TmpTestCacheIbatis> list =3D (List<TmpTestCacheIbatis>)sqlMap.queryForList("TMP_TEST_CACHE_IBATIS.select= ByAllPropertiesConCache", searchParam);

System.out.println("params=3D"+searchParam+" --> result=3D"+list);

          &n= bsp;      

     

TmpTestCacheIbatis searchParam2 =3D new= TmpTestCacheIbatis();=

searchParam2.setBbb("A");

List<TmpTestCacheIbatis> list2 =3D (List<TmpTestCacheIbatis>)sqlMap.queryForList("TMP_TEST_CACHE_IBATIS.select= ByAllPropertiesConCache", searchParam2);

System.out.println("params=3D"+searchParam2+" --> result=3D&quo= t;+list2);

 

I get a wrong result as you can see from the following log:

 

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,340;{conn-100000} Connection

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,418;{conn-100000} Preparing Statement:    &nbs= p; select AAA, BBB from TMP_TEST_CACHE_IBATIS     where      (AAA =3D ? or AAA is null)     and      (BBB =3D ? = or BBB is null)  

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,652;{pstm-100001} Executing Statement:    &nbs= p; select AAA, BBB from TMP_TEST_CACHE_IBATIS     where      (AAA =3D ? or AAA is null)     and      (BBB =3D ? = or BBB is null)  

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,652;{pstm-100001} Parameters: [A, null]

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,652;{pstm-100001} Types: [java.lang.String, null]

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,684;{rset-100002} ResultSet

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,777;{rset-100002} Header: [AAA, BBB]

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,777;{rset-100002} Result: [A, null]

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,777;{rset-100002} Result: [null, null]

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,777;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored object '[[aaa=3DA,bbb=3Dnull], [aaa=3Dnull,bbb=3Dnull]]'

params=3D[aaa=3DA,bbb=3Dnull] --> result=3D[[aaa=3DA,bbb=3D= null], [aaa=3Dnull,bbb=3Dnull]]<= span lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier New"'>

MSG;537351365;5962608;null;JakartaCommonsLoggingImpl.debug;17/= 07/2008 15:03:26,777;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': retrie= ved object '[[aaa=3DA,bbb=3Dnull], [aaa=3Dnull,bbb=3Dnull]]'

params=3D[aaa=3Dnull,bbb=3DA] --> result=3D[[aaa=3DA,b= bb=3Dnull], [aaa=3Dnull,bbb=3Dnull]] ERRORE

 

If I execute the following code, I don’t ge= t the problem anymore as you can see:

TmpTestCacheIbatis searchParam1 =3D new= TmpTestCacheIbatis();=

searchParam1.setBbb("B");

List<TmpTestCacheIbatis> list1 =3D (List<TmpTestCacheIbatis>)sqlMap.queryForList("TMP_TEST_CACHE_IBATIS.select= ByAllPropertiesConCache", searchParam1);

System.out.println("params=3D"+searchParam1+" --> result=3D"+list1);

     

TmpTestCacheIbatis searchParam2 =3D new= TmpTestCacheIbatis();=

searchParam2.setBbb("A");

List<TmpTestCacheIbatis> list2 =3D (List<TmpTestCacheIbatis>)sqlMap.queryForList("TMP_TEST_CACHE_IBATIS.select= ByAllPropertiesConCache", searchParam2);

System.out.println("params=3D"+searchParam2+" --> result=3D&quo= t;+list2);

 

 

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:42,934;{conn-100000} Connection

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:42,980;{conn-100000} Preparing Statement:      select AAA, BBB from TMP_TEST_CACHE_IBATIS     where      (AAA =3D ? or AAA is null)     and      (BBB =3D ? = or BBB is null)  

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,230;{pstm-100001} Executing Statement:    &nbs= p; select AAA, BBB from TMP_TEST_CACHE_IBATIS     where      (AAA =3D ? or AAA is null)     and      (BBB =3D ? = or BBB is null)  

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,230;{pstm-100001} Parameters: [null, B]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,230;{pstm-100001} Types: [null, java.lang.String]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,246;{rset-100002} ResultSet

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,340;{rset-100002} Header: [AAA, BBB]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,340;{rset-100002} Result: [null, B]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{rset-100002} Result: [null, null]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored object '[[aaa=3Dnull,bbb=3DB], [aaa=3Dnull,bbb=3Dnull]]'

params=3D[aaa=3Dnull,bbb=3DB] --> result=3D[[aaa=3Dnull,bbb= =3DB], [aaa=3Dnull,bbb=3Dnull]]<= span lang=3DEN-GB style=3D'font-size:10.0pt;font-family:"Courier New"'>

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': cache = miss

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{conn-100003} Connection

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{conn-100003} Preparing Statement:    &nbs= p; select AAA, BBB from TMP_TEST_CACHE_IBATIS     where&nb= sp;     (AAA =3D ? or AAA is null)     and      (BBB =3D ? or BBB is null)  

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{pstm-100004} Executing Statement:    &nbs= p; select AAA, BBB from TMP_TEST_CACHE_IBATIS     where      (AAA =3D ? or AAA is null)     and      (BBB =3D ? = or BBB is null)  

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{pstm-100004} Parameters: [null, A]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{pstm-100004} Types: [null, java.lang.String]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{rset-100005} ResultSet

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{rset-100005} Header: [AAA, BBB]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;{rset-100005} Result: [null, null]

MSG;922621065;1879483962;null;JakartaCommonsLoggingImpl.debug;= 17/07/2008 15:00:43,355;Cache 'TMP_TEST_CACHE_IBATIS.TmpTestCacheIbatis_cache': stored object '[[aaa=3Dnull,bbb=3Dnull]]'

params=3D[aaa=3Dnull,bbb=3DA] --> result=3D[[aaa=3Dnull,bbb=3Dnull]]

 

Is there anyone that could help me.

 

Thanks in advance.

Giuseppe

 

Ps. I am using ibatis 2.3.3, but I also tried 2.3.2 and 2.2.0

 

--_000_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_-- --_004_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_ Content-Type: application/octet-stream; name="TmpTestCacheIbatis.java" Content-Description: TmpTestCacheIbatis.java Content-Disposition: attachment; filename="TmpTestCacheIbatis.java"; size=568; creation-date="Thu, 17 Jul 2008 11:42:40 GMT"; modification-date="Thu, 17 Jul 2008 12:06:55 GMT" Content-Transfer-Encoding: base64 cGFja2FnZSBpdC5waXRhZ29yYS5pYmF0aXM7DQoNCmltcG9ydCBqYXZhLmlvLlNlcmlhbGl6YWJs ZTsNCg0KcHVibGljIGNsYXNzIFRtcFRlc3RDYWNoZUliYXRpcyBpbXBsZW1lbnRzIFNlcmlhbGl6 YWJsZXsNCg0KCS8qKg0KCSAqIA0KCSAqLw0KCXByaXZhdGUgc3RhdGljIGZpbmFsIGxvbmcgc2Vy aWFsVmVyc2lvblVJRCA9IDQ1MDA5ODcxNjYwMjkyNzExMzFMOw0KDQoJcHJpdmF0ZSBTdHJpbmcg YWFhOw0KCQ0KCXByaXZhdGUgU3RyaW5nIGJiYjsNCg0KCXB1YmxpYyBTdHJpbmcgZ2V0QWFhKCkg ew0KCQlyZXR1cm4gYWFhOw0KCX0NCg0KCXB1YmxpYyB2b2lkIHNldEFhYShTdHJpbmcgYWFhKSB7 DQoJCXRoaXMuYWFhID0gYWFhOw0KCX0NCg0KCXB1YmxpYyBTdHJpbmcgZ2V0QmJiKCkgew0KCQly ZXR1cm4gYmJiOw0KCX0NCg0KCXB1YmxpYyB2b2lkIHNldEJiYihTdHJpbmcgYmJiKSB7DQoJCXRo aXMuYmJiID0gYmJiOw0KCX0NCgkNCgkNCglAT3ZlcnJpZGUNCglwdWJsaWMgU3RyaW5nIHRvU3Ry aW5nKCkgew0KCQlyZXR1cm4gIlthYWE9IithYWErIixiYmI9IitiYmIrIl0iOw0KCX0NCn0NCg== --_004_B0070D3403CFD442A608A5F80236E0F455274A5D89mercuriuspita_--