From dcampbell@example.com Wed Aug 01 08:36:01 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 70735 invoked from network); 1 Aug 2007 08:36:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 08:36:00 -0000 Received: (qmail 37098 invoked by uid 500); 1 Aug 2007 08:35:31 -0000 Delivered-To: dcampbell@example.com Received: (qmail 31866 invoked by uid 500); 1 Aug 2007 08:34:13 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 28233 invoked by uid 99); 1 Aug 2007 08:32:58 -0000 Received: from Unknown (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 01:32:55 -0700 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dcampbell@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO ausmtp05.au.ibm.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 08:32:15 +0000 Received: from d23relay01.au.ibm.com (d23relay01.au.ibm.com [83.161.120.155]) by ausmtp05.au.ibm.com (8.13.8/8.13.8) with ESMTP id l718Wbu73362958 for <dcampbell@example.com>; Wed, 1 Aug 2007 18:32:40 +1000 Received: from d23av01.au.ibm.com (d23av01.au.ibm.com [83.161.120.155]) by d23relay01.au.ibm.com (8.13.8/8.13.8/NCO v8.4) with ESMTP id l718Teqc259116 for <dcampbell@example.com>; Wed, 1 Aug 2007 18:29:40 +1000 Received: from d23av01.au.ibm.com (loopback [83.161.120.155]) by d23av01.au.ibm.com (83.161.120.15560308/8.13.3) with ESMTP id l718UR5f002979 for <dcampbell@example.com>; Wed, 1 Aug 2007 18:30:27 +1000 Received: from d23ml062.in.ibm.com (d23ml062.in.ibm.com [83.161.120.155]) by d23av01.au.ibm.com (83.161.120.15560308/8.12.11) with ESMTP id l718UQ01002969 for <dcampbell@example.com>; Wed, 1 Aug 2007 18:30:27 +1000 In-Reply-To: <dcampbell@example.com> Subject: Re: SQLJ support for iBATIS for Java To: dcampbell@example.com Cc: dcampbell@example.com X-Mailer: Lotus Notes Release 7.0 HF277 June 21, 2006 Message-ID: <dcampbell@example.com> From: Mario Ds Briggs <dcampbell@example.com> Date: Wed, 1 Aug 2007 14:00:48 +0530 X-MIMETrack: Serialize by Router on d23ml062/23/M/IBM(Release 7.0.2HF32 | October 17, 2006) at 01/08/2007 14:00:50 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked by ClamAV on apache.org Hi Clinton, thanks for the positive response. Would sometime next week be a good time for a demo. Let me know your availability. thanks Mario "Clinton Begin" <clinton.begin@gm ail.com> To dcampbell@example.com 31/07/2007 22:35 cc Subject Please respond to Re: SQLJ support for iBATIS for dcampbell@example.com Java .org Sounds interesting. I look forward to seeing the first demo! Clinton On 7/30/07, Mario Ds Briggs <dcampbell@example.com > wrote: Hello, I would like to make contributions to the iBatis Data Mapper for Java, so that it could execute SQL statements using SQLJ also (in addition to JDBC, as is done currently). The primary goal would be for users to be able to use any SQLJ vendor' s implementation (IBM, Oracle, Informix etc) with the Data Mapper. This would enable customers who use SQLJ to be able to use iBatis DataMapper. Parameter and resultset (mapping) handling, cache and all other features would remain unchanged and use the existing code without duplication. SQLJ would be used only to execute the SQL and return resultsets/updatecounts as applicable. The approach would have a tool (contributed to the project) that would generate the SQLJ implementation for the statements in the map xml files, translate and customize it. The runtime would have a sqljExecutor in addition to the existing sqlExecutor (JDBC). Runtime switching between using either SQLJ or JDBC would be possible Looking to take this forward and any feedback. thanks Mario From dcampbell@example.com Wed Aug 01 09:18:12 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 84459 invoked from network); 1 Aug 2007 09:18:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 09:18:02 -0000 Received: (qmail 41521 invoked by uid 500); 1 Aug 2007 09:17:29 -0000 Delivered-To: dcampbell@example.com Received: (qmail 40499 invoked by uid 500); 1 Aug 2007 09:17:26 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 38745 invoked by uid 99); 1 Aug 2007 09:17:12 -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 [83.161.120.155] (HELO dd1314.kasserver.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 02:17:12 -0700 Received: from [83.161.120.155] (i577A649F.versanet.de [83.161.120.155]) by dd1314.kasserver.com (Postfix) with ESMTP id C73E97F9C7 for <dcampbell@example.com>; Wed, 1 Aug 2007 11:16:11 +0200 (CEST) Message-ID: <dcampbell@example.com> Date: Wed, 01 Aug 2007 11:16:08 +0200 From: Joachim Rohde <dcampbell@example.com> User-Agent: Thunderbird 83.161.120.155 (Windows/20070716) MIME-Version: 1.0 To: dcampbell@example.com Subject: How to submit a translation of the tutorials on the iBATIS website Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hello, could someone tell me who's responsible for maintaining the iBATIS website? I've translated the 'SQL Maps for Java, Tutorial' to german and tried to sent it (twice) to Clinton Begin, but didn't get any answer. So, who else can I contact regarding this issue? Or have I miss something important for submitting translations? Regards, Joachim PS: I hope it is not completly wrong to ask this question on the developer list, but I really don't know, where to ask else. From dcampbell@example.com Wed Aug 01 12:09:43 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 59373 invoked from network); 1 Aug 2007 12:09:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 12:09:43 -0000 Received: (qmail 22746 invoked by uid 500); 1 Aug 2007 12:09:42 -0000 Delivered-To: dcampbell@example.com Received: (qmail 22732 invoked by uid 500); 1 Aug 2007 12:09:42 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 22721 invoked by uid 99); 1 Aug 2007 12:09:42 -0000 Received: from Unknown (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 05:09:42 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dcampbell@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0910.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 12:09:33 +0000 Received: by rv-out-0910.google.com with SMTP id c27so123573rvf for <dcampbell@example.com>; Wed, 01 Aug 2007 05:09:18 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=OWk11dC4N0lKi+FPWbSTc2Qvoysyr1th+HbLwCRSWrZN/o69MtU2f5hro8QmFj3VqvQURpbTuJvovjTDUMhwIWD9MDYwYzBxevmD9v2s+p4lsWr0Iau7z8HZZ0CKpTR/fuT1aYJzaFhbzR+UapIzoit9AS+pTfea3MT2H+j7g4A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=pye9MsFH2kxYB95adYvyxdoVV6fJKbpSl7W4vUznqaqUebWDvUJoOjRdVOjKWhGEcbHf4CwgLzdsAmGy3uw1i/Ay7jRDGKZizJVlCbfhxoLP10noNRzGf9kQqCFhnRNqp7pe9gE+HFPhOXBJNbnRUbK95uCLx25q1qXh4UEqicg= Received: by 83.161.120.155 with SMTP id a1mr649632wac.1185970158117; Wed, 01 Aug 2007 05:09:18 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Wed, 1 Aug 2007 05:09:18 -0700 (PDT) Message-ID: <dcampbell@example.com> Date: Wed, 1 Aug 2007 07:09:18 -0500 From: "Jeff Butler" <dcampbell@example.com> To: dcampbell@example.com Subject: Re: How to submit a translation of the tutorials on the iBATIS website In-Reply-To: <dcampbell@example.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_48534_21003505.1185970158092" References: <dcampbell@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_48534_21003505.1185970158092 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Open a JIRA ticket for this and attach the translated document. Thanks for the contribution! Jeff Butler On 8/1/07, Joachim Rohde <dcampbell@example.com> wrote: > > Hello, > > could someone tell me who's responsible for maintaining the iBATIS > website? I've translated the 'SQL Maps for Java, Tutorial' to german and > tried to sent it (twice) to Clinton Begin, but didn't get any answer. > So, who else can I contact regarding this issue? Or have I miss > something important for submitting translations? > > Regards, > Joachim > > PS: I hope it is not completly wrong to ask this question on the > developer list, but I really don't know, where to ask else. > ------=_Part_48534_21003505.1185970158092 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <div>Open a JIRA ticket for this and attach the translated document.</div> <div>&nbsp;</div> <div>Thanks for the contribution!</div> <div>&nbsp;</div> <div>Jeff Butler</div> <div><br><br>&nbsp;</div> <div><span class="gmail_quote">On 8/1/07, <b class="gmail_sendername">Joachim Rohde</b> &lt;<a href="mailto:dcampbell@example.com">dcampbell@example.com</a>&gt; wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello,<br><br>could someone tell me who&#39;s responsible for maintaining the iBATIS<br>website? I&#39;ve translated the &#39;SQL Maps for Java, Tutorial&#39; to german and <br>tried to sent it (twice) to Clinton Begin, but didn&#39;t get any answer.<br>So, who else can I contact regarding this issue? Or have I miss<br>something important for submitting translations?<br><br>Regards,<br>Joachim <br><br>PS: I hope it is not completly wrong to ask this question on the<br>developer list, but I really don&#39;t know, where to ask else.<br></blockquote></div><br> ------=_Part_48534_21003505.1185970158092-- From dcampbell@example.com Wed Aug 01 16:28:32 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 70887 invoked from network); 1 Aug 2007 16:28:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 16:28:30 -0000 Received: (qmail 75736 invoked by uid 500); 1 Aug 2007 16:28:28 -0000 Delivered-To: dcampbell@example.com Received: (qmail 75542 invoked by uid 500); 1 Aug 2007 16:28:27 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 75371 invoked by uid 99); 1 Aug 2007 16:28:26 -0000 Received: from Unknown (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 09:28:26 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dcampbell@example.com designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO rv-out-0910.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 16:28:14 +0000 Received: by rv-out-0910.google.com with SMTP id c27so166613rvf for <dcampbell@example.com>; Wed, 01 Aug 2007 09:27:59 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=h3d0AHBtZyfkJ4s/7eYx/JkFs4+zkoNENNlA/aCMgzAUPcHeeaR3YCQXfStnibD+wPqbAzZG/AICTGRlguFW6ffMUucfiGSvVDs9gRkef89vOXHFIz+bulAgqnHgvK+hkCWy5nodzFEiGGR3wJmBuICKbB3D6ROgWZUomNxtAGQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Iu9lJnVujFHfjD7D+HHnvfcx/UdI7fc0kVW1S97d6KWB7gb+RuW4UTKbx7arzIcHQKsLS/UgDFylKJ10pSLi4DApPztWxIMfQT//NH5IklVvaT2vWCFq9+GusL5S4YoBIk5CTQmb5kNzi7A+2yII/ulH8gEPM4mf72rCR5xoEJw= Received: by 83.161.120.155 with SMTP id v16mr861404wal.1185985676308; Wed, 01 Aug 2007 09:27:56 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Wed, 1 Aug 2007 09:27:56 -0700 (PDT) Message-ID: <dcampbell@example.com> Date: Wed, 1 Aug 2007 10:27:56 -0600 From: "Clinton Begin" <dcampbell@example.com> To: dcampbell@example.com Subject: Re: How to submit a translation of the tutorials on the iBATIS website In-Reply-To: <dcampbell@example.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_52485_17910729.1185985676265" References: <dcampbell@example.com> <dcampbell@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_52485_17910729.1185985676265 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry Joachim, I do have your emails, I even starred one of them in GMail for reply....but as you've discovered, emailing the list always yields a faster response.... :-) Clinton On 8/1/07, Jeff Butler <dcampbell@example.com> wrote: > > Open a JIRA ticket for this and attach the translated document. > > Thanks for the contribution! > > Jeff Butler > > > > On 8/1/07, Joachim Rohde <dcampbell@example.com> wrote: > > > > Hello, > > > > could someone tell me who's responsible for maintaining the iBATIS > > website? I've translated the 'SQL Maps for Java, Tutorial' to german and > > > > tried to sent it (twice) to Clinton Begin, but didn't get any answer. > > So, who else can I contact regarding this issue? Or have I miss > > something important for submitting translations? > > > > Regards, > > Joachim > > > > PS: I hope it is not completly wrong to ask this question on the > > developer list, but I really don't know, where to ask else. > > > > ------=_Part_52485_17910729.1185985676265 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry Joachim, I do have your emails, I even starred one of them in GMail for reply....but as you&#39;ve discovered, emailing the list always yields a faster response.... :-)<br><br>Clinton<br><br><div><span class="gmail_quote"> On 8/1/07, <b class="gmail_sendername">Jeff Butler</b> &lt;<a href="mailto:dcampbell@example.com">dcampbell@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div>Open a JIRA ticket for this and attach the translated document.</div> <div>&nbsp;</div> <div>Thanks for the contribution!</div><span class="sg"> <div>&nbsp;</div> <div>Jeff Butler</div></span><div><span class="e" id="q_1142154dad1a2ee0_2"> <div><br><br>&nbsp;</div> <div><span class="gmail_quote">On 8/1/07, <b class="gmail_sendername">Joachim Rohde</b> &lt;<a href="mailto:dcampbell@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">dcampbell@example.com </a>&gt; wrote:</span> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">Hello,<br><br>could someone tell me who&#39;s responsible for maintaining the iBATIS<br>website? I&#39;ve translated the &#39;SQL Maps for Java, Tutorial&#39; to german and <br>tried to sent it (twice) to Clinton Begin, but didn&#39;t get any answer.<br>So, who else can I contact regarding this issue? Or have I miss<br>something important for submitting translations?<br><br>Regards,<br>Joachim <br><br>PS: I hope it is not completly wrong to ask this question on the<br>developer list, but I really don&#39;t know, where to ask else.<br></blockquote></div><br> </span></div></blockquote></div><br> ------=_Part_52485_17910729.1185985676265-- From dcampbell@example.com Wed Aug 01 19:54:16 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 60189 invoked from network); 1 Aug 2007 19:54:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 19:54:15 -0000 Received: (qmail 66036 invoked by uid 500); 1 Aug 2007 19:54:15 -0000 Delivered-To: dcampbell@example.com Received: (qmail 66019 invoked by uid 500); 1 Aug 2007 19:54:15 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 66003 invoked by uid 99); 1 Aug 2007 19:54:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 12:54:15 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 19:53:51 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 0E3BA71403F for <dcampbell@example.com>; Wed, 1 Aug 2007 12:53:53 -0700 (PDT) Message-ID: <3745671.1185998033055.JavaMail.jira@brutus> Date: Wed, 1 Aug 2007 12:53:53 -0700 (PDT) From: "Joachim Rohde (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Created: (IBATIS-448) German translation of the 'SQL Maps for Java, Tutorial' MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org German translation of the 'SQL Maps for Java, Tutorial' ------------------------------------------------------- Key: IBATIS-448 URL: https://issues.apache.org/jira/browse/IBATIS-448 Project: iBatis for Java Issue Type: Improvement Reporter: Joachim Rohde -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From dcampbell@example.com Wed Aug 01 20:11:49 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 63842 invoked from network); 1 Aug 2007 20:11:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 1 Aug 2007 20:11:48 -0000 Received: (qmail 30857 invoked by uid 500); 1 Aug 2007 20:11:47 -0000 Delivered-To: dcampbell@example.com Received: (qmail 30834 invoked by uid 500); 1 Aug 2007 20:11:47 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 30813 invoked by uid 99); 1 Aug 2007 20:11:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 13:11:47 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO dd1314.kasserver.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Aug 2007 20:11:07 +0000 Received: from [83.161.120.155] (i577A701E.versanet.de [83.161.120.155]) by dd1314.kasserver.com (Postfix) with ESMTP id 35AD8C51EA for <dcampbell@example.com>; Wed, 1 Aug 2007 22:10:58 +0200 (CEST) Message-ID: <dcampbell@example.com> Date: Wed, 01 Aug 2007 22:10:54 +0200 From: Joachim Rohde <dcampbell@example.com> User-Agent: Thunderbird 83.161.120.155 (Windows/20070716) MIME-Version: 1.0 To: dcampbell@example.com Subject: Re: How to submit a translation of the tutorials on the iBATIS website References: <dcampbell@example.com> <dcampbell@example.com> <dcampbell@example.com> In-Reply-To: <dcampbell@example.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Thanks for the replies. I just read Clintons answer right now after I opened a JIRA ticket. And indeed, the list is faster ;-) Joachim Clinton Begin schrieb: > Sorry Joachim, I do have your emails, I even starred one of them in > GMail for reply....but as you've discovered, emailing the list always > yields a faster response.... :-) > > Clinton > > On 8/1/07, *Jeff Butler* <dcampbell@example.com > <mailto:dcampbell@example.com>> wrote: > > Open a JIRA ticket for this and attach the translated document. > > Thanks for the contribution! > > Jeff Butler > > > > On 8/1/07, *Joachim Rohde* <dcampbell@example.com > <mailto:dcampbell@example.com>> wrote: > > Hello, > > could someone tell me who's responsible for maintaining the iBATIS > website? I've translated the 'SQL Maps for Java, Tutorial' to > german and > tried to sent it (twice) to Clinton Begin, but didn't get any > answer. > So, who else can I contact regarding this issue? Or have I miss > something important for submitting translations? > > Regards, > Joachim > > PS: I hope it is not completly wrong to ask this question on the > developer list, but I really don't know, where to ask else. > > > From dcampbell@example.com Sun Aug 12 16:16:08 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 70205 invoked from network); 12 Aug 2007 16:16:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 12 Aug 2007 16:16:07 -0000 Received: (qmail 27098 invoked by uid 500); 12 Aug 2007 16:16:05 -0000 Delivered-To: dcampbell@example.com Received: (qmail 27082 invoked by uid 500); 12 Aug 2007 16:16:05 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 27071 invoked by uid 99); 12 Aug 2007 16:16:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 12 Aug 2007 09:16:05 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 12 Aug 2007 16:16:13 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 3F73A71418F for <dcampbell@example.com>; Sun, 12 Aug 2007 09:15:43 -0700 (PDT) Message-ID: <10057453.1186935343241.JavaMail.jira@brutus> Date: Sun, 12 Aug 2007 09:15:43 -0700 (PDT) From: "Anton Rothenbacher (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Created: (IBATIS-449) Is there a way to specify a timeout for Pool.PingQuery when using a jdbc SimpleDataSource? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Is there a way to specify a timeout for Pool.PingQuery when using a jdbc SimpleDataSource? ------------------------------------------------------------------------------------------ Key: IBATIS-449 URL: https://issues.apache.org/jira/browse/IBATIS-449 Project: iBatis for Java Issue Type: Improvement Environment: Red Hat Enterprise Linux 4 Update 5 x86-64, JBOSS 4.0.5 Reporter: Anton Rothenbacher Priority: Critical It seems there is no way to specify a timeout when implementing the Pool.PingQuery to test pooled connections before use. We are in an environment that is closing connections on us and when the app is inactive for a long time, the first connection to be tested out of the pool is bad, and it takes 15 minutes before the connection is deemed bad and the connection recycled. 2007-08-11 06:38:14,032 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] Checked out connection 2865240 from pool. 2007-08-11 06:38:14,032 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] Testing connection 2865240 ... ..... 2007-08-11 06:53:40,695 WARN [com.ibatis.common.jdbc.SimpleDataSource] Execution of ping query 'select 1 from DUAL' failed: Io exception: Connection timed out 2007-08-11 06:53:40,695 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] Connection 2865240 is BAD: Io exception: Connection timed out 2007-08-11 06:53:40,696 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] A bad connection (2865240) was returned from the pool, getting another connection. 2007-08-11 06:53:40,750 DEBUG [com.ibatis.common.jdbc.SimpleDataSource] Created connection 10545003. This is a problem since the app hangs for the time when it is waiting for the connection. We are looking for a way to speed up the PingQuery test so that if it does not respond in x seconds, (it is a very fast query) then recycle the connection right away, not 15min later when the connection times out. Here is the relevent section from our SqlMapConfig.xml <!-- Configure a datasource to use with this SQL Map using SimpleDataSource. Notice the use of the properties from the above resource --> <transactionManager type="JDBC" commitRequired="true"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="${driver}"/> <property name="JDBC.ConnectionURL" value="${url}"/> <property name="JDBC.Username" value="${username}"/> <property name="JDBC.Password" value="${password}"/> <property name="JDBC.DefaultAutoCommit" value="${jdbc.default.auto.commit}" /> <property name="Pool.MaximumActiveConnections" value="${pool.maximum.active.connections}"/> <property name="Pool.MaximumIdleConnections" value="${pool.maximum.idle.connections}"/> <property name="Pool.MaximumCheckoutTime" value="${pool.maximum.checkout.time}"/> <property name="Pool.TimeToWait" value="${pool.time.to.wait}"/> <property name="Pool.PingQuery" value="select 1 from DUAL"/> <property name="Pool.PingEnabled" value="true"/> <property name="Pool.PingConnectionsOlderThan" value="1"/> <property name="Pool.PingConnectionsNotUsedFor" value="1"/> </dataSource> </transactionManager> Is DBCP type connection better for what we wish to accomplish? It seems it can test connections idle connections out of the pool on a regular basis but as far as I can tell SimpleDataSource can only test connections as they are requested out of the pool. Am I correct, does anyone have any suggestions? Thanks much for your time! -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From dcampbell@example.com Wed Aug 15 18:19:58 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 56119 invoked from network); 15 Aug 2007 18:19:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 15 Aug 2007 18:19:57 -0000 Received: (qmail 91932 invoked by uid 500); 15 Aug 2007 18:19:55 -0000 Delivered-To: dcampbell@example.com Received: (qmail 91907 invoked by uid 500); 15 Aug 2007 18:19:55 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 91896 invoked by uid 99); 15 Aug 2007 18:19:54 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2007 11:19:54 -0700 X-ASF-Spam-Status: No, hits=3.2 required=10.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [83.161.120.155] (HELO nf-out-0910.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2007 18:20:07 +0000 Received: by nf-out-0910.google.com with SMTP id 4so2745nfv for <dcampbell@example.com>; Wed, 15 Aug 2007 11:19:27 -0700 (PDT) Received: by 83.161.120.155 with SMTP id 11mr583185fgz.1187201966933; Wed, 15 Aug 2007 11:19:26 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Wed, 15 Aug 2007 11:19:26 -0700 (PDT) Message-ID: <dcampbell@example.com> Date: Wed, 15 Aug 2007 14:19:26 -0400 From: "Christopher DeGuise" <dcampbell@example.com> To: dcampbell@example.com Subject: PATCH: Re: Possible bug in CacheModel with QueryForObject<T> In-Reply-To: <dcampbell@example.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_32796_29372868.1187201966904" References: <dcampbell@example.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_32796_29372868.1187201966904 Content-Type: multipart/alternative; boundary="----=_Part_32797_17004090.1187201966904" ------=_Part_32797_17004090.1187201966904 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi All, I had sent this to the .NET iBatis users list but for completeness I thought would send it out on the developer list where a patch should probably have been sent to in the first place. I am currently maintaining my own version of iBatis so I am eager to have this patch reviewed and committed. ---- I just ran in to this issue and I could not find any responses to the original poster. I created a fix that that solves the problem to the best of my testing ability and have included the patch here. The root problem is that the second time the query is executed the result is retrieved from the cache. The cache assumes that a cast to the desired type would be successful. Thanks, Christopher DeGuise Pragmatic Technologies, Inc. On 6/14/07, Kenneth Olsen <dcampbell@example.com> wrote: > > I may have found a bug in iBatis 1.6 (latest) with caching. > > > > Got a map with this: > > > > < cacheModels> > > < cacheModel id= " cacheUser" implementation =" LRU" > > > < flushInterval hours= "24 "/> > > < flushOnExecute statement= "stiInsertUser "/> > > </ cacheModel> > > </ cacheModels> > > > > And a SELECT statement with this: > > > > < select id= "stsGetOnEmail " parameterClass= "System.String " resultMap=" > resUser " cacheModel= " cacheUser" > > > SELECT * FROM users WHERE Email = #value# > > </ select> > > > > > > In code I use: > > > > User _user = i.QueryForObject< User>( "stsGetOnEmail", email); > > > > When doing this, the error strikes: > > - I pass "1" as parameter in email, which will return NULL from db > > - I pass "1" again as parameter in email, which and the error pops up with: > Unable to cast object of type 'System.Object' to type 'Domain.User'. > > > > I suspect, it caches something the first time? But how if the returned > object is NULL? > > > > Log: > > > > 2007-06-13 22:36 :48,091 Adding file [SqlMap.config] to list of watched > files. > 2007-06-13 22:36:48,404 Statement Id: [stsGet] Prepared SQL: > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE UserID = ?param0] > 2007-06-13 22:36:48,419 Statement Id: [stsGetIDAndEmail] Prepared SQL: > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE Email = ?param0 AND UserID = ?param1] > 2007-06-13 22:36:48,419 Statement Id: [stsGetOnEmail] Prepared SQL: > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE Email = ?param0] > 2007-06-13 22:36 :48,419 Statement Id: [stsGetPicture] Prepared SQL: > [SELECT Picture, PictureContentType, PictureFilename FROM users WHERE > UserID = ?param0] > 2007-06-13 22:36:48,435 Statement Id: [stiInsertUser] Prepared SQL: > [INSERT INTO users (Firstname, Lastname, City, Description, Email, > Password, Salt, Company, Question, Answer, LastLoginDate, Status, > PictureContentType, PictureFilename, Picture, CreatedDate, UpdatedDate) > VALUES ( ?param0 , ?param1 , ?param2 , ?param3 , ?param4 ,AES_ENCRYPT( > ?param5 , ?param6 ), ?param6 , ?param7 , ?param8 , ?param9 , ?param10 , > ?param11 , ?param12 , ?param13 , ?param14 , ?param15 , ?param16 )] > 2007-06-13 22:36 :48,435 Statement Id: [stiInsertUser.SelectKey] Prepared > SQL: [SELECT LAST_INSERT_ID() AS value] > 2007-06-13 22:36 :48,435 Statement Id: [stuUpdateLoginAttempts] Prepared > SQL: [UPDATE users SET LoginAttempts = ?param0 , Status = ?param1 , > UpdatedDate = ?param2 WHERE UserID = ?param3] > 2007-06-13 22:36 :48,435 Statement Id: [stuUpdateLastLoginDate] Prepared > SQL: [UPDATE users SET LastLoginDate = ?param0 WHERE UserID = ?param1] > 2007-06-13 22:36 :48,435 Statement Id: [stuActivateUser] Prepared SQL: > [UPDATE users SET Status = ?param0 , UpdatedDate = ?param1 WHERE UserID= ?param2 AND Email = ?param3 AND Status = 2] > 2007-06-13 22:36 :48,451 Registering trigger statement [stiInsertUser] to > cache model [User.cacheUser] > 2007-06-13 22:36:48,498 Statement Id: [stsGetOnEmail] PreparedStatement : > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE Email = ?param0] > 2007-06-13 22:36 :48,513 Statement Id: [stsGetOnEmail] Parameters: [ > ?param0=[value,1]] > 2007-06-13 22:36 :48,513 Statement Id: [stsGetOnEmail] Types: [?param0=[String, > System.String]] > 2007-06-13 22:36 :48,529 Cache miss using key '595483856|-9223372036473027192' > > 2007-06-13 22:36 :48,732 Open Connection "15361084" to "MySQL, MySQLprovider > 83.161.120.155". > 2007-06-13 22:36 :48,748 Cache object 'System.Object' using key > '595483856|-9223372036473027192' > 2007-06-13 22:36 :48,763 Close Connection "15361084" to "MySQL, MySQLprovider > 83.161.120.155". > 2007-06-13 22:36:48,763 Statement Id: [stsGetOnEmail] PreparedStatement : > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE Email = ?param0] > 2007-06-13 22:36 :48,763 Statement Id: [stsGetOnEmail] Parameters: [ > ?param0=[value,1]] > 2007-06-13 22:36 :48,763 Statement Id: [stsGetOnEmail] Types: [?param0=[String, > System.String]] > 2007-06-13 22:36:48,763 Retrieved cached object 'System.Object' using key > '595483856|-9223372036473027192' > 2007-06-13 22:36:50,591 Statement Id: [stsGetOnEmail] PreparedStatement : > [SELECT UserID, Firstname, Lastname, City, Description, Email, > AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, > LoginAttempts, LastLoginDate, Status, CreatedDate, UpdatedDate FROM > users WHERE Email = ?param0] > 2007-06-13 22:36 :50,591 Statement Id: [stsGetOnEmail] Parameters: [ > ?param0=[value,1]] > 2007-06-13 22:36 :50,591 Statement Id: [stsGetOnEmail] Types: [?param0=[String, > System.String]] > 2007-06-13 22:36 :50,591 Retrieved cached object 'System.Object' using key > '595483856|-9223372036473027192' > > > > > > Mvh Kenneth Olsen > > > ------=_Part_32797_17004090.1187201966904 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <span class="gmail_quote"></span>Hi All,<br><br>I had sent this to the .NET iBatis users list but for completeness I thought would send it out on the developer list where a patch should probably have been sent to in the first place. I am currently maintaining my own version of iBatis so I am eager to have this patch reviewed and committed. <br>----<br>I just ran in to this issue and I could not find any responses to the original poster. I created a fix that that solves the problem to the best of my testing ability and have included the patch here. The root problem is that the second time the query is executed the result is retrieved from the cache. The cache assumes that a cast to the desired type would be successful. <br><br>Thanks,<br>Christopher DeGuise<br>Pragmatic Technologies, Inc.<br><br><div><span class="gmail_quote"> On 6/14/07, <b class="gmail_sendername">Kenneth Olsen</b> &lt;<a href="mailto:dcampbell@example.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">dcampbell@example.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div link="blue" vlink="purple" lang="DA"> <div> <p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">I may have found a <span name="st">bug</span> <span name="st">in</span> <span>iBatis</span> 1.6 (latest) <span name="st">with</span> caching.</span></font><span lang="EN-GB"></span></p> <p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB">&nbsp;</span></font></p> <p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">Got a map <span name="st">with</span> this:</span></font><span lang="EN-GB"></span></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&nbsp; </span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&lt;</span></font><span><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> cacheModels</span></font></span></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> <span name="st">cacheModel</span></span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><font color="red" face="Arial" size="2"> <span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB">id</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font> <font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> cacheUser</span></font></span><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB">implementation</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> =</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> LRU</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> &gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> flushInterval</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> hours</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">24</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">/&gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> flushOnExecute</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> statement</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">stiInsertUser</span></font></span><font color="black" face="Arial" size="2"> <span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">/&gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;/</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> <span name="st">cacheModel</span></span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;/</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> cacheModels</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&gt; </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">And a SELECT statement <span name="st">with</span> this: </span></font><span lang="EN-GB"></span></p> <p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">&lt;</span></font><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> select</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> id</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">stsGetOnEmail</span></font></span><font color="black" face="Arial" size="2"> <span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><span><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> parameterClass</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">System.String</span></font></span><font color="black" face="Arial" size="2"> <span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><span><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> resultMap</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">resUser</span></font></span><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> &quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font><span><font color="red" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: red;" lang="EN-GB"> <span name="st">cacheModel</span></span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB">=</span></font><font color="black" face="Arial" size="2"> <span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> cacheUser</span></font></span><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&quot;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> &gt;</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> </span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">SELECT&nbsp;</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> *</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> FROM users WHERE Email = #value#</span></font><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;" lang="EN-GB"> </span></font></p> <p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;">&lt;/</span></font><span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);"> select</span></font></span><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: blue;">&gt;</span></font></p> <p><font color="blue" face="Verdana" size="3"><span style="font-size: 12pt; font-family: Verdana; color: blue;">&nbsp;</span></font></p> <p><font color="blue" face="Verdana" size="3"><span style="font-size: 12pt; font-family: Verdana; color: blue;">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"><span name="st">In</span> code I use:</span></font><font color="blue" face="Verdana"><span style="font-family: Verdana; color: blue;" lang="EN-GB"></span></font></p> <p><font color="blue" face="Verdana" size="3"><span style="font-size: 12pt; font-family: Verdana; color: blue;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="#2b91af" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(43, 145, 175);" lang="EN-GB">User</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> _user = <span>i.<span name="st">QueryForObject</span></span>&lt;</span></font><font color="#2b91af" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(43, 145, 175);" lang="EN-GB"> User</span></font><span><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">&gt;(</span></font></span><font color="#a31515" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: rgb(163, 21, 21);" lang="EN-GB"> &quot;<span>stsGetOnEmail</span>&quot;</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">, email);</span></font></p> <p><font color="blue" face="Verdana" size="3"><span style="font-size: 12pt; font-family: Verdana; color: blue;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">When doing this, the error strikes:</span></font><font color="blue" face="Verdana"><span style="font-family: Verdana; color: blue;" lang="EN-GB"></span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">- I pass &quot;1&quot; as parameter <span name="st">in</span> email, which will return NULL from db</span></font><font color="blue" face="Verdana"><span style="font-family: Verdana; color: blue;" lang="EN-GB"> </span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">- I pass &quot;1&quot; again as parameter <span name="st">in</span> email, which and the error pops up <span name="st">with</span>: Unable to cast object of type &#39;<span>System.Object</span>&#39; to type &#39;<span>Domain.User</span>&#39;.</span></font><font color="black" face="Arial"><span style="font-family: Arial; color: black;" lang="EN-GB"></span></font></p> <p><font color="black" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: black;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">I suspect<span>,</span> it caches something the first time? But how if the returned object is NULL?</span></font><font color="black" face="Arial"><span style="font-family: Arial; color: black;" lang="EN-GB"></span></font></p> <p><font color="black" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: black;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">Log:</span></font><font color="black" face="Arial"><span style="font-family: Arial; color: black;" lang="EN-GB"> </span></font></p> <p><font color="black" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: black;" lang="EN-GB">&nbsp;</span></font></p> <p><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,091 <span>Adding</span> file [<span>SqlMap.config</span>] to list of watched files.<br> 2007-06-13 22:36:48,404 Statement Id: [<span>stsGet</span>] Prepared SQL: [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE <span>UserID</span> =&nbsp; ?param0]<br> 2007-06-13 22:36:48,419 Statement Id: [<span>stsGetIDAndEmail</span>] Prepared SQL: [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE Email =&nbsp; ?param0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND <span>UserID</span> =&nbsp; ?param1]<br> 2007-06-13 22:36:48,419 Statement Id: [<span>stsGetOnEmail</span>] Prepared SQL: [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE Email =&nbsp; ?param0]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,419 Statement Id: [<span>stsGetPicture</span>] Prepared SQL: [SELECT Picture, <span>PictureContentType</span>, <span>PictureFilename</span> FROM users WHERE <span>UserID</span> <span>=&nbsp; ?</span>param0]<br> 2007-06-13 22:36:48,435 Statement Id: [<span>stiInsertUser</span>] Prepared SQL: [INSERT INTO users (<span>Firstname</span>, <span>Lastname</span>, City, Description, Email, Password, Salt, Company, Question, Answer, <span>LastLoginDate</span>, Status, <span>PictureContentType</span>, <span>PictureFilename</span>, Picture, <span>CreatedDate</span>, <span>UpdatedDate</span>)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ( ?param0 , ?param1 , ?param2 , ?param3 , ?param4 ,AES_ENCRYPT( ?param5 ,&nbsp; ?param6 ), ?param6 , ?param7 , ?param8 , ?param9 , ?param10 , ?param11 , ?param12 , ?param13 , ?param14 , ?param15 , ?param16 )]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,435 Statement Id: [<span>stiInsertUser.SelectKey</span>] Prepared SQL: [SELECT LAST_INSERT_<span>ID(</span>) AS value]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,435 Statement Id: [<span>stuUpdateLoginAttempts</span>] Prepared SQL: [UPDATE users SET <span>LoginAttempts</span> <span>=&nbsp; ?</span>param0 , Status =&nbsp; ?param1 , <span>UpdatedDate</span> =&nbsp; ?param2&nbsp; WHERE <span>UserID</span> =&nbsp; ?param3]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,435 Statement Id: [<span>stuUpdateLastLoginDate</span>] Prepared SQL: [UPDATE users SET <span>LastLoginDate</span> <span>=&nbsp; ?</span>param0&nbsp; WHERE <span>UserID</span> =&nbsp; ?param1]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,435 Statement Id: [<span>stuActivateUser</span>] Prepared SQL: [UPDATE users SET Status <span>=&nbsp; ?</span>param0 , <span>UpdatedDate</span> =&nbsp; ?param1&nbsp; WHERE <span>UserID</span> =&nbsp; ?param2&nbsp; AND Email =&nbsp; ?param3&nbsp; AND Status = 2]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,451 <span>Registering</span> trigger statement [<span>stiInsertUser</span>] to cache model [<span>User.cacheUser</span>]<br> 2007-06-13 22:36:48,498 Statement Id: [<span>stsGetOnEmail</span>] <span>PreparedStatement</span> : [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE Email =&nbsp; ?param0]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,513 Statement Id: [<span>stsGetOnEmail</span>] Parameters: [<span>?param0</span>=[value,1]]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,513 Statement Id: [<span>stsGetOnEmail</span>] Types: [<span>?param0</span>=[String, <span>System.String</span>]]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,529 Cache miss using key &#39;595483856|-<span>9223372036473027192&#39; <br> 2007</span>-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,732 Open Connection &quot;15361084&quot; to &quot;<span>MySQL</span>, <span>MySQL</span> provider <a href="http://83.161.120.155" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">83.161.120.155</a>&quot;.<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,748 Cache object &#39;<span>System.Object</span>&#39; using key &#39;595483856|-<span>9223372036473027192&#39; <br> 2007</span>-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,763 Close Connection &quot;15361084&quot; to &quot;<span>MySQL</span>, <span>MySQL</span> provider <a href="http://83.161.120.155" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">83.161.120.155</a>&quot;.<br> 2007-06-13 22:36:48,763 Statement Id: [<span>stsGetOnEmail</span>] <span>PreparedStatement</span> : [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE Email =&nbsp; ?param0]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,763 Statement Id: [<span>stsGetOnEmail</span>] Parameters: [<span>?param0</span>=[value,1]]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :48,763 Statement Id: [<span>stsGetOnEmail</span>] Types: [<span>?param0</span>=[String, <span>System.String</span>]]<br> 2007-06-13 22:36:48,763 Retrieved cached object &#39;<span>System.Object</span>&#39; using key &#39;595483856|-9223372036473027192&#39; <br> 2007-06-13 22:36:50,591 Statement Id: [<span>stsGetOnEmail</span>] <span>PreparedStatement</span> : [SELECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span>UserID</span>, <span>Firstname</span>, <span>Lastname</span>, City, Description, Email, AES_DECRYPT(Password, Salt) AS Password, Salt, Company, Question, Answer, <span>LoginAttempts</span>, <span>LastLoginDate</span>, Status, <span>CreatedDate</span>, <span>UpdatedDate</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM users WHERE Email =&nbsp; ?param0]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :50,591 Statement Id: [<span>stsGetOnEmail</span>] Parameters: [<span>?param0</span>=[value,1]]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :50,591 Statement Id: [<span>stsGetOnEmail</span>] Types: [<span>?param0</span>=[String, <span>System.String</span>]]<br> 2007-06-13 </span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB">22:36</span></font><font color="black" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: black;" lang="EN-GB"> :50,591 Retrieved cached object &#39;<span>System.Object</span>&#39; using key &#39;595483856|-9223372036473027192&#39; </span></font><font color="black" face="Arial"><span style="font-family: Arial; color: black;" lang="EN-GB"></span></font></p> <p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">&nbsp;</span></font></p> <p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;" lang="EN-GB">&nbsp;</span></font></p> <p><font face="Verdana" size="2"><span style="font-size: 10pt; font-family: Verdana;" lang="EN-GB">Mvh Kenneth Olsen</span></font></p> <p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB">&nbsp;</span></font></p> </div> </div> </blockquote></div><br><br clear="all"> ------=_Part_32797_17004090.1187201966904-- ------=_Part_32796_29372868.1187201966904 Content-Type: application/octet-stream; name=CacheNullCastExpectionFix.patch Content-Transfer-Encoding: base64 X-Attachment-Id: f_f543kmum Content-Disposition: attachment; filename="CacheNullCastExpectionFix.patch" SW5kZXg6IENhY2hpbmdTdGF0ZW1lbnQuY3MNCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT0NCi0tLSBDYWNoaW5nU3RhdGVt ZW50LmNzCShyZXZpc2lvbiA1NjM5MjApDQorKysgQ2FjaGluZ1N0YXRlbWVudC5jcwkod29ya2lu ZyBjb3B5KQ0KQEAgLTQxMCw3ICs0MTAsOCBAQA0KICAgICAgICAgICAgIENhY2hlS2V5IGNhY2hl S2V5ID0gdGhpcy5HZXRDYWNoZUtleShyZXF1ZXN0KTsNCiAgICAgICAgICAgICBjYWNoZUtleS5V cGRhdGUoIkV4ZWN1dGVRdWVyeUZvck9iamVjdCIpOw0KIA0KLSAgICAgICAgICAgIG9iaiA9IChU KXRoaXMuU3RhdGVtZW50LkNhY2hlTW9kZWxbY2FjaGVLZXldOw0KKyAgICAgICAgICAgIGlmICh0 aGlzLlN0YXRlbWVudC5DYWNoZU1vZGVsW2NhY2hlS2V5XSBpcyBUKQ0KKyAgICAgICAgICAgICAg ICBvYmogPSAoVCkgdGhpcy5TdGF0ZW1lbnQuQ2FjaGVNb2RlbFtjYWNoZUtleV07DQogICAgICAg ICAgICAgLy8gY2hlY2sgaWYgdGhpcyBxdWVyeSBoYXMgYWxyZWF5IGJlZW4gcnVuIA0KICAgICAg ICAgICAgIGlmICgob2JqZWN0KW9iaiA9PSBDYWNoZU1vZGVsLk5VTExfT0JKRUNUKQ0KICAgICAg ICAgICAgIHsNCg== ------=_Part_32796_29372868.1187201966904-- From dcampbell@example.com Thu Aug 16 12:31:59 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 65890 invoked from network); 16 Aug 2007 12:31:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 16 Aug 2007 12:31:58 -0000 Received: (qmail 50680 invoked by uid 500); 16 Aug 2007 12:31:55 -0000 Delivered-To: dcampbell@example.com Received: (qmail 50607 invoked by uid 500); 16 Aug 2007 12:31:55 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 50553 invoked by uid 99); 16 Aug 2007 12:31:54 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 05:31:54 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 12:32:13 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 415567141E2 for <dcampbell@example.com>; Thu, 16 Aug 2007 05:31:32 -0700 (PDT) Message-ID: <26697641.1187267492262.JavaMail.jira@brutus> Date: Thu, 16 Aug 2007 05:31:32 -0700 (PDT) From: "Ilya Boyandin (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Created: (IBATIS-450) Nesting resultMap property is not loaded MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Nesting resultMap property is not loaded ---------------------------------------- Key: IBATIS-450 URL: https://issues.apache.org/jira/browse/IBATIS-450 Project: iBatis for Java Issue Type: Bug Components: SQL Maps Affects Versions: 2.3.0 Environment: Spring, Tomcat 6.0, JDK 1.6.0 Reporter: Ilya Boyandin When I call loadDepartmentSemester from the sql-map below the obtained DepartmentSemester has null as its "semester" property value. The funny thing is that if I add any of the ActualSemester properties to semesterResult (see the commented line) without changing anything else then surprisingly the "semester" property of the loaded DepartmentSemester is not null anymore, but is initialized correctly with the corresponding Semester object. <resultMap id="actualSemesterResult" class="org.fhj.joanna.domain.ActualSemester"> <result property="id" column="aks_oid"/> <result property="year" column="aks_jahr"/> <result property="summerSemester" column="is_ss"/> <result property="shouldBeUpToDate" column="muss_gepflegt_sein"/> </resultMap> <resultMap id="numberedSemesterResult" class="org.fhj.joanna.domain.NumberedSemester"> <result property="id" column="vos_oid"/> <result property="number" column="vos_semester"/> </resultMap> <resultMap id="semesterResult" class="org.fhj.joanna.domain.Semester"> <!--result property="actualSemester.id" column="aks_oid"/--> <result property="actualSemester" resultMap="Instructors.actualSemesterResult"/> <result property="numberedSemester" resultMap="Instructors.numberedSemesterResult"/> </resultMap> <resultMap id="departmentSemesterResult" class="org.fhj.joanna.domain.DepartmentSemester"> <result property="semester" resultMap="Instructors.semesterResult" /> <result property="departmentId" column="stg_oid"/> <result property="beginDate" column="sinf_sem_beg"/> <result property="endDate" column="sinf_sem_ende"/> </resultMap> <select id="loadDepartmentSemester" resultMap="departmentSemesterResult"> ... </select> -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From dcampbell@example.com Thu Aug 16 15:42:00 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 5435 invoked from network); 16 Aug 2007 15:41:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 16 Aug 2007 15:41:57 -0000 Received: (qmail 34061 invoked by uid 500); 16 Aug 2007 15:41:52 -0000 Delivered-To: dcampbell@example.com Received: (qmail 34049 invoked by uid 500); 16 Aug 2007 15:41:52 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 34027 invoked by uid 99); 16 Aug 2007 15:41:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 08:41:52 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 15:42:12 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id BE592714204 for <dcampbell@example.com>; Thu, 16 Aug 2007 08:41:30 -0700 (PDT) Message-ID: <6131774.1187278890774.JavaMail.jira@brutus> Date: Thu, 16 Aug 2007 08:41:30 -0700 (PDT) From: "Jeff Butler (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Closed: (IBATIS-450) Nesting resultMap property is not loaded In-Reply-To: <26697641.1187267492262.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeff Butler closed IBATIS-450. ------------------------------ Resolution: Duplicate This is a duplicate of IBATIS-357. I've had a look at it, but this area of the code is a real maze and I haven't taken the time to wade through it. It might require Clinton's expertise. > Nesting resultMap property is not loaded > ---------------------------------------- > > Key: IBATIS-450 > URL: https://issues.apache.org/jira/browse/IBATIS-450 > Project: iBatis for Java > Issue Type: Bug > Components: SQL Maps > Affects Versions: 2.3.0 > Environment: Spring, Tomcat 6.0, JDK 1.6.0 > Reporter: Ilya Boyandin > > When I call loadDepartmentSemester from the sql-map below the obtained DepartmentSemester has null as its "semester" property value. The funny thing is that if I add any of the ActualSemester properties to semesterResult (see the commented line) without changing anything else then surprisingly the "semester" property of the loaded DepartmentSemester is not null anymore, but is initialized correctly with the corresponding Semester object. > <resultMap id="actualSemesterResult" class="org.fhj.joanna.domain.ActualSemester"> > <result property="id" column="aks_oid"/> > <result property="year" column="aks_jahr"/> > <result property="summerSemester" column="is_ss"/> > <result property="shouldBeUpToDate" column="muss_gepflegt_sein"/> > </resultMap> > <resultMap id="numberedSemesterResult" class="org.fhj.joanna.domain.NumberedSemester"> > <result property="id" column="vos_oid"/> > <result property="number" column="vos_semester"/> > </resultMap> > <resultMap id="semesterResult" class="org.fhj.joanna.domain.Semester"> > <!--result property="actualSemester.id" column="aks_oid"/--> > <result property="actualSemester" resultMap="Instructors.actualSemesterResult"/> > <result property="numberedSemester" resultMap="Instructors.numberedSemesterResult"/> > </resultMap> > <resultMap id="departmentSemesterResult" class="org.fhj.joanna.domain.DepartmentSemester"> > <result property="semester" resultMap="Instructors.semesterResult" /> > <result property="departmentId" column="stg_oid"/> > <result property="beginDate" column="sinf_sem_beg"/> > <result property="endDate" column="sinf_sem_ende"/> > </resultMap> > <select id="loadDepartmentSemester" resultMap="departmentSemesterResult"> > ... > </select> -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From dcampbell@example.com Thu Aug 16 15:51:59 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 23775 invoked from network); 16 Aug 2007 15:51:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 16 Aug 2007 15:51:55 -0000 Received: (qmail 59828 invoked by uid 500); 16 Aug 2007 15:51:52 -0000 Delivered-To: dcampbell@example.com Received: (qmail 59801 invoked by uid 500); 16 Aug 2007 15:51:52 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 59664 invoked by uid 99); 16 Aug 2007 15:51:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 08:51:52 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Aug 2007 15:52:12 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id E87FA714204 for <dcampbell@example.com>; Thu, 16 Aug 2007 08:51:30 -0700 (PDT) Message-ID: <10184423.1187279490947.JavaMail.jira@brutus> Date: Thu, 16 Aug 2007 08:51:30 -0700 (PDT) From: "Ilya Boyandin (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Commented: (IBATIS-357) Nested Result Maps Fail if no Simple Properties Specified In-Reply-To: <32168018.1161195934905.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12520277 ] Ilya Boyandin commented on IBATIS-357: -------------------------------------- Take a look also at IBATIS-450 for another sample reproducing the bug. > Nested Result Maps Fail if no Simple Properties Specified > --------------------------------------------------------- > > Key: IBATIS-357 > URL: https://issues.apache.org/jira/browse/IBATIS-357 > Project: iBatis for Java > Issue Type: Bug > Components: SQL Maps > Affects Versions: 2.2.0 > Environment: Any > Reporter: Jeff Butler > Priority: Minor > Attachments: NestedResultMapFailure.jar > > > If a result map only contains properties that refer to other result maps, then the resulting object is never populated. It appers that the resultMap is only properly "executed" if there is at least one simple property/column map. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From dcampbell@example.com Mon Aug 20 14:11:59 2007 Return-Path: <dcampbell@example.com> Delivered-To: dcampbell@example.com Received: (qmail 23898 invoked from network); 20 Aug 2007 14:11:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 20 Aug 2007 14:11:54 -0000 Received: (qmail 59513 invoked by uid 500); 20 Aug 2007 14:11:51 -0000 Delivered-To: dcampbell@example.com Received: (qmail 59502 invoked by uid 500); 20 Aug 2007 14:11:51 -0000 Mailing-List: contact dcampbell@example.com; run by ezmlm Precedence: bulk List-Help: <mailto:dcampbell@example.com> List-Unsubscribe: <mailto:dcampbell@example.com> List-Post: <mailto:dcampbell@example.com> List-Id: <dev.ibatis.apache.org> Reply-To: dcampbell@example.com Delivered-To: mailing list dcampbell@example.com Received: (qmail 59491 invoked by uid 99); 20 Aug 2007 14:11:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Aug 2007 07:11:51 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Aug 2007 14:11:51 +0000 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id C880571420C for <dcampbell@example.com>; Mon, 20 Aug 2007 07:11:30 -0700 (PDT) Message-ID: <21388223.1187619090818.JavaMail.jira@brutus> Date: Mon, 20 Aug 2007 07:11:30 -0700 (PDT) From: "Nicholas Piasecki (JIRA)" <dcampbell@example.com> To: dcampbell@example.com Subject: [jira] Commented: (IBATISNET-232) Nested left joins with group by cause NPE when two subsequent levels have null values In-Reply-To: <18095851.1184831045162.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATISNET-232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12521094
{'source': 'Apache Software Foundation Public Mail Archives'}