From rachelpatel@example.org Wed Dec 1 00:00:10 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 29573 invoked by uid 99); 1 Dec 2004 00:00:10 -0000 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=FORGED_RCVD_HELO,HTML_20_30,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.plumcreek.com (HELO cfo-msg.plumcreek.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 30 Nov 2004 16:00:10 -0800 Received: from plumcreek-MTA by cfo-msg.plumcreek.net with Novell_GroupWise; Tue, 30 Nov 2004 17:00:08 -0700 Message-Id: <rachelpatel@example.org> X-Mailer: Novell GroupWise Internet Agent 6.5.2 Date: Tue, 30 Nov 2004 16:59:39 -0700 From: "Brandon Goodin" <rachelpatel@example.org> To: <rachelpatel@example.org>,<rachelpatel@example.org>, <rachelpatel@example.org> Subject: Re: Caching and transactions Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartF6D6177B.2__=" X-Virus-Checked: Checked This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__PartF6D6177B.2__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit There is a small potential for that. IBatis allows for you to configure your cache to flush when a statement is called. So, in a case where someone was performing an update that flushed a cache and then called a select that repopulated that same cache in the same transaction which subsequently failed, then that there would be invalid cached objects. I suppose we could fix that by retaining a session scoped cache for that particular transaction/thread and committing it to the global cache upon completion of the transaction. Brandon >>> rachelpatel@example.org 11/30/2004 4:36:24 PM >>> I was wondering if caches get cleared once a transaction has failed or has been rolled back? If not, couldn't they contain invalid entries? As caches seem to be global, what about isolation of different concurrent transactions from each other? Oliver --=__PartF6D6177B.2__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"= > <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV>There is a small potential for that. IBatis allows for you to = configure your cache to flush when a statement is called. So, in a case = where someone was performing an update that flushed a cache and then = called a select that repopulated that same cache in the same transaction = which subsequently failed, then&nbsp;that there would be invalid cached = objects. I suppose we could fix that by retaining a session scoped cache = for that particular transaction/thread and committing it to the global = cache upon completion of the transaction.</DIV> <DIV>&nbsp;</DIV> <DIV>Brandon</DIV> <DIV><BR>&gt;&gt;&gt; rachelpatel@example.org 11/30/2004 4:36:24 PM = &gt;&gt;&gt;<BR></DIV> <DIV style=3D"COLOR: #000000">I was wondering if caches get cleared once a = transaction has failed or<BR>has been rolled back? If not, couldn't they = contain invalid entries?<BR>As caches seem to be global, what about = isolation of different<BR>concurrent transactions from each other?<BR><BR>O= liver<BR></DIV></BODY></HTML> --=__PartF6D6177B.2__=-- From rachelpatel@example.org Wed Dec 1 07:07:43 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 61717 invoked by uid 99); 1 Dec 2004 07:07:43 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from jive.SoftHome.net (HELO jive.SoftHome.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Tue, 30 Nov 2004 23:07:43 -0800 Received: (qmail 7735 invoked by uid 417); 1 Dec 2004 07:07:41 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (83.161.120.155) by shunt-smtp-out-0 with SMTP; 1 Dec 2004 07:07:41 -0000 Received: from Toffer ([83.161.120.155]) (AUTH: LOGIN rachelpatel@example.org) by softhome.net with esmtp; Wed, 01 Dec 2004 00:07:39 -0700 Message-ID: <000f01c4d774$81f790c0$04a8a8c0@Toffer> From: "Oliver Chua" <rachelpatel@example.org> To: rachelpatel@example.org Subject: Javadoc for common Date: Wed, 1 Dec 2004 15:08:03 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Checked: Checked Hi... The javadoc included in the installer has a javadoc, but it does not include classes in the common package. Anybody know where I can get it? Thanks in advance. From rachelpatel@example.org Wed Dec 1 16:44:00 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 53166 invoked by uid 99); 1 Dec 2004 16:44:00 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=FORGED_RCVD_HELO,HTML_30_40,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.plumcreek.com (HELO cfo-msg.plumcreek.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 08:43:59 -0800 Received: from plumcreek-MTA by cfo-msg.plumcreek.net with Novell_GroupWise; Wed, 01 Dec 2004 09:43:55 -0700 Message-Id: <rachelpatel@example.org> X-Mailer: Novell GroupWise Internet Agent 6.5.2 Date: Wed, 01 Dec 2004 09:43:43 -0700 From: "Brandon Goodin" <rachelpatel@example.org> To: <rachelpatel@example.org>,<rachelpatel@example.org> Subject: Re: Javadoc for common Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartDFFF3EAF.0__=" X-Virus-Checked: Checked This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=__PartDFFF3EAF.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I mistakenly left it out in the last revision of the build.xml script. I just fixed it in CVS. So, If you want to checkout Ibatis and run the "src.javadoc" ant task you will get all of the javadocs that are available. There is a dev and user version. Both javadoc sets produced contain the common package. Brandon >>> "Oliver Chua" <rachelpatel@example.org> 12/1/2004 12:08:03 AM >>> Hi... The javadoc included in the installer has a javadoc, but it does not include classes in the common package. Anybody know where I can get it? Thanks in advance. --=__PartDFFF3EAF.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"= > <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV>I mistakenly left it out in the last revision of the build.xml = script. I just fixed it in CVS. So, If you want to checkout Ibatis and run = the "src.javadoc" ant&nbsp;task you will get all of the javadocs that are = available. There is a dev and user version. Both javadoc sets produced = contain the common package.</DIV> <DIV>&nbsp;</DIV> <DIV>Brandon<BR><BR>&gt;&gt;&gt; "Oliver Chua" &lt;rachelpatel@example.org&= gt; 12/1/2004 12:08:03 AM &gt;&gt;&gt;<BR></DIV> <DIV style=3D"COLOR: #000000">Hi...<BR><BR>The javadoc included in the = installer has a javadoc, but it does not include<BR>classes in the common = package.<BR><BR>Anybody know where I can get it?<BR><BR>Thanks in = advance.<BR><BR></DIV></BODY></HTML> --=__PartDFFF3EAF.0__=-- From rachelpatel@example.org Wed Dec 1 20:00:47 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 44023 invoked by uid 99); 1 Dec 2004 20:00:47 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 12:00:47 -0800 Received: by wproxy.gmail.com with SMTP id 71so1635042wra for <rachelpatel@example.org>; Wed, 01 Dec 2004 12:00:43 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=U1x9kRDHshZWBg0RES8B7QzjPQkK0p6wyGJkAC5gAdy2GpQUKGGjIVtXUhqzBIWzyYsfCXs3htuCzmeppYWOt0JDz+CGvwAWu7QA7V+u5Ks2QnRW5RPDH0IkZCazCMlqJrv8QjfmRexbv+tYDp/DI1ivpZHD6RnSSRv5YZcb8IQ= Received: by 83.161.120.155 with SMTP id 8mr858659wrx; Wed, 01 Dec 2004 12:00:43 -0800 (PST) Received: by 83.161.120.155 with HTTP; Wed, 1 Dec 2004 12:00:43 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Wed, 1 Dec 2004 12:00:43 -0800 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: rachelpatel@example.org Subject: RE: Problem in executing a batch Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked > I'm currently using IBatis version 2.0.3. I'm not able to work upon with Batch. I'm > doing the following : > sqlMap.startBatch(); Are you starting a the transaction too? So... startTransaction() startBatch() insert... update... executeBatch() commitTransaction() endTransaction From rachelpatel@example.org Wed Dec 1 21:55:36 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 12674 invoked by uid 99); 1 Dec 2004 21:55:36 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from brmea-mail-4.Sun.COM (HELO brmea-mail-4.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 13:55:34 -0800 Received: from esunmail ([83.161.120.155]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id iB1LtWun006431 for <rachelpatel@example.org>; Wed, 1 Dec 2004 14:55:32 -0700 (MST) Received: from xpa-fe2 (esunmail [83.161.120.155]) by edgemail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTP id <rachelpatel@example.org> for rachelpatel@example.org; Wed, 01 Dec 2004 14:55:32 -0700 (MST) Received: from [83.161.120.155] by mail.sun.net (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTPSA id <rachelpatel@example.org> for rachelpatel@example.org; Wed, 01 Dec 2004 14:55:32 -0700 (MST) Date: Wed, 01 Dec 2004 14:55:31 -0700 From: Nathan Maves <rachelpatel@example.org> Subject: resultset map aliases To: rachelpatel@example.org Message-id: <rachelpatel@example.org> MIME-version: 1.0 X-Mailer: Apple Mail (2.619) Content-type: text/plain; charset=US-ASCII; format=flowed Content-transfer-encoding: 7BIT X-Virus-Checked: Checked Any thought to adding java.util.HashMap to the default type aliases since it is a supported type. Nathan From rachelpatel@example.org Wed Dec 1 22:07:13 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 30765 invoked by uid 99); 1 Dec 2004 22:07:13 -0000 X-ASF-Spam-Status: No, hits=1.8 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from brmea-mail-3.Sun.COM (HELO brmea-mail-3.sun.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 14:07:11 -0800 Received: from esunmail ([83.161.120.155]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id iB1M7AVu002290 for <rachelpatel@example.org>; Wed, 1 Dec 2004 15:07:10 -0700 (MST) Received: from xpa-fe2 (esunmail [83.161.120.155]) by edgemail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTP id <rachelpatel@example.org> for rachelpatel@example.org; Wed, 01 Dec 2004 15:07:09 -0700 (MST) Received: from [83.161.120.155] by mail.sun.net (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004)) with ESMTPSA id <rachelpatel@example.org> for rachelpatel@example.org; Wed, 01 Dec 2004 15:07:09 -0700 (MST) Date: Wed, 01 Dec 2004 15:07:08 -0700 From: Nathan Maves <rachelpatel@example.org> Subject: Re: resultset map aliases In-reply-to: <rachelpatel@example.org> To: rachelpatel@example.org Message-id: <rachelpatel@example.org> MIME-version: 1.0 X-Mailer: Apple Mail (2.619) Content-type: text/plain; charset=US-ASCII; format=flowed Content-transfer-encoding: 7BIT References: <rachelpatel@example.org> X-Virus-Checked: Checked well I found that there is a alias to java.util.Map on page 21 but why is it not listed on page 29 in the table of supported types for parameter maps? I still would like to know about a type alias for hashmap. Nathan On Dec 1, 2004, at 2:55 PM, Nathan Maves wrote: > Any thought to adding java.util.HashMap to the default type aliases > since it is a supported type. > > Nathan > From rachelpatel@example.org Thu Dec 2 09:21:27 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 28427 invoked by uid 99); 2 Dec 2004 09:21:27 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail01.loudeye.com (HELO EX01.int.loudeye.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 02 Dec 2004 01:21:26 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4D850.4B101C71" Subject: caching broken in 2.0.8? Date: Thu, 2 Dec 2004 01:21:23 -0800 Message-ID: <rachelpatel@example.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: caching broken in 2.0.8? Thread-Index: AcTYUErIT92S0YYOQHWd3CFeda+Mpg== From: "John Didion" <rachelpatel@example.org> To: <rachelpatel@example.org> X-Virus-Checked: Checked This is a multi-part message in MIME format. ------_=_NextPart_001_01C4D850.4B101C71 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In 2.0.4 (the last version I was able to use with any success), I could do: =20 -- SQL MAPS -- =20 <cacheModel id=3D"cache" type=3D"LRU"> <flushInterval minutes=3D"30" /> <property name=3D"size" value=3D"1000" /> </cacheModel> =20 ...some insert statement... =20 <select id=3D"select" parameterClass=3D"MyClass" = resultClass=3D"AnotherClass" cacheModel=3D"cache"> ...some select statement... </select> =20 -- JAVA -- =20 MyClass obj =3D new MyClass(); ...set properties... client.update("insert", obj); assertNotNull(client.queryForObject("foo", obj)); =20 This no longer works in 2.0.8. However, when I disable caching (by either removing the cacheModel attribute from the select element or setting cacheModelsEnabled to false in the config file), it works fine. Did something change or is this a bug? ------_=_NextPart_001_01C4D850.4B101C71 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>In 2.0.4 (the last version I was able to use with any success), I could do:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>-- SQL MAPS --<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;cacheModel id=3D&quot;cache&quot; = type=3D&quot;LRU&quot;&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&nbsp; &lt;flushInterval minutes=3D&quot;30&quot; = /&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&nbsp; &lt;property name=3D&quot;size&quot; = value=3D&quot;1000&quot; /&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;/cacheModel&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&#8230;some insert = statement&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;select id=3D&quot;select&quot; = parameterClass=3D&quot;MyClass&quot; resultClass=3D&quot;AnotherClass&quot; = cacheModel=3D&quot;cache&quot;&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&#8230;some select = statement&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;/select&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>-- JAVA --<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>MyClass obj =3D new MyClass();<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>&#8230;set properties&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>client.update(&#8220;insert&#8221;, = obj);<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>assertNotNull(client.queryForObject(&#8220;foo&#8221;, = obj));<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>This no longer works in 2.0.8. However, when I disable caching = (by either removing the cacheModel attribute from the select element or = setting cacheModelsEnabled to false in the config file), it works fine. Did something change or is = this a bug?<o:p></o:p></span></font></p> </div> </body> </html> ------_=_NextPart_001_01C4D850.4B101C71-- From rachelpatel@example.org Thu Dec 2 09:34:56 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 58981 invoked by uid 99); 2 Dec 2004 09:34:56 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail01.loudeye.com (HELO EX01.int.loudeye.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 02 Dec 2004 01:34:55 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4D852.2D6C7291" Subject: RE: caching broken in 2.0.8? Date: Thu, 2 Dec 2004 01:34:52 -0800 Message-ID: <rachelpatel@example.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: caching broken in 2.0.8? Thread-Index: AcTYUErIT92S0YYOQHWd3CFeda+MpgAAcmqA From: "John Didion" <rachelpatel@example.org> To: "John Didion" <rachelpatel@example.org>, <rachelpatel@example.org> X-Virus-Checked: Checked This is a multi-part message in MIME format. ------_=_NextPart_001_01C4D852.2D6C7291 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sorry...I meant=20 =20 assertNotNull(client.queryForObject("select", obj)); =20 not=20 =20 assertNotNull(client.queryForObject("foo", obj)); =20 ________________________________ From: John Didion [mailto:rachelpatel@example.org]=20 Sent: Thursday, December 02, 2004 1:21 AM To: rachelpatel@example.org Subject: caching broken in 2.0.8? =20 In 2.0.4 (the last version I was able to use with any success), I could do: =20 -- SQL MAPS -- =20 <cacheModel id=3D"cache" type=3D"LRU"> <flushInterval minutes=3D"30" /> <property name=3D"size" value=3D"1000" /> </cacheModel> =20 ...some insert statement... =20 <select id=3D"select" parameterClass=3D"MyClass" = resultClass=3D"AnotherClass" cacheModel=3D"cache"> ...some select statement... </select> =20 -- JAVA -- =20 MyClass obj =3D new MyClass(); ...set properties... client.update("insert", obj); assertNotNull(client.queryForObject("foo", obj)); =20 This no longer works in 2.0.8. However, when I disable caching (by either removing the cacheModel attribute from the select element or setting cacheModelsEnabled to false in the config file), it works fine. Did something change or is this a bug? ------_=_NextPart_001_01C4D852.2D6C7291 Content-Type: text/html; charset="us-ascii" 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=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal; font-family:Arial; color:windowtext;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Sorry&#8230;I meant = <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>assertNotNull(client.queryForObject(&#8220;select&#8221;, = obj));<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>not <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>assertNotNull(client.queryForObject(&#8220;foo&#8221;, = obj));<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> John = Didion [mailto:rachelpatel@example.org] <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, December = 02, 2004 1:21 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> rachelpatel@example.org<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> caching broken = in 2.0.8?</span></font><o:p></o:p></p> </div> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>In 2.0.4 (the last version I was able to use with any success), I could do:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>-- SQL MAPS --<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;cacheModel id=3D&quot;cache&quot; = type=3D&quot;LRU&quot;&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&nbsp; &lt;flushInterval minutes=3D&quot;30&quot; = /&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&nbsp; &lt;property name=3D&quot;size&quot; value=3D&quot;1000&quot; /&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;/cacheModel&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&#8230;some insert = statement&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;select id=3D&quot;select&quot; parameterClass=3D&quot;MyClass&quot; = resultClass=3D&quot;AnotherClass&quot; cacheModel=3D&quot;cache&quot;&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&#8230;some select = statement&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>&lt;/select&gt;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>-- JAVA --<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>MyClass obj =3D new MyClass();<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>&#8230;set properties&#8230;<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>client.update(&#8220;insert&#8221;, = obj);<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>assertNotNull(client.queryForObject(&#8220;foo&#8221;, = obj));<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'><o:p>&nbsp;</o:p></span></font></p> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span = style=3D'font-size: 12.0pt'>This no longer works in 2.0.8. However, when I disable caching = (by either removing the cacheModel attribute from the select element or = setting cacheModelsEnabled to false in the config file), it works fine. Did = something change or is this a bug?<o:p></o:p></span></font></p> </div> </body> </html> ------_=_NextPart_001_01C4D852.2D6C7291-- From rachelpatel@example.org Thu Dec 2 21:12:19 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 15493 invoked by uid 99); 2 Dec 2004 21:12:19 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from webmail.pointserve.com (HELO ptscorp-exc01.pointserve.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 02 Dec 2004 13:12:18 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Problems upgrading from 1.2.x to 2.0.8 Date: Thu, 2 Dec 2004 15:12:14 -0600 Message-ID: <rachelpatel@example.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Problems upgrading from 1.2.x to 2.0.8 Thread-Index: AcTYs5jH5QrN+4z0Rq6Syz8sqAQGtw== From: "McCarrier, Alex" <rachelpatel@example.org> To: <rachelpatel@example.org> X-Virus-Checked: Checked I'm getting ClassCastExceptions on TransactionManager when trying to load our old ibatis config file using the new iBatis libraries. =20 Apparently what it is trying to do is an on the fly conversion from the old format to the new format (found by tracing through iBatis source code). However, we don't have anything transaction related in our config file other than a settings option to specify using global transactions. We let the EJB container handle the demarcation of our transactions. When iBatis does the conversion, it seems to default to using JTA transactions, tries to lookup the UserTransaction with JNDI name "" and then throws the ClassCastException. Any ideas on how to fix this without having to do a manual conversion of the file (although I will do that if that's the only way, but someone might want to add this to the upgrade guide). Here's the part of our config file that is causing problems: <?xml version=3D"1.0" encoding=3D"UTF-8"?> <!DOCTYPE sql-map-config PUBLIC "-//iBATIS.com//DTD SQL Map Config 1.0//EN" "http://www.ibatis.com/dtd/sql-map-config.dtd"> <sql-map-config> <settings useGlobalTransactions=3D"true" cacheModelsEnabled=3D"true" /> <!--settings useBeansMetaClasses=3D"true"/ Investigate, suppose to = be big performance improvement--> <datasource name=3D"snmDataSource" =09 factory-class=3D"com.ibatis.db.sqlmap.datasource.JndiDataSourceFactory" default=3D"true" > <property name=3D"DBFullJndiContext" value=3D"java:/dsname" /> </datasource> .. Rest of stuff here ... =20 </sql-map-config> From rachelpatel@example.org Thu Dec 2 21:23:31 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 40453 invoked by uid 99); 2 Dec 2004 21:23:31 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=HTML_30_40,HTML_MESSAGE,MIME_HTML_NO_CHARSET X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from dfwmail004.pbsg.com (HELO dfwmail004.pbsg.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 02 Dec 2004 13:23:29 -0800 Received: from ([83.161.120.155]) by dfwmail004.pbsg.com with ESMTP id KP-VYKV3.5833649; Thu, 02 Dec 2004 15:22:46 -0600 Received: from PLANEX05 ([83.161.120.155]) by planxr14.fritolay.pvt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id YDQ8ZSGK; Thu, 2 Dec 2004 15:22:43 -0600 Received: from planxr0b.fritolay.pvt ([83.161.120.155]) by PLANEX05 with InterScan Messaging Security Suite; Thu, 02 Dec 2004 15:22:39 -0600 Received: by PLANXR0B.fritolay.pvt with Internet Mail Service (5.5.2657.72) id <WH9F5Q7G>; Thu, 2 Dec 2004 15:22:41 -0600 Message-ID: <rachelpatel@example.org> From: "Garmilla, Santhosh {PBG}" <rachelpatel@example.org> To: rachelpatel@example.org Subject: Caching is it Querybased or paramater based or both ? Date: Thu, 2 Dec 2004 15:22:35 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4D8B4.EA7EEFCB" X-Virus-Checked: Checked This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C4D8B4.EA7EEFCB Content-Type: text/plain Hi All, I have a Query : <statement id="getCodesFromDB" resultClass="com.pbg.mware.mfiles.client.data.CodeDetail" parameterClass="java.lang.Integer" cacheModel="staticcodes-cache"> SELECT TABLE_ID as id , CODE_VAL as codeVal , CODE_VAL_DESCR as codeValDescr, USER_ID as createdBy , CODE_ACTV_FLG as codeActvFlg, LOCK_DTE_TME as lastUpdate FROM COMMON..CODE_DETL WHERE TABLE_ID=#value# </statement> When i Make a First Query with Parameter value=511, Iam retrieving values from database and getting stored in Cache(Using Oscache) as a Key .But for next if i make a Query with value=510 , it is displaying old values for which i got from Query 511 . How to make Caching based on the Parameter and Query. Please Help me out. Thanks in Advance Santhosh. ------_=_NextPart_001_01C4D8B4.EA7EEFCB Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2657.73"> <TITLE>Caching is it Querybased or paramater based or both ?</TITLE> </HEAD> <BODY> <P><FONT FACE=3D"Times New Roman">Hi All,<BR> <BR> I have a Query :<BR> <BR> &lt;statement id=3D&quot;getCodesFromDB&quot; = resultClass=3D&quot;com.pbg.mware.mfiles.client.data.CodeDetail&quot; = parameterClass=3D&quot;java.lang.Integer&quot; = cacheModel=3D&quot;staticcodes-cache&quot;&gt;<BR> SELECT<BR> TABLE_ID as id ,<BR> CODE_VAL as codeVal ,<BR> CODE_VAL_DESCR as codeValDescr,<BR> USER_ID as createdBy ,<BR> CODE_ACTV_FLG as codeActvFlg,<BR> LOCK_DTE_TME as lastUpdate<BR> FROM<BR> COMMON..CODE_DETL<BR> WHERE TABLE_ID=3D#value#<BR> &lt;/statement&gt;<BR> <BR> <BR> When i Make a First Query with Parameter value=3D511, Iam retrieving = values from database and getting stored in Cache(Using Oscache) as a = Key .But for next if i make a Query with value=3D510 , it is displaying = old values for which i got from Query 511 .<BR> <BR> How to make Caching based on the Parameter and Query.<BR> <BR> Please Help me out.<BR> <BR> Thanks in Advance<BR> <BR> Santhosh.<BR> </FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C4D8B4.EA7EEFCB-- From rachelpatel@example.org Thu Dec 2 23:06:33 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 27010 invoked by uid 99); 2 Dec 2004 23:06:33 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from webmail.pointserve.com (HELO ptscorp-exc01.pointserve.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 02 Dec 2004 15:06:31 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: Problems upgrading from 1.2.x to 2.0.8 Date: Thu, 2 Dec 2004 17:06:29 -0600 Message-ID: <rachelpatel@example.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Problems upgrading from 1.2.x to 2.0.8 Thread-Index: AcTYs5jH5QrN+4z0Rq6Syz8sqAQGtwAD5z+g From: "McCarrier, Alex" <rachelpatel@example.org> To: "McCarrier, Alex" <rachelpatel@example.org>, <rachelpatel@example.org> X-Virus-Checked: Checked FYI I found the cause of this: There is an XSL transform in the ibatis-sqlmap-1-x.jar upgrade that does an on the fly conversion when using the old format config files. When it encounters useGlobalTransactions in the settings it assumes the user is using User Managed Transactions and tries to get the JNDI names from the settings as well. However, when useGlobalTransactions is set in the old it does not necessarily mean they are using user managed transactions, by default it means they are using external transactions. The XSL incorrectly translates the file to JTA with JNDI name "". It should translate to transaction type EXTERNAL. =20 -----Original Message----- From: McCarrier, Alex [mailto:rachelpatel@example.org]=20 Sent: Thursday, December 02, 2004 3:12 PM To: rachelpatel@example.org Subject: Problems upgrading from 1.2.x to 2.0.8 I'm getting ClassCastExceptions on TransactionManager when trying to load our old ibatis config file using the new iBatis libraries. =20 Apparently what it is trying to do is an on the fly conversion from the old format to the new format (found by tracing through iBatis source code). However, we don't have anything transaction related in our config file other than a settings option to specify using global transactions. We let the EJB container handle the demarcation of our transactions. When iBatis does the conversion, it seems to default to using JTA transactions, tries to lookup the UserTransaction with JNDI name "" and then throws the ClassCastException. Any ideas on how to fix this without having to do a manual conversion of the file (although I will do that if that's the only way, but someone might want to add this to the upgrade guide). Here's the part of our config file that is causing problems: <?xml version=3D"1.0" encoding=3D"UTF-8"?> <!DOCTYPE sql-map-config PUBLIC "-//iBATIS.com//DTD SQL Map Config 1.0//EN" "http://www.ibatis.com/dtd/sql-map-config.dtd"> <sql-map-config> <settings useGlobalTransactions=3D"true" cacheModelsEnabled=3D"true" /> <!--settings useBeansMetaClasses=3D"true"/ Investigate, suppose to = be big performance improvement--> <datasource name=3D"snmDataSource" =09 factory-class=3D"com.ibatis.db.sqlmap.datasource.JndiDataSourceFactory" default=3D"true" > <property name=3D"DBFullJndiContext" value=3D"java:/dsname" /> </datasource> .. Rest of stuff here ... =20 </sql-map-config> From rachelpatel@example.org Wed Dec 1 15:53:49 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Delivered-To: moderator for rachelpatel@example.org Received: (qmail 78012 invoked by uid 99); 1 Dec 2004 15:53:49 -0000 X-ASF-Spam-Status: No, hits=2.3 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,FORGED_RCVD_HELO,HTML_20_30,HTML_MESSAGE,MIME_QP_LONG_LINE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from wallace.hittite.isp.9tel.net (HELO wallace.hittite.isp.9tel.net) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 07:53:47 -0800 Received: from 9online.fr (unknown [83.161.120.155]) by wallace.hittite.isp.9tel.net (Postfix) with ESMTP id CF1A74578A for <rachelpatel@example.org>; Wed, 1 Dec 2004 18:35:29 +0100 (CET) Date: Wed, 1 Dec 2004 16:54:12 +0100 Message-Id: <rachelpatel@example.org> Subject: =?iso-8859-1?Q?Link_between_SqlMaps?= MIME-Version: 1.0 X-Sensitivity: 3 Content-Type: multipart/alternative; boundary="_=__=_XaM3_Boundary.1101916453.2A.255119-05-8261.161.120.155010.32231" From: "=?rachelpatel@example.org?=" <rachelpatel@example.org> To: "=?utf-8?Q?ibatis-user-java?=" <rachelpatel@example.org> X-XaM3-API-Version: 3.2 (B34) X-type: 0 X-SenderIP: 83.161.120.155 X-Virus-Checked: Checked --_=__=_XaM3_Boundary.1101916453.2A.255119-05-8261.161.120.155010.32231 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0D=0AIs there a way to reference a statement from a sqlMap in one another ? It would be a good thing for modularity.=0D=0AFor instance, I have 2 business objects, let's say address and city:=0D=0AI would like 2 DAO, packaged in 2 jar with their own SqlMap xml files=0D=0A(Of course, my sql-config for my application includes both SqlMaps !)=0D=0AIf I want to use lazyLoading to load the city of an address, I need to reference the "getCityById" statement in the "getAddressById_result". But this element is in another map, and so not found !=0D=0APlease help ! Thank you.<!--TAGSIGN9--><br><br>---------------------------------------------------------------- &lt;Publicit&eacute;&gt;<br>JOUEZ AVEC NEUF TELECOM ! <br>D=E9couvrez un nouveau jeu des bestioles: elles d=E9testent les offres Internet ch=E8res et d=E9truisent tout sur leur passage ! <br>O=F9 =E7=E0 ? Sur leur nouveau site internet =E0 d=E9couvrir absolument : <a href=3Dhttp://www.laccesinternetquivousrendbeauetcelebre.co m target= 3D_blank>http://www.laccesinternetquivousrendbeauetcelebre.com</a><br> --_=__=_XaM3_Boundary.1101916453.2A.255119-05-8261.161.120.155010.32231 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable <DIV>Hi,</DIV>=0D=0A<DIV>Is there a way to reference a statement from a sqlMap in one another ? It would be a good thing for modularity.</DIV>=0D=0A<DIV>For instance, I have 2 business objects, let's say address and city:</DIV>=0D=0A<DIV>I would like 2 DAO, packaged in 2 jar with their own SqlMap xml files</DIV>=0D=0A<DIV>(Of course, my sql-config for my application includes both SqlMaps !)</DIV>=0D=0A<DIV>If I want to use lazyLoading to load the city of an address, I need to reference the "getCityById" statement in the "getAddressById_result". But this element is in another map, and so not found !</DIV>=0D=0A<DIV>Please help ! Thank you.</DIV>=0D=0A<DIV>&nbsp;</DIV><!--TAGSIGN9--><br><br>---------------------------------------------------------------- &lt;Publicit&eacute;&gt;<br>JOUEZ AVEC NEUF TELECOM ! <br>D=E9couvrez un nouveau jeu des bestioles: elles d=E9testent les offres Internet ch=E8res et d=E9truisent tout sur leur passage ! <br>O=F9 =E7=E0 ? Sur leur nouveau site internet =E0 d=E9couvrir absolument : <a href=3Dhttp://www.laccesinternetquivousrendbeauetcelebre.com target=3D_blank>http://www.laccesinternetquivousrendbeauetcelebre.com</a><br> --_=__=_XaM3_Boundary.1101916453.2A.255119-05-8261.161.120.155010.32231-- From rachelpatel@example.org Wed Dec 1 18:22:27 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Delivered-To: moderator for rachelpatel@example.org Received: (qmail 67633 invoked by uid 99); 1 Dec 2004 18:22:27 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO mail.dillonsoftware.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 10:22:26 -0800 Received: from reep.dillonsoftware.com (reep.dillonsoftware.com [83.161.120.155]) by mail.dillonsoftware.com (Postfix) with ESMTP id 26CFA241BBD for <rachelpatel@example.org>; Wed, 1 Dec 2004 11:07:14 -0700 (MST) Subject: caching, doesn't From: Sean Dillon <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: rachelpatel@example.org Content-Type: text/plain Organization: Dillon Software Date: Wed, 01 Dec 2004 11:22:21 -0700 Message-Id: <1101925341.9198.17.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked Ok, I'm stuck, and I have an uncomfortable feeling that the queries I *thought* were cached are, in fact, not. Case in point: The following query does NOT cache the results. First, a snippet from my sqlmap.xml config file: <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="false" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="true" /> Next, the cache model definition from a sqlmap called "Campaigns": <cacheModel id="CampaignsCache" type="MEMORY" readOnly="false"> <flushInterval minutes="30"/> <property name="reference-type" value="STRONG"/> </cacheModel> AND NOW, here's the select statement that I would think WOULD be cached: <select id="titles" resultClass="java.util.HashMap" cacheModel="CampaignsCache"> select Titles.id as "id", Titles.name as "name", Titles.description as "description", Titles.img as "img", CampaignTitles.position as "position" from CampaignTitles, Titles where CampaignTitles.campaignId = #value# and CampaignTitles.titleId = Titles.id order by position </select> This statement is being called with a single Integer parameter as follows: // Get a list of titles for this campaign. Should be cached. List titles = getSqlMapExecutor().queryForList("Campaigns.titles", new Integer(campaignId)); So, what am I missing here? If I execute my dao code such that it returns a list, and then use sql*plus to perform a manual update in the database, and then execute the dao again to retrieve the list, I'm seeing the change... but I shouldn't, because it should have been cached - it should NOT have gone to the database, so the change should NOT be reflected in the returned list. I've tried changing the cacheModel attribute of the select tag to both CampaignsCache and Campaigns.CampaignsCache thinking it might be a namespace issue - no luck. I also tried providing a parameterClass="int" in the select tag. Again, no luck. Any ideas? What the heck?! -- Sean Dillon <rachelpatel@example.org> Dillon Software From rachelpatel@example.org Wed Dec 1 19:29:42 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Delivered-To: moderator for rachelpatel@example.org Received: (qmail 47150 invoked by uid 99); 1 Dec 2004 19:29:42 -0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=DNS_FROM_RFC_ABUSE,FROM_ENDS_IN_NUMS X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from web50009.mail.yahoo.com (HELO web50009.mail.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with SMTP; Wed, 01 Dec 2004 11:29:40 -0800 Received: (qmail 58247 invoked by uid 60001); 1 Dec 2004 19:29:38 -0000 Message-ID: <rachelpatel@example.org> Received: from [83.161.120.155] by web50009.mail.yahoo.com via HTTP; Wed, 01 Dec 2004 20:29:38 CET Date: Wed, 1 Dec 2004 20:29:38 +0100 (CET) From: Ignacio Perez Sainz <rachelpatel@example.org> Subject: JDBC 3.0 To: Ibatis <rachelpatel@example.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked Hello: I'd like to know if the last version of IBatis-sqlMap support the driver JDBC-3.0 Thank you. ______________________________________________ Renovamos el Correo Yahoo!: ¡100 MB GRATIS! Nuevos servicios, más seguridad http://correo.yahoo.es From rachelpatel@example.org Wed Dec 1 22:30:35 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Delivered-To: moderator for rachelpatel@example.org Received: (qmail 77711 invoked by uid 99); 1 Dec 2004 22:30:35 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from webmail.pointserve.com (HELO ptscorp-exc01.pointserve.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 01 Dec 2004 14:30:34 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: MappedStatement.getSql()? Date: Wed, 1 Dec 2004 16:30:31 -0600 Message-ID: <rachelpatel@example.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: MappedStatement.getSql()? Thread-Index: AcTX9V3P1NI35nXVQ2Ouzl+G18YC/w== From: "McCarrier, Alex" <rachelpatel@example.org> To: <rachelpatel@example.org> X-Virus-Checked: Checked I'm in the process of upgrading our app from an old version of iBatis (1.2.x I believe) to iBatis 2.0.8. I am using the compatibility libraries and we were using a method called MappedStatement.getSql() to get the actual SQL string that would be used by a statement. It seems this method is not in the compatibility libraries, is there anything like it in the new version? From rachelpatel@example.org Fri Dec 3 14:05:38 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 52731 invoked by uid 99); 3 Dec 2004 14:05:38 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from trickle.CC.McGill.CA (HELO trickle.cc.mcgill.ca) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 06:05:36 -0800 Received: from mailscan3.cc.mcgill.ca (mailscan3.CC.McGill.CA [83.161.120.155]) by trickle.cc.mcgill.ca (8.12.11/8.12.3) with ESMTP id iB3E5VS7007128 for <rachelpatel@example.org>; Fri, 3 Dec 2004 09:05:32 -0500 (EST) Received: from Excalibur (mgc237062.Genome.McGill.CA [83.161.120.155]) by mailscan3.cc.mcgill.ca (8.12.10/8.12.10) with ESMTP id iB3E5THm010683 for <rachelpatel@example.org>; Fri, 3 Dec 2004 09:05:29 -0500 (EST) From: "Philippe Laflamme" <rachelpatel@example.org> To: "'ibatis-user-java'" <rachelpatel@example.org> Subject: RE: Link between SqlMaps Date: Fri, 3 Dec 2004 09:05:29 -0500 Message-ID: <rachelpatel@example.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <rachelpatel@example.org> X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Checked: Checked If both <sqlMap> nodes are in your <sqlMapConfig> node, then it's a = matter of ordering... <sqlMap> nodes can refer to statement and result maps = that are present in previous <sqlMap> nodes. For example: <sqlMapConfig> ... <sqlMap resource=3D"A"/> <sqlMap resource=3D"B"/> <sqlMap resource=3D"C"/> </sqlMapConfig> Here, B can reference stuff from A and C can reference stuff from B and = A... Cheers, Philippe -----Original Message----- From: rachelpatel@example.org [mailto:rachelpatel@example.org]=20 Sent: Wednesday, December 01, 2004 10:54 AM To: ibatis-user-java Subject: Link between SqlMaps Hi, Is there a way to reference a statement from a sqlMap in one another ? = It would be a good thing for modularity. For instance, I have 2 business objects, let's say address and city: I would like 2 DAO, packaged in 2 jar with their own SqlMap xml files (Of course, my sql-config for my application includes both SqlMaps !) If I want to use lazyLoading to load the city of an address, I need to reference the "getCityById" statement in the "getAddressById_result". = But this element is in another map, and so not found ! Please help ! Thank you. ---------------------------------------------------------------- = <Publicit=E9> JOUEZ AVEC NEUF TELECOM !=20 D=E9couvrez un nouveau jeu des bestioles: elles d=E9testent les offres = Internet ch=E8res et d=E9truisent tout sur leur passage !=20 O=F9 =E7=E0 ? Sur leur nouveau site internet =E0 d=E9couvrir absolument = : http://www.laccesinternetquivousrendbeauetcelebre.com From rachelpatel@example.org Fri Dec 3 14:36:08 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 56631 invoked by uid 99); 3 Dec 2004 14:36:08 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 06:36:08 -0800 Received: by wproxy.gmail.com with SMTP id 68so222249wri for <rachelpatel@example.org>; Fri, 03 Dec 2004 06:36:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=MYA09xA2KiQ9n6ZBE1ggU6T+eLJs7I6io4N51uOFha3tg/tvItpDKCPeqObcx/TyJ5wgQALUxF0Eh/2XJfuJhowg2kOQPVe/iR3/lpTEhrHK+JfPmI7/uLEy153YY3qaps1F4NGhPG1k/gSoQ0VBmuioFw8hsGUMC9/c4XcYlCs= Received: by 83.161.120.155 with SMTP id 8mr1927979wrx; Fri, 03 Dec 2004 06:36:04 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 3 Dec 2004 06:36:04 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Fri, 3 Dec 2004 06:36:04 -0800 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: Ignacio Perez Sainz <rachelpatel@example.org> Subject: Re: JDBC 3.0 Cc: Ibatis <rachelpatel@example.org> In-Reply-To: <rachelpatel@example.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable References: <rachelpatel@example.org> X-Virus-Checked: Checked iBATIS supports JDBC 3.0 in that JDBC 3.0 is compatible with JDBC 2.0. iBATIS doesn't depend on JDBC 3.0. Cheers, Clinton On Wed, 1 Dec 2004 20:29:38 +0100 (CET), Ignacio Perez Sainz <rachelpatel@example.org> wrote: > Hello: >=20 > I'd like to know if the last version of IBatis-sqlMap > support the driver JDBC-3.0 >=20 > Thank you. >=20 >=20 > ______________________________________________ > Renovamos el Correo Yahoo!: =A1100 MB GRATIS! > Nuevos servicios, m=E1s seguridad > http://correo.yahoo.es > From rachelpatel@example.org Fri Dec 3 14:39:34 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 67959 invoked by uid 99); 3 Dec 2004 14:39:34 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 06:39:32 -0800 Received: by wproxy.gmail.com with SMTP id 57so74859wri for <rachelpatel@example.org>; Fri, 03 Dec 2004 06:39:25 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=BDoVRImXbBTUeDzR7jYuqQGAOBIJTZ2kCIF8xUn7f4BFvZQAMSjuS5C/n0iSOJ6ifmNc7LZ4IRYTpTei5KGYzt2jXkwI+nY6hDRFqtyWcdQ6Vf496IS4VhS4L93CDB8YUBofhTCiwlU8C/6ywoH4bcikieHhlI3hYwZLrOwhvRU= Received: by 83.161.120.155 with SMTP id 56mr718096wrw; Fri, 03 Dec 2004 06:39:25 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 3 Dec 2004 06:39:25 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Fri, 3 Dec 2004 06:39:25 -0800 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: "McCarrier, Alex" <rachelpatel@example.org> Subject: Re: MappedStatement.getSql()? Cc: rachelpatel@example.org In-Reply-To: <rachelpatel@example.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <rachelpatel@example.org> X-Virus-Checked: Checked There is no replacement for it. It was never intended to be called directly. One focus of 2.0 was clear separation of the public API from the implementation, and that method was one that was protected. Cheers, Clinton On Wed, 1 Dec 2004 16:30:31 -0600, McCarrier, Alex <rachelpatel@example.org> wrote: > I'm in the process of upgrading our app from an old version of iBatis > (1.2.x I believe) to iBatis 2.0.8. I am using the compatibility > libraries and we were using a method called MappedStatement.getSql() to > get the actual SQL string that would be used by a statement. It seems > this method is not in the compatibility libraries, is there anything > like it in the new version? > From rachelpatel@example.org Fri Dec 3 14:43:23 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 76742 invoked by uid 99); 3 Dec 2004 14:43:23 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 06:43:21 -0800 Received: by wproxy.gmail.com with SMTP id 68so223411wri for <rachelpatel@example.org>; Fri, 03 Dec 2004 06:43:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LPqxWyg+mgEVgNoieGuEd+FBamDkdTqFfJyNd85ChEpFOd/skUhT7nsueUOubnIZJ8eNadjcTAIqC2aZvdoJ+tIpptE4r4lZl6Nke9vM3frhDNsbOIzpYOJ4t5+6t0t3+VctEp77sKw8ea9ou7rgCPJQkYBIhQN3t6n6tqCwoT8= Received: by 83.161.120.155 with SMTP id g80mr7522wrg; Fri, 03 Dec 2004 06:43:18 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 3 Dec 2004 06:43:18 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Fri, 3 Dec 2004 06:43:18 -0800 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: Erich Roncarolo <rachelpatel@example.org> Subject: Re: oscache config file (oscache.properties) Cc: rachelpatel@example.org In-Reply-To: <rachelpatel@example.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <rachelpatel@example.org> X-Virus-Checked: Checked You'll have to check the OSCache docs. If there is a way, we can provide an interface or configuration option to it. Clinton On Tue, 30 Nov 2004 10:32:42 +0100, Erich Roncarolo <rachelpatel@example.org> wrote: > Hi! > There is a way to set the place where oscache.properties is? > Only if I put it in the classpath oscache seems work, but I don't like it very much. I'd prefer to put oscache.properties in my conf directory. > Thank you very much > -Erich > From rachelpatel@example.org Fri Dec 3 15:04:00 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 36485 invoked by uid 99); 3 Dec 2004 15:04:00 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 07:03:58 -0800 Received: by wproxy.gmail.com with SMTP id 68so227012wri for <rachelpatel@example.org>; Fri, 03 Dec 2004 07:03:55 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=QEY8jlsK50qG8QbeVwhP0dfBdJIuh30bk8yJuJW/MN945nGnQ0+P56SUY9bVUBdRiu34Mymhqct93uBDl4mfEuhi5j5g2WasDeNs1+QdTHbXOoMDpnHHxwn/nByyOJ3MXbRG4ipNuxMLYBQ7GhQaZPm0KVH0YZN9wfFlVaIenTU= Received: by 83.161.120.155 with SMTP id g80mr14587wrg; Fri, 03 Dec 2004 07:03:55 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 3 Dec 2004 07:03:55 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Fri, 3 Dec 2004 07:03:55 -0800 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: "McCarrier, Alex" <rachelpatel@example.org> Subject: Re: Problems upgrading from 1.2.x to 2.0.8 Cc: rachelpatel@example.org In-Reply-To: <rachelpatel@example.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <rachelpatel@example.org> X-Virus-Checked: Checked I'd really recommend converting your SQL Maps (just the XML) to the 2.0 syntax. You can continue to safely use the 1.x java API, but the 2.0 XML is much cleaner and will avoid these conversion issues for complex configurations. Cheers, Clinton On Thu, 2 Dec 2004 17:06:29 -0600, McCarrier, Alex <rachelpatel@example.org> wrote: > FYI I found the cause of this: > > There is an XSL transform in the ibatis-sqlmap-1-x.jar upgrade that does > an on the fly conversion when using the old format config files. When > it encounters useGlobalTransactions in the settings it assumes the user > is using User Managed Transactions and tries to get the JNDI names from > the settings as well. However, when useGlobalTransactions is set in the > old it does not necessarily mean they are using user managed > transactions, by default it means they are using external transactions. > The XSL incorrectly translates the file to JTA with JNDI name "". It > should translate to transaction type EXTERNAL. > > > > -----Original Message----- > From: McCarrier, Alex [mailto:rachelpatel@example.org] > Sent: Thursday, December 02, 2004 3:12 PM > To: rachelpatel@example.org > Subject: Problems upgrading from 1.2.x to 2.0.8 > > I'm getting ClassCastExceptions on TransactionManager when trying to > load our old ibatis config file using the new iBatis libraries. > > Apparently what it is trying to do is an on the fly conversion from the > old format to the new format (found by tracing through iBatis source > code). However, we don't have anything transaction related in our > config file other than a settings option to specify using global > transactions. We let the EJB container handle the demarcation of our > transactions. When iBatis does the conversion, it seems to default to > using JTA transactions, tries to lookup the UserTransaction with JNDI > name "" and then throws the ClassCastException. Any ideas on how to fix > this without having to do a manual conversion of the file (although I > will do that if that's the only way, but someone might want to add this > to the upgrade guide). > > Here's the part of our config file that is causing problems: > > <?xml version="1.0" encoding="UTF-8"?> > > <!DOCTYPE sql-map-config > PUBLIC "-//iBATIS.com//DTD SQL Map Config 1.0//EN" > "http://www.ibatis.com/dtd/sql-map-config.dtd"> > > <sql-map-config> > > <settings useGlobalTransactions="true" > cacheModelsEnabled="true" /> > <!--settings useBeansMetaClasses="true"/ Investigate, suppose to be > big performance improvement--> > > <datasource name="snmDataSource" > > factory-class="com.ibatis.db.sqlmap.datasource.JndiDataSourceFactory" > default="true" > > <property name="DBFullJndiContext" value="java:/dsname" /> > </datasource> > > .. Rest of stuff here ... > > </sql-map-config> > From rachelpatel@example.org Fri Dec 3 15:05:57 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 42797 invoked by uid 99); 3 Dec 2004 15:05:57 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=HTML_30_40,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from box.ateikon.com (HELO ateikon.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 07:05:55 -0800 Received: (qmail 8026 invoked by uid 11194); 3 Dec 2004 15:16:08 -0000 Received: from rachelpatel@example.org by smtp by uid 11186 with qmail-scanner-1.22 (clamdscan: 0.73. spamassassin: 2.63. Clear:RC:1(83.161.120.155):. Processed in 0.282922 secs); 03 Dec 2004 15:16:08 -0000 Received: from unknown (HELO [83.161.120.155]) ([83.161.120.155]) (envelope-sender <rachelpatel@example.org>) by mailbox.ateikon.com (qmail-ldap-1.03) with SMTP for <rachelpatel@example.org>; 3 Dec 2004 15:16:06 -0000 Message-ID: <rachelpatel@example.org> Date: Fri, 03 Dec 2004 16:05:51 +0100 From: Emiliano Armellin <rachelpatel@example.org> Reply-To: rachelpatel@example.org User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: rachelpatel@example.org Subject: CLOB on Oracle Content-Type: multipart/alternative; boundary="------------090100060209020200040608" X-Virus-Checked: Checked This is a multi-part message in MIME format. --------------090100060209020200040608 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello, I have a String variable in my java bean ("contenuto") and I have to populate with this string value a CLOB field on a table in Oracle 9i DB. Wel,l I receive this exception: |org.springframework.jdbc.UncategorizedSQLException: (SqlMapClientTemplate): encountered SQLException [ --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. --- The error occurred while applying a parameter map. --- Check the insertAtkMessaggioItem-InlineParameterMap. --- Check the parameter mapping for the 'contenuto' property. --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. --- The error occurred while applying a parameter map. --- Check the insertAtkMessaggioItem-InlineParameterMap. --- Check the parameter mapping for the 'contenuto' property. --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650 com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. --- The error occurred while applying a parameter map. --- Check the insertAtkMessaggioItem-InlineParameterMap. --- Check the parameter mapping for the 'contenuto' property. --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650 Caused by: java.sql.SQLException: Data size bigger than max size for this type: rachelpatel@example.org(GeneralStatement.java:86) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:266) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:70) at org.springframework.orm.ibatis.SqlMapClientTemplate$10.doInSqlMapClient(SqlMapClientTemplate.java:281) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:142) at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:279) at com.ateikon.internet.atkim.dao.ibatis.SqlMapAtkMessaggioDao.insertItem(SqlMapAtkMessaggioDao.java:41) at com.ateikon.internet.atkim.domain.logic.AtkimImpl.insertMail_NN(AtkimImpl.java:249) at java.lang.reflect.Method.invoke(Native Method) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:295) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:154) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:121) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy0.insertMail_NN(Unknown Source) at com.ateikon.internet.atkim.web.spring.SendMailController.handleRequestInternal(SendMailController.java:236) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:532) at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:366) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:317) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:721) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Unknown Source) |what can I do? -- Emiliano Armellin * W_ www.ateikon.com <http://www.ateikon.com> * @_ rachelpatel@example.org <mailto:rachelpatel@example.org> * T_ *803.425.1622* Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86> Get Thunderbird <http://www.mozilla.org/products/thunderbird/> --------------090100060209020200040608 Content-Type: multipart/related; boundary="------------020200030900090906000006" --------------020200030900090906000006 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> Hello,<br> <br> I have a String variable in my java bean ("contenuto") and I have to populate with this string value a CLOB field on a table in&nbsp; Oracle 9i DB. <br> Wel,l I receive this exception:<br> <br> <code>org.springframework.jdbc.UncategorizedSQLException: (SqlMapClientTemplate): encountered SQLException [&nbsp; <br> --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml.&nbsp; <br> --- The error occurred while applying a parameter map.&nbsp; <br> --- Check the insertAtkMessaggioItem-InlineParameterMap.&nbsp; <br> --- Check the parameter mapping for the 'contenuto' property.&nbsp; <br> --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <br> --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml.&nbsp; <br> --- The error occurred while applying a parameter map.&nbsp; <br> --- Check the insertAtkMessaggioItem-InlineParameterMap.&nbsp; <br> --- Check the parameter mapping for the 'contenuto' property.&nbsp; <br> --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650<br> com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <br> --- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml.&nbsp; <br> --- The error occurred while applying a parameter map.&nbsp; <br> --- Check the insertAtkMessaggioItem-InlineParameterMap.&nbsp; <br> --- Check the parameter mapping for the 'contenuto' property.&nbsp; <br> --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650<br> Caused by: java.sql.SQLException: Data size bigger than max size for this type: 5650<br> &nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:86)<br> &nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:266)<br> &nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:70)<br> &nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate$10.doInSqlMapClient(SqlMapClientTemplate.java:281)<br> &nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:142)<br> &nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:279)<br> &nbsp;&nbsp;&nbsp; at com.ateikon.internet.atkim.dao.ibatis.SqlMapAtkMessaggioDao.insertItem(SqlMapAtkMessaggioDao.java:41)<br> &nbsp;&nbsp;&nbsp; at com.ateikon.internet.atkim.domain.logic.AtkimImpl.insertMail_NN(AtkimImpl.java:249)<br> &nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Native Method)<br> &nbsp;&nbsp;&nbsp; at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:295)<br> &nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:154)<br> &nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:121)<br> &nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)<br> &nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143)<br> &nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)<br> &nbsp;&nbsp;&nbsp; at $Proxy0.insertMail_NN(Unknown Source)<br> &nbsp;&nbsp;&nbsp; at com.ateikon.internet.atkim.web.spring.SendMailController.handleRequestInternal(SendMailController.java:236)<br> &nbsp;&nbsp;&nbsp; at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)<br> &nbsp;&nbsp;&nbsp; at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)<br> &nbsp;&nbsp;&nbsp; at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:532)<br> &nbsp;&nbsp;&nbsp; at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:366)<br> &nbsp;&nbsp;&nbsp; at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:317)<br> &nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)<br> &nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<br> &nbsp;&nbsp;&nbsp; at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:721)<br> &nbsp;&nbsp;&nbsp; at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)<br> &nbsp;&nbsp;&nbsp; at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)<br> &nbsp;&nbsp;&nbsp; at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)<br> &nbsp;&nbsp;&nbsp; at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)<br> &nbsp;&nbsp;&nbsp; at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)<br> &nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Unknown Source)<br> <br> </code>what can I do?<br> <br> <br> <div class="moz-signature">-- <br> <div style="font-family: Georgia,serif;">Emiliano Armellin <ul style="border-left: 1px solid black; margin: 5px 0pt 5px 5px; padding: 0pt; list-style-type: none; list-style-image: none; list-style-position: outside; text-indent: 0pt;"> <li style=""> <div style="width: 30px; float: left; text-align: right; margin-right: 5px;">W_</div> <a href="http://www.ateikon.com">www.ateikon.com</a></li> <li style=""> <div style="width: 30px; float: left; text-align: right; margin-right: 5px;">@_</div> <a href="mailto:rachelpatel@example.org">rachelpatel@example.org</a></li> <li style=""> <div style="width: 30px; float: left; text-align: right; margin-right: 5px;">T_</div> <strong>803.425.1622</strong></li> </ul> <div style="float: left;"> <a href="http://www.spreadfirefox.com/?q=affiliates&amp;id=15653&amp;t=86"><img alt="Get Firefox!" title="Get Firefox!" src="cid:rachelpatel@example.org" border="0" height="31" width="88"></a></div> <div><a href="http://www.mozilla.org/products/thunderbird/" title="Get Thunderbird - Reclaim Your Inbox"><img src="cid:rachelpatel@example.org" alt="Get Thunderbird" border="0" height="32" width="110"></a></div> </div> </div> </body> </html> --------------020200030900090906000006 Content-Type: image/gif; name="trust.gif" Content-Transfer-Encoding: base64 Content-ID: <rachelpatel@example.org> Content-Disposition: inline; filename="trust.gif" R0lGODlhWAAfAOYAAAAAAMXd3QBWnswzAKkXALWqnQAgZnCfnu/v71hcmXd8fNCERTk7O11h YQqk1K5nQgAKSeBiDtPl5bPPz////wBOjw6MyMFNGeWdbOFaCnJ3d4aurhcaGjPM/+bm5uds J9Xe3ik7Zn+MjORSAb3OzicwXa2/wiRYfvOFOJIbEEhLS8luZSYpKeNkFPP39wA9dGPM7JbZ 64mWlv+3d5yjo4BMOczMzN7s7MFhFABtqw4PD9NHB/BpH769twCZzGZmZpSmpsUgB/3srhBf hK+2tq94YKuahuxrG9qPbFhziPzKo87d3UKx3maZmcLHx6a3t/mMTzFxqu90Jd5sFqdVITN5 pd6UZQAwd74WBwBAhz9ERNrV0sR4Pt/f31FTU/meVZu7u+Xv74+jo91/JD1ggs+8rN5KBup6 GAAhPu/Aid9TCJU4Ea13UudaCKJXM78xBxOv4MeebQBmmTMzMz4+dw91tMHW1gAzZqPE1B4f Hxhzj9U7DMOffvBmE/KAMe+QWCH5BAUUAB0ALAAAAABYAB8AAAf/gB2CE4SFhoeIiYqLjI2O hoKRhEsSlZaXmJmam5ydnpd2JiZ4pKSFknYuFKusra6vsLGys7SsJnQGLxUCvDk5dUx2Ex2E qrXHyMmxCHxbrGIGBlnTFbsCv8AkhBLK3d60qlY4zmEJ0VdX01nW13VwMYQI3/P0rAVTZ2U2 uOfo6klGaFRxByPeMhu0unSpp8yFCytnznChAyGaRXRJygiZQUaABThw7CwxRgGASQBaemih pUABw2QunHCJeKZGxRIhcoYwkmbGFy9ZcjgAKSGMK5WrkMpbhWAhq5ZOKchDSIHqUlcIerBq urXL1VUujOA4MyVCBDdFMMxY+weKnz4P/+TksODAgQWSrJBS6JFnTh4NFGjk+fu0rw4bCFAq sJFHyxwEOrrQAEDhxw++KlQEHvyjst+vLhCIbbFDzQcUKKBA+fJFCg8efZLUne3ARRiHuHsw cNhjjgfdLnT08AAAt4IfLn6ocAHAhgsVClwwEKGCRgPhDHoomAPCoXDiLhQsx+0QAYIiF/bs ed2nvfvXPNo08OGD9o0lt3ET2e1if//dALDAAANOONRSeAA6xEB0x4nwgw4iKFCcByrowABx AhJ4IHm2eVDEG6WpYVYbJJLo3ggpyOEAffUJc4N55u0XIwMIyKgDDU3BqMEPCDTQQGLmqfBD GNMxRqAOKoRRlP8EABBxo5JhaKBBGFRWeQMIReyQgYhmZVBiiX2oQUAKerDogyhFVbkflWuu KRgDSVKpAQs6HBYGAFQ6kQcDLIAQRh4i/BnonAKG8WaSUlZpZQ9ctGDWFFN8KamYBKxRQw0q 6AHGBgHc4OmnoIZ6n6ikerpEqZ+emiqqV8YBaQRjjJHBCJJ++cYbAwywwxoqHHCAHZ8EK+yw mfSwgKywRkBrrSXuoOsHM6SRRBNNTEDstdhyUsAYEZgB6QgZRMAsiaalIUQPZORA7QRLtOvu u/DGK++87T4hAr3xygBEu3a4OsIIU2SQQVnj9hGBFUqIoIu61QbgMAkOR0yCCRI/HHH/ABNH /ETFG0ds2cMZQwwxxkA4PEfJATixgFn/Ahwps0ccIYUUbNxRgVzr2iEMACbYwYIIInDAggp2 iDGHHZbpbIcMQosgBgdz6GDCBADMwYEWSnPAwQ9MsyDDHGLYAUDRV2vxhA5e29HDGJDOOgK3 tfYRsxR++PHAEHIxPEHEWmhgAgAT6CBGAAA8YXQAHzusgwwR783C4DyLAYDHPwTwNMRgE444 CxQHkHkAJrBxhrIjRDDFsiXOTTdqKJyQ97oRizCHCFoQXvIc+s6BeOUOA4DyE1BzUPLkQEzu 8MdAzNHuyUsAsAQJWugwBwnML0GEG2e4XRbqfbTg/Qfgo/bF/wnX6O0uCSjJsMTizT9BAwtL NPCDu+yT8IPyc9DQ/BKTuWsZ/8pbAu7Q97znAYAG+WtXAS5wutJ9q0RmwIIEsZACNKCBAVwg 3zWoRQIQeBAE0fNg0FjgBRA4QXos4I4I0aYAGaCwhAAAwWQ+6MIGINCDDRAaB2jwAxakEAQ5 FIEdFrgHcJmugW2I4ASxMIc73OEFuuCFADj4QRAooIQftEEVtahFhSjEBl4EIxi9SMYujJGM YgyjGm2wwAGUjnT/asMAsBCEOgaBAVd4ATWkyEEv0oADTiijIAdJyEIacpBbWKDAwtWyfw3A jkHYwwXusI5qVCMK1AKDBza5hU168qmToAylKEdJylImkgADcBQcHZkr9eyhD1QIQSWrcQBq HaCUuPwkjHbJy1768pddKEAKgjAFEbntX650ZXtwoAJ1nKCWHWjCBkDwy2pa85rY7GUXiDDM KZihBQ38lxmSaYYMtKcFF3DDAzbQBEFQqwlgMAG+5FXFetrznvi85/MKsAIkWOGfALUCEgZK 0IFiAAMFKEAt2xmJdzr0oRCNqEQnStGKWjSikQgEADs= --------------020200030900090906000006 Content-Type: image/png; name="thunderbird_small.png" Content-Transfer-Encoding: base64 Content-ID: <rachelpatel@example.org> Content-Disposition: inline; filename="thunderbird_small.png" iVBORw0KGgoAAAANSUhEUgAAAG4AAAAgCAYAAADzCU3nAAAABmJLR0QA/wD/AP+gvaeTAAAA CXBIWXMAAAsTAAALEwEAmpwYAAAAB3RJTUUH1AUZDzg0nf1sjwAADttJREFUeNrtmntwVFWa wH+3H7ef6XR3Hp2QZ+fBIyQICdGAiLVkxAUcdXSYHRXZ2tXZWXVmd7Uc2S1ff6yjNeuWheVW uRazlu5o0FkZEUeyCkGQQcAgEBPeodNJ59XdSTqd9PN233v3D7BreAQBdWZnN19V/3H6nO/U d7/f+b7znXOvoKoq0/KnJ7orVVj4xHsWb8/Q45FwZGvit4/+btqFfwLg/vqtvTkGjbqRIzvb 8wpKq/Pn3mCsnDvTMOe799t7+8fSQ8FouD840Z+clPqSmx+cmHbvtyfC5abKJWte1tb/sGnb 8Y+7lkZCY4dzZ1XW2ewW0ZnvxNsXYMA/yUBgknA4qWpS8rBWVg/KE8n/NKDZNLbr7+VpV/8R wFmK1y2/6fvzHmu8fX7z8Ck/ismAJGhIptKEwgmGAhECY1E0goAjy4jZqEOr0aDTCIwEJg+I WYZfHHj2jnem3f0HAqdZvr7YPim/PKvAeMsDT61AMegYCycYnUgQCEaYGIvj8U8wEZWwWkRs FhGNRkCv1yKlZJzZRlQEtAKUZum4c24ueVb9tNenljTQC7QD24EtVVVVwYuymWqGGX/zem1e tmWbJpG8pam+hOISJwlJJhRO0HtqBHUoyshIlHBMwmzSYzLoUFQVrUZgbDyOyaBDAELjMQRB YNsXfn72bg+9Q8FpPJeuOSqBHwK/BDZ0d3c3Xza4O19qrS1x2bfbdPrZVlVmxS3z6B2Z5MSp EQ7u7sE4liQYkzgRnCAVSxANR0AAGS3jkSR6nYacbBNpWaWixE46rWAQdchaePnD49N4Ll9u A569GLwLwC178KnKtNa8xSqKrqFDx6kpS6MryGZb63E+fKMD3WSalEHLvv5RQmNx/IOTDB0f 4mjbYfwdXUTiaYxGEaNRRyqtMBZOcLJ3jImJBPF4nD39Rl57b880ksuXa4Gfdnd3510SXGlV 5YvZNou745MT1MbfZulML8d6J/h8WzfOjlepFr183B8hOC4jJbTIaRFZY0NK2vB9NkBfaxuj oSi7PuvD2z+O1zeOIqs4dDp6fWFiQ34+2J/G4+2bRnJlkXfrlOCu+95djZbya1Z2dQyQ1b+X 2xdGKbQMMTA0ipqIs7SpmAlXKb4TXsr9+5kZ2kvBeBcMe4j7h0jLED12iqEdn1BdkcfkRILj J4N094wS8E+SK4pIkQQx7wjvbjtyxdZHo9FvxSvRaBSPx/O19L+uBAIBAoHApYZ8Z8oD+Pxb 7vnBcc+ocOqz49y3IEKpeyYRxcFwcJzKhWWcdjbSuesDnrJsZk5REFWRMNoLMBXM5aAnwSef ++hXZYLHxwkfX0Cxw050PIFZqyXbakQYn0DoCzAu6NjfoRBPJDAZjZd0nsVioauri5aWFh5/ /HFqamrQarXfKDiPx8PPf/5zVq9ezZ133nlFuhs2bKCtrY0333zzArtaWlpoa2vjueeeIz8/ /5Lz7Nu3j5aWFtatW8eCBQsuNqRxSnCSPmdRJDyKJuhjzvUqZoeZHNe1nO47wqljX2A1RHiq qhtnloVo3IB7Vg01dfMQRS1/riS5PzDMtr2f0n7oBBs/3YGxfgV6UYeYTJGbZaK3qxshEiOe 5WAwaqLPN8is6opznHe+LF26FJfLBYDX68XtdmO1Wr+VyBsdHSUYDJKXl3dFkQJw7Ngxamtr L+hXVZXu7m7sdjuiKH7lfP39/VRXV1/sGcumBNfV1V9y5HAQixQl32Wn4c9uYv9BH2Iywa+f X01g79uExstJJpNU11VT27gYORklJcVQpTh5+W7+YlURoua/2DN0hGDqZorNBnwHOjiNSmBU QpNjR2OwYLGaGfIHM+AqKip45JFHOHz4MDt27KC+vp45c+Zgt9vxer0AJBIJWltbMRgMNDU1 kZ+fTzQapbOzE4vFQl1dHR6Ph56eHpqbmwkEAuzbt4/m5mba2toAaG5uxmKxANDZ2UlPT8+U UdjV1XWOTiAQoLOzE7fbTVdXF263OzP+4MGDeDwe3G43dXV1ADQ1NaGqKg6Hg0AgwIkTJ87R rauro62tjWg0it/vv6LryXMa/YPhLNkTQJEF8svrKJl3F76+F4l4O3BV3Uu4bx4GtQer0UD1 kptR9VrQmREMCYR0AlWR0OkEli1dyW/3/waPGdLRNBMDwySzctBbbOhIQzKFzSoyPpk8JyU2 NDQAsGPHDux2O/X19WRnZxMMnjn7bdq0KTP+o48+4oUXXsDj8bB+/XruuOMO3G43GzdupLOz k/r6erZv386WLVvYvHkzsVgMgN7eXh588EHa29tZv379lGlr/fr1lJeXEwgE2L17N08++SQe j4cNGzZgNpuJxWI89thjyPKZ27ytW7dm9NeuXcvKlSsztixfvpzTp09foPv666/T2tp6Vdnh nOJkIiypZqMW0VVB0ugGJBavupfSyjx2vvM2hTXXYc0to3DuIgyuSrDkoc0pQldQgWLOIxgR 2Nl2mG27TlJV7iIyNsLQSBKdI4schwVblojZqEdNJDFlGYkmUucYo9VqMZlMmbYoilitVnS6 M+tr2bJlPPHEExQWFjIyMpKJRIDx8XHi8XimPTAwkEk3TU1NrFu3DoDBwUGGh4fZsmULAPfc c88F+1pLSwtlZWWsWbOG2267DZ/Px9atWzO2lZWV8fTTT5+T+h566CHuu+8+AN5//31CoVCm z+/3Z6L8S11FUWhtbcVsNvPoo4+yePHiqwennAqM5FhT/HhFGm/cASRAELnhB3+HFB2kt6eX 0vobya2YC1ongrmQkTGFTz74hHdb3qG9vZ2UCI3N17H6+7eS48zC4RDJcmbjKnUhyhLhkQja XCdyWkaWUldkbGFhIS6Xi9zc3DN7siRdtl5xcXGmnUqlMoWQ2+2mrKzsgn2rt7eXZ555ho0b N55Z1BMTmagtLCzEarVSW1ubKUgcDgc33ngjAKFQKJMlLmaL1WrFYDAA4HK5sFgslJaWXv1r Hc1kxBuZSMy8vsqBXTyAlKhCNFrRGxws+d4admz8FcXVNcgY6NjdxumOA8TCw+QX2mlYVEuO 3YbVIKLXpPEGFIpmlRDaewRrrhObw8KpSBqNQY/RrMe77zjmeQVXnCJ+PyK/Kb3z+ywWCzab jWXLlmX+s9vtmbQIYDxbDf++fBmBRqPxkovqfF2TyYRGo7l6cKrB9vl4RF6etjVQUWshFh5B NNpAiWF1FrCweRkfv/UaUjKNzS4yq6aM4pIFWIwGtIqMmk6ipBKQinMqXkhaipA8+THO+lsZ C0YwZZsQ9VpiwyGio2HstspvrCIcGhri0KFDl30e+7Jg2bRpE9nZ2ef0NTU1ZYqGgoICDhw4 wNq1axkYGJhyvq1bt7J9+3aAyzqy1NXVkZeXR09PD62trfh8vqsHlx7ZtV0/Y9k/HT4xxorv 3gAooCRRZQmSKWaUVXL9zSoGvZbs7Cw0chpVllBSCWQpiSonEWSJlKwQCkVwdrxIrlGg42SM hsZ8YmMiyaRMJCZjchrIzbF9bWB1dXWsWLGC1tZWvF4vCxcuxOPxMDw8jCAIU67ku+++G5/P x7Fjx8jJycFkMjE+Pp7pi0ajbN68GYCGhgYGBwcvOlc0GsXpdHL06FESiQRNTU0sWbIEm+2r n+3hhx/m+eefZ9euXZSUlGTS7BRyesrXOoKgMxmsf9V5/bW5le+92oi1ZAEIIqQSqKk4aiqJ hjRqKomaSqCmJdS0BLKEmk5CWkKVU2iUNHI8xCtv/JJ//WAOWU1rKS4QaN/TD6qKIhgpNA7w 78/eQlFR0QUWRiIRvF4vLpcrc6YKBoP4/X7Ky8uxWq14vV4ikUjm7OT3+wkGg+h0OvLy8kgm k7hcLqLRKH19fRm9rq4urFYr5eXlyLKMz+cjEokgiiKyLGOz2SgqKkKWZYaHhzOOzM7OxuVy IUnSBbadPn0aWZYzP4fDQUFBAVqt9hw7L/Zc8Xgcn8+HJEmYTCbi8ThFRUU4HI7z3fJWVVXV XVO+jzMYFv+j0dT43E9Xn2bVd/KYVTMfW24lOlMuoD2TDqUYpJKocuoMNFk625YgnUKryoyN DfHpwVM88KKA7F6KHB5E5yhEiYXRW5wsyD3Jc//8wFXvWf8P5f6qqqr/uGiqPFNxHX5Fb533 t//yVn7Za5sOcX3DCZY2ZrPwmiIqKtw4ckrRGewgqCiqjCKnzkaaBGejL51OkePMIkUZIyNf oFGP4qosIRkdQ68ViPcc5Nrls6ehXb68B2yZco8DUJRYSG+s/Ad75V+2hPrGTL/e3sem7VK6 KG9UVz/3GI3zLJON80qzaqpnkONwotcYEFQBVU6hyEnUdApUBY1Wy76jUVJyAmPoFBOBbKTR PrQGGy7TIIsW3TuN4/LkM+Cl89+ET/npgsFc/SOL/eZ/iwc6RVkeD6dIdENWDSQ67rh9SZM0 OUhFYZxF19iYP7uA4rxcDIKIIKvoNCrDIZlVj3Ry+FgfRq0eEFAUFY1G5WePr+Kuu1d/45fF /0cj7aWqqqq2S1aV51w4x7tfVVR9cVbZyqdS/i+y1WhvP0zsETCYF9Rf05RKz2V0NMTbu4d4 478HmF3azQ0NTuqq8ih02Hhnj4zHN4mAijXLTDwWR5EF6ubnsfzmZdPQLi6X/c3JJT8WEgQh VzSVPWC2LfxRcnQkX06H3wahXUCUABVUVUEmRcoIqWKzXpg9062dueqmuor2IzZD287PMRtE XK4c+n0jKERHUuqxHytq8jfTjL6efOXneYIgZIPQqNXMWIRi0WvJGhbQpQDtGXhnzu6gqkki 8RmuGbULFy74yc6P91li8Tg1sysYGgwRCvtHZU4+oZL4laqq0WnXf8vgzsLTAEawGrWUODXY igVwgGoSQJ9GUWTS4WvraxvmzK74ydatv3MGx8eYW1VNPJHE09/+IQRfgfROVVVD027/A4G7 EKRLFLCZBUwWAfSOHKfjusb5jwiqZs2OnXtRVSVdUVaum4wEg31Dn2+EiQ3ASVVVpWmX/xHB nS/VVQuawiHp/uBYf9RoMMbyc4tnhMLBwGTEtxvYDwRVVVWm3f2/DNzZdGoArIJGQFVUBZCB pKqqyWk3f/PyP3Aj8lnGUUTOAAAAAElFTkSuQmCC --------------020200030900090906000006-- --------------090100060209020200040608-- From rachelpatel@example.org Fri Dec 3 15:11:52 2004 Return-Path: <rachelpatel@example.org> Mailing-List: contact rachelpatel@example.org; run by ezmlm Delivered-To: mailing list rachelpatel@example.org Received: (qmail 58104 invoked by uid 99); 3 Dec 2004 15:11:52 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of rachelpatel@example.org designates 83.161.120.155 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (83.161.120.155) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Dec 2004 07:11:51 -0800 Received: by wproxy.gmail.com with SMTP id 69so153623wra for <rachelpatel@example.org>; Fri, 03 Dec 2004 07:11:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=B2G+o3hE6d5h2rEg7oeNSxfrCWvLzqDprgPucS4rJT/pwak+DAzsc1+ZALpK2g2Xt7yQ5sl3DnYvjfL+WXr1iycMKoDHQC8VTi6cK0hT2CEkU/LG9TSY6x/C5yAsYJLEtd380vo7OCUkahtqm/DIftBQgm1VcTJjPZ+5Dz0aG0o= Received: by 83.161.120.155 with SMTP id g66mr735405wrg; Fri, 03 Dec 2004 07:11:49 -0800 (PST) Received: by 83.161.120.155 with HTTP; Fri, 3 Dec 2004 07:11:49 -0800 (PST) Message-ID: <rachelpatel@example.org> Date: Fri, 3 Dec 2004 08:11:49 -0700 From: Clinton Begin <rachelpatel@example.org> Reply-To: rachelpatel@example.org To: rachelpatel@example.org Subject: Re: CLOB on Oracle Cc: rachelpatel@example.org In-Reply-To: <rachelpatel@example.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <rachelpatel@example.org> X-Virus-Checked: Checked Hi,
{'source': 'Apache Software Foundation Public Mail Archives'}