From jasonweaver@example.org Wed Jul 04 14:23:35 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 68147 invoked from network); 4 Jul 2007 14:23:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 4 Jul 2007 14:23:33 -0000
Received: (qmail 40554 invoked by uid 500); 4 Jul 2007 14:23:30 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 40459 invoked by uid 500); 4 Jul 2007 14:23:30 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 40402 invoked by uid 99); 4 Jul 2007 14:23:30 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Jul 2007 07:23:30 -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, 04 Jul 2007 07:23:25 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 33708714227
	for <jasonweaver@example.org>; Wed,  4 Jul 2007 07:23:05 -0700 (PDT)
Message-ID: <14512571.1183558985207.JavaMail.jira@brutus>
Date: Wed, 4 Jul 2007 07:23:05 -0700 (PDT)
From: "Enrico (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATIS-445) SqlText    setText function  and tab
 (\t)   character in text definition
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

SqlText    setText function  and tab (\t)   character in text definition
------------------------------------------------------------------------

                 Key: IBATIS-445
                 URL: https://issues.apache.org/jira/browse/IBATIS-445
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.0
         Environment: Z/OS (host platform), IBM DB2 version 7
            Reporter: Enrico
            Priority: Minor


When we have a '\t' character in a query string (reading from configuration file)  the db2 was unabled to cached the preparedStatement Query.
We have resolved this issue rewriting the method setText in class SqlText 

  public void setText(String text) {
    this.text = text.replace('\r', ' ').replace('\n', ' ');
    this.isWhiteSpace = text.trim().length() == 0;
  }

in 

  public void setText(String text) {
    this.text = text.replace('\r', ' ').replace('\n', ' ').replace('\t','');
    this.isWhiteSpace = text.trim().length() == 0;
  }


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Sun Jul 08 05:55:24 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 89451 invoked from network); 8 Jul 2007 05:55:24 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 8 Jul 2007 05:55:24 -0000
Received: (qmail 64022 invoked by uid 500); 8 Jul 2007 05:55:24 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 63976 invoked by uid 500); 8 Jul 2007 05:55:23 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 63956 invoked by uid 99); 8 Jul 2007 05:55:23 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jul 2007 22:55:23 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of jasonweaver@example.org designates 83.161.120.155 as permitted sender)
Received: from [83.161.120.155] (HELO wa-out-1112.google.com) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jul 2007 22:55:18 -0700
Received: by wa-out-1112.google.com with SMTP id j5so1098212wah
        for <jasonweaver@example.org>; Sat, 07 Jul 2007 22:54:56 -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:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=EDoDjawQGuEIx4G6K/zoc3M6FQjTI8FBECBAqMXNke6jFa5XE5Iu1uUr4yOhF8DYt8RcdyXzH4BmYOjsZCaHEi5wr8CkqA53B/G2PaoHS8ZdzugjFZbFEk7cupBBiTSSN0X8EPOgWnOqi353IwkdLdV54gq9Y6PUmhTCA9lqgBU=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=ns+v6bcNUnZM8fHVIE49gAdrVL5LZE3EwJDDp4nG1t+YMUZeTZQUGILAuvoGfxf0D2qNhXesrMfpWppHdPPetGeP2DjDezEmKx+WgIBUVidcxYuYi4uTLg4yBYlOYWg7+nbtsgdOAljH/UnCIuHl9RZzW9TPGnhwEiN+8SU1qrk=
Received: by 83.161.120.155 with SMTP id a1mr2010887waf.1183874095931;
        Sat, 07 Jul 2007 22:54:55 -0700 (PDT)
Received: by 83.161.120.155 with HTTP; Sat, 7 Jul 2007 22:54:55 -0700 (PDT)
Message-ID: <jasonweaver@example.org>
Date: Sat, 7 Jul 2007 23:54:55 -0600
From: "Clinton Begin" <jasonweaver@example.org>
To: jasonweaver@example.org, "iBatis Java Mail List" <jasonweaver@example.org>, 
	jasonweaver@example.org
Subject: iBATIS Survey (10 Minutes)
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Checked: Checked by ClamAV on apache.org

Hi everyone,

I've put together a simple survey to help us set the direction for
future versions of iBATIS.

Please fill it out to ensure that iBATIS remains or becomes the
product you want.

It should only take 10 minutes to fill out.  The results are not
displayed, but I will publish a summary of them when I feel enough
results have been submitted.  So the faster you complete the survey,
the faster you'll get to see the results.

http://codehammer.org:81/survey/show/ibatis

Don't be shy about the email address requirement.  It is simply to
avoid spam, trolling etc.  This is not a 3rd party company running the
survey, "Codehammer" is me just me, so worry not.  We'll only use it
to validate against the list etc.

Best regards,

Clinton

From jasonweaver@example.org Sun Jul 08 23:03:48 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 40670 invoked from network); 8 Jul 2007 23:03:47 -0000
Received: from mail.everlastseawalls.com (HELO everlastseawalls.com) (83.161.120.155)
  by minotaur.apache.org with SMTP; 8 Jul 2007 23:03:47 -0000
Received: from User ([83.161.120.155]) by everlastseawalls.com with Microsoft SMTPSVC(6.0.3790.211);
	 Sun, 8 Jul 2007 15:21:13 -0400
From: "JPMorgan Chase & Co."<jasonweaver@example.org>
Subject: Continuous Monitoring is an intergral part of JPMorgan Chase and Co. multiple layers of security.
Date: Sun, 8 Jul 2007 14:34:42 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1251"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Bcc:
Return-Path: jasonweaver@example.org
Message-ID: <jasonweaver@example.org>
X-OriginalArrivalTime: 08 Jul 2007 19:21:14.0273 (UTC) FILETIME=[26735910:01C7C195]

<html>
<style type="text/css">
<!--
.style1 {font-size: 16px}
-->
</style>

<p class="text2"><img src="http://www.chase.com/ccpmweb/shared/image/chaseNewlogo.gif" width="138" height="27"></p>
<p class="text2"><em><strong>Dear JPMorgan Chase Customer,<br>
</strong></em></p>
<p class="text2">During our regularly scheduled account maintenance and verification procedures, <br>
  we have detected a slight error in your account information. <br>
Please update your account information. </p>
<p class="text2"><strong>Please update and verify your information by checking the link below:</strong><br>

</p>
<p><a href="http://www.president.ps/chaseupdate/" class="style1">https://chaseonline.chase.com/online/update/your-profile/index.php
</a><br>
  <br>
  <br>
© 2007 JPMorgan Chase & Co. All rights reserved. </p>
</html>

From jasonweaver@example.org Mon Jul 09 13:43:02 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 31386 invoked from network); 9 Jul 2007 13:43:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 9 Jul 2007 13:43:01 -0000
Received: (qmail 20327 invoked by uid 500); 9 Jul 2007 13:43:03 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 20300 invoked by uid 500); 9 Jul 2007 13:43:02 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 20285 invoked by uid 99); 9 Jul 2007 13:43:02 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jul 2007 06:43:02 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of jasonweaver@example.org designates 83.161.120.155 as permitted sender)
Received: from [83.161.120.155] (HELO wa-out-1112.google.com) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jul 2007 06:42:59 -0700
Received: by wa-out-1112.google.com with SMTP id j5so1686619wah
        for <jasonweaver@example.org>; Mon, 09 Jul 2007 06:42:38 -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:content-transfer-encoding:content-disposition:references;
        b=AzrHYCHw4QQa+XaxU6m+Y+026E63SDeTlYFdN88YGpfcb3/vCj39IGITt6qZ0PcYCQo5YTf2atAkZLQMip9alCFmbIYmtwE9RgKsAGEOLUviPce2VMKgcg+GLJifNdWEhcbX/RcEV+9k5SV3JheU/dCG+TPzeaKhmZHhV7A7s5s=
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:content-transfer-encoding:content-disposition:references;
        b=E/RCTRBKAQ4+I7Gg3bmaVAZFQUrPcamyiCE17w4FUB4XEkXidLRrUOB+7uQ4qrz5p/h1fWc+JIw5C+Bn8/yTNZ1yQz35FKFp+x7WmxDCIFskgkO9UcvEswSC4K12qftfGlu+iNYFlQ0X7gGgExZavn0C7H901uRMI+ZH7623iaM=
Received: by 83.161.120.155 with SMTP id j1mr3133856wam.1183988558794;
        Mon, 09 Jul 2007 06:42:38 -0700 (PDT)
Received: by 83.161.120.155 with HTTP; Mon, 9 Jul 2007 06:42:38 -0700 (PDT)
Message-ID: <jasonweaver@example.org>
Date: Mon, 9 Jul 2007 07:42:38 -0600
From: "Clinton Begin" <jasonweaver@example.org>
To: jasonweaver@example.org, "iBatis Java Mail List" <jasonweaver@example.org>, 
	jasonweaver@example.org
Subject: Re: iBATIS Survey (10 Minutes)
In-Reply-To: <jasonweaver@example.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <jasonweaver@example.org>
X-Virus-Checked: Checked by ClamAV on apache.org

For everyone looking for multiple checkboxes, even though the survey
software supports it, it will be hard for us to draw conclusions if
everyone selects everything.  :-)

So when answering tough questions where you would normally want to
pick multiple choices, it's important that you pick the "primary" or
"most important" one....

Even though multiple choices apply, one always stands out.  If it
doesn't, then you basically cancel out the survey option and you might
as well randomly choose one (because it would still have more meaning
than choosing multiples).

Cheers,
Clinton


On 7/7/07, Clinton Begin <jasonweaver@example.org> wrote:
> Hi everyone,
>
> I've put together a simple survey to help us set the direction for
> future versions of iBATIS.
>
> Please fill it out to ensure that iBATIS remains or becomes the
> product you want.
>
> It should only take 10 minutes to fill out.  The results are not
> displayed, but I will publish a summary of them when I feel enough
> results have been submitted.  So the faster you complete the survey,
> the faster you'll get to see the results.
>
> http://codehammer.org:81/survey/show/ibatis
>
> Don't be shy about the email address requirement.  It is simply to
> avoid spam, trolling etc.  This is not a 3rd party company running the
> survey, "Codehammer" is me just me, so worry not.  We'll only use it
> to validate against the list etc.
>
> Best regards,
>
> Clinton
>

From jasonweaver@example.org Tue Jul 17 16:41:28 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 96721 invoked from network); 17 Jul 2007 16:41:28 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 17 Jul 2007 16:41:28 -0000
Received: (qmail 26349 invoked by uid 500); 17 Jul 2007 16:41:29 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 26194 invoked by uid 500); 17 Jul 2007 16:41:28 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 26183 invoked by uid 99); 17 Jul 2007 16:41:28 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Jul 2007 09:41:28 -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; Tue, 17 Jul 2007 09:41:25 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id BDECB71418E
	for <jasonweaver@example.org>; Tue, 17 Jul 2007 09:41:04 -0700 (PDT)
Message-ID: <22110090.1184690464774.JavaMail.jira@brutus>
Date: Tue, 17 Jul 2007 09:41:04 -0700 (PDT)
From: "Michael Schall (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-231) sqlServer20005 misspelled in
 providers.config
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

sqlServer20005 misspelled in providers.config
---------------------------------------------

                 Key: IBATISNET-231
                 URL: https://issues.apache.org/jira/browse/IBATISNET-231
             Project: iBatis for .NET
          Issue Type: Bug
          Components: DataMapper
            Reporter: Michael Schall
            Priority: Minor


sqlServer20005 provider name has extra 0

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Wed Jul 18 13:50:48 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 11267 invoked from network); 18 Jul 2007 13:50:44 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 18 Jul 2007 13:50:43 -0000
Received: (qmail 44783 invoked by uid 500); 18 Jul 2007 13:50:29 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 44534 invoked by uid 500); 18 Jul 2007 13:50:29 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 44448 invoked by uid 99); 18 Jul 2007 13:50:27 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Jul 2007 06:50:27 -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, 18 Jul 2007 06:50:24 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 777897141EB
	for <jasonweaver@example.org>; Wed, 18 Jul 2007 06:50:04 -0700 (PDT)
Message-ID: <25978403.1184766604485.JavaMail.jira@brutus>
Date: Wed, 18 Jul 2007 06:50:04 -0700 (PDT)
From: "Mario Briggs (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Commented: (IBATIS-440) Contribute DB2 SQL Schema and Load
 scripts for the shipped JPetstore example application
In-Reply-To: <18497923.1182338906076.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-440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12513571 ] 

Mario Briggs commented on IBATIS-440:
-------------------------------------

Hi Jeff,

I have attached the said items (with license granted)

Assuming they would go into folder  java/jpetstore/jpetstore5/src/ddl/db2/  in the subversion tree

thank you


> Contribute DB2 SQL Schema and Load scripts for the shipped JPetstore example application
> ----------------------------------------------------------------------------------------
>
>                 Key: IBATIS-440
>                 URL: https://issues.apache.org/jira/browse/IBATIS-440
>             Project: iBatis for Java
>          Issue Type: Wish
>         Environment: Usage of JPetstore example application with DB2
>            Reporter: Mario Briggs
>            Priority: Trivial
>         Attachments: jpetstore-db2-dataload.sql, jpetstore-db2-schema.sql
>
>
> I would like to contribute SQL Schema & dataLoad scripts for the
> downloadable JPetstore example application which will work fully with IBM
> DB2 databases. This would help developers who are trying out iBATIS
> DataMapper and want to connect to a DB2 database (free or licensed),  to
> get started quickly and easily.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Thu Jul 19 07:44:59 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 19315 invoked from network); 19 Jul 2007 07:44:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 19 Jul 2007 07:44:54 -0000
Received: (qmail 52993 invoked by uid 500); 19 Jul 2007 07:44:28 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 52922 invoked by uid 500); 19 Jul 2007 07:44:28 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 52891 invoked by uid 99); 19 Jul 2007 07:44:28 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 00:44:28 -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, 19 Jul 2007 00:44:25 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 289527141EF
	for <jasonweaver@example.org>; Thu, 19 Jul 2007 00:44:05 -0700 (PDT)
Message-ID: <18095851.1184831045162.JavaMail.jira@brutus>
Date: Thu, 19 Jul 2007 00:44:05 -0700 (PDT)
From: "Oikonomopoulos Spyros (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-232) Nested left joins with group by
 cause NPE when two subsequent levels have null values
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Nested left joins with group by cause NPE when two subsequent levels have null values
-------------------------------------------------------------------------------------

                 Key: IBATISNET-232
                 URL: https://issues.apache.org/jira/browse/IBATISNET-232
             Project: iBatis for .NET
          Issue Type: Bug
          Components: DataMapper
    Affects Versions: DataMapper 1.6.1
            Reporter: Oikonomopoulos Spyros
         Attachments: DataMapper.MappedStatements.PropertStrategy.GroupByStrategy.patch

Region (region_id, name) values: (1, 'reg1') (2, 'reg2')
State (state_id, region_id, name) values: (1, 1, 'state1')
City (city_id, region_id, state_id, name) values (1,1,1,'city1')

A nested group with left joins will create the following rows:

1 reg1 --- 1 1 state 1 --- 1 1 1 city1
2 reg2 --- null --- null

Now during construction of the object hierarchy iBatis, for the second row  tries to set the "cities" collection of the state object, which unfortunately is null, so an NPE is raised.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Thu Jul 19 16:50:56 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 31633 invoked from network); 19 Jul 2007 16:50:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 19 Jul 2007 16:50:55 -0000
Received: (qmail 78085 invoked by uid 500); 19 Jul 2007 16:50:29 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 78063 invoked by uid 500); 19 Jul 2007 16:50:29 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 78048 invoked by uid 99); 19 Jul 2007 16:50:29 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 09:50:29 -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, 19 Jul 2007 09:50:26 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 37A3871418E
	for <jasonweaver@example.org>; Thu, 19 Jul 2007 09:50:06 -0700 (PDT)
Message-ID: <28777940.1184863806223.JavaMail.jira@brutus>
Date: Thu, 19 Jul 2007 09:50:06 -0700 (PDT)
From: "Max Jonas Werner (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Commented: (IBATIS-436) Defaults for <settings/> element
 aren't applied if it doesn't exist
In-Reply-To: <17088349.1181250806518.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-436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12513942 ] 

Max Jonas Werner commented on IBATIS-436:
-----------------------------------------

Yeah, this bug is really annoying, it really twisted my mind for several hours today.

> Defaults for <settings/> element aren't applied if it doesn't exist
> -------------------------------------------------------------------
>
>                 Key: IBATIS-436
>                 URL: https://issues.apache.org/jira/browse/IBATIS-436
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.0
>         Environment: iBatis 2.3.0, Java 1.5, Spring 2.0.7
>            Reporter: Nilesh Kapadia
>
> If you don't include <settings> element in sqlMapConfig, the defaults (that are described in the documentation) aren't properly applied.  This definitely applies to cacheModelsEnabled setting.  cacheModelsEnabled is false if you don't have a <settings> element, and true if you do.  I have not looked at whether this affects other elements (I'd imagine all booleans that are supposed to default to true are affected).
> The problem appears to be that when the <settings> element doesn't exist, most of the code in addSettingsNodelets() method in SqlMapConfigParser does not execute (the anonymous class and method that implements Nodelet never executes).  It appears that this code is where the defaults are normally applied.
> In SqlMapExecutorDelegate, the isCacheModelsEnabled() method is returning false because the boolean cacheModelsEnabled is never set and thus defaults to false.
> The workaround is of course to include <settings/> in sqlMapConfig.  But most examples out there don't include this element, so there is the possibility that many apps are running with the incorrect defaults.
> I have not checked if this issue exists in previous versions, only jasonweaver@example.org so far.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Thu Jul 19 16:50:57 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 31640 invoked from network); 19 Jul 2007 16:50:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 19 Jul 2007 16:50:55 -0000
Received: (qmail 78096 invoked by uid 500); 19 Jul 2007 16:50:29 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 78072 invoked by uid 500); 19 Jul 2007 16:50:29 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 78059 invoked by uid 99); 19 Jul 2007 16:50:29 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 09:50:29 -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, 19 Jul 2007 09:50:26 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 9EF7B7141F9
	for <jasonweaver@example.org>; Thu, 19 Jul 2007 09:50:06 -0700 (PDT)
Message-ID: <14236399.1184863806642.JavaMail.jira@brutus>
Date: Thu, 19 Jul 2007 09:50:06 -0700 (PDT)
From: "Max Jonas Werner (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Issue Comment Edited: (IBATIS-436) Defaults for <settings/>
 element aren't applied if it doesn't exist
In-Reply-To: <17088349.1181250806518.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-436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12513942 ] 

Max Jonas Werner edited comment on IBATIS-436 at 7/19/07 9:49 AM:
------------------------------------------------------------------

This bug is quite annoying, it really twisted my mind for several hours today.


 was:
Yeah, this bug is really annoying, it really twisted my mind for several hours today.

> Defaults for <settings/> element aren't applied if it doesn't exist
> -------------------------------------------------------------------
>
>                 Key: IBATIS-436
>                 URL: https://issues.apache.org/jira/browse/IBATIS-436
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.0
>         Environment: iBatis 2.3.0, Java 1.5, Spring 2.0.7
>            Reporter: Nilesh Kapadia
>
> If you don't include <settings> element in sqlMapConfig, the defaults (that are described in the documentation) aren't properly applied.  This definitely applies to cacheModelsEnabled setting.  cacheModelsEnabled is false if you don't have a <settings> element, and true if you do.  I have not looked at whether this affects other elements (I'd imagine all booleans that are supposed to default to true are affected).
> The problem appears to be that when the <settings> element doesn't exist, most of the code in addSettingsNodelets() method in SqlMapConfigParser does not execute (the anonymous class and method that implements Nodelet never executes).  It appears that this code is where the defaults are normally applied.
> In SqlMapExecutorDelegate, the isCacheModelsEnabled() method is returning false because the boolean cacheModelsEnabled is never set and thus defaults to false.
> The workaround is of course to include <settings/> in sqlMapConfig.  But most examples out there don't include this element, so there is the possibility that many apps are running with the incorrect defaults.
> I have not checked if this issue exists in previous versions, only jasonweaver@example.org so far.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Mon Jul 23 19:33:32 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 92884 invoked from network); 23 Jul 2007 19:33:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 23 Jul 2007 19:33:02 -0000
Received: (qmail 3389 invoked by uid 500); 23 Jul 2007 19:32:55 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 3293 invoked by uid 500); 23 Jul 2007 19:32:54 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 2984 invoked by uid 99); 23 Jul 2007 19:32:54 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jul 2007 12:32: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; Mon, 23 Jul 2007 12:32:51 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 7A8417141F8
	for <jasonweaver@example.org>; Mon, 23 Jul 2007 12:32:31 -0700 (PDT)
Message-ID: <3924828.1185219151499.JavaMail.jira@brutus>
Date: Mon, 23 Jul 2007 12:32:31 -0700 (PDT)
From: "Michael Schall (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-233) SQLite Provider node uses abandoned
 library. Updated node included
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

SQLite Provider node uses abandoned library. Updated node included
------------------------------------------------------------------

                 Key: IBATISNET-233
                 URL: https://issues.apache.org/jira/browse/IBATISNET-233
             Project: iBatis for .NET
          Issue Type: Improvement
          Components: DataMapper
    Affects Versions: DataMapper 1.6.1
            Reporter: Michael Schall
            Priority: Minor


The svn provider config file references the Finisar.SQLite provider.  This provider is not under active development and it's site points to the System.Data.SQLite provider.  Included is an updated node that seems to work.  It is not fully tested as I only needed dynamic sql, but select, insert, delete dynamic sql statements work great.

  <provider name="SQLite3"
    description="SQLite, SQLite.NET provider V83.161.120.155"
    enabled="true"
    assemblyName="System.Data.SQLite, Version=83.161.120.155, Culture=neutral, PublicKeyToken=db937bc2d44ff139" 
    connectionClass="System.Data.SQLite.SQLiteConnection"
    commandClass="System.Data.SQLite.SQLiteCommand"
    parameterClass="System.Data.SQLite.SQLiteParameter"
    parameterDbTypeClass="System.Data.SQLite.SQLiteType"
    parameterDbTypeProperty="DbType"
    dataAdapterClass="System.Data.SQLite.SQLiteDataAdapter"
    commandBuilderClass="System.Data.SQLite.SQLiteCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix="@"
    setDbParameterPrecision="false"
    setDbParameterScale="false"
    allowMARS="false"
  />

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Wed Jul 25 01:08:53 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 95606 invoked from network); 25 Jul 2007 01:08:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 25 Jul 2007 01:08:52 -0000
Received: (qmail 96668 invoked by uid 500); 25 Jul 2007 01:08:53 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 96516 invoked by uid 500); 25 Jul 2007 01:08:53 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 96505 invoked by uid 99); 25 Jul 2007 01:08:53 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jul 2007 18:08:53 -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; Tue, 24 Jul 2007 18:08:51 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 463-721-4154
	for <jasonweaver@example.org>; Tue, 24 Jul 2007 18:08:31 -0700 (PDT)
Message-ID: <23440944.1185325711069.JavaMail.jira@brutus>
Date: Tue, 24 Jul 2007 18:08:31 -0700 (PDT)
From: =?utf-8?Q?Miika_M=C3=A4kinen_=28JIRA=29?= <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Commented: (IBATISNET-194) Support for non-public
 constructors
In-Reply-To: <30031096.1162595718727.JavaMail.root@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked by ClamAV on apache.org


    [ https://issues.apache.org/jira/browse/IBATISNET-194?page=3Dcom.atlass=
ian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12515130 ]=20

Miika M=C3=A4kinen commented on IBATISNET-194:
-----------------------------------------

I don't see use for *private* but I see very good use for *internal* constr=
uctors. In fact, I was trying to do my DTOs so that I'd have:

internal .ctor(int primaryKeyId){
    _id =3D primaryKeyId;
   _isNew =3D false;
}

public .ctor(){
   _isNew =3D true;
}

and give iBatis access to internals of my DTO dll... now this is not possib=
le.

> Support for non-public constructors
> -----------------------------------
>
>                 Key: IBATISNET-194
>                 URL: https://issues.apache.org/jira/browse/IBATISNET-194
>             Project: iBatis for .NET
>          Issue Type: Improvement
>          Components: DataMapper
>    Affects Versions: DataMapper 1.6
>         Environment: .NET
>            Reporter: Craig Wilson
>            Priority: Minor
>
> It would be nice to support non-public constructors natively rather than =
creating a custom IObjectFactory for "read-only" entities.

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Wed Jul 25 05:31:55 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 66195 invoked from network); 25 Jul 2007 05:31:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 25 Jul 2007 05:31:54 -0000
Received: (qmail 68867 invoked by uid 500); 25 Jul 2007 05:31:55 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 68755 invoked by uid 500); 25 Jul 2007 05:31:55 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 68733 invoked by uid 99); 25 Jul 2007 05:31:54 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jul 2007 22: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; Tue, 24 Jul 2007 22:31:53 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 4952871418E
	for <jasonweaver@example.org>; Tue, 24 Jul 2007 22:31:32 -0700 (PDT)
Message-ID: <21493456.1185341492297.JavaMail.jira@brutus>
Date: Tue, 24 Jul 2007 22:31:32 -0700 (PDT)
From: "Aram Mkhitaryan (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATIS-446) javaType="java.util.Set" is broken for
 results with select attribute when lazy loading is enabled
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

javaType="java.util.Set" is broken for results with select attribute when lazy loading is enabled
-------------------------------------------------------------------------------------------------

                 Key: IBATIS-446
                 URL: https://issues.apache.org/jira/browse/IBATIS-446
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.0
            Reporter: Aram Mkhitaryan


when I map a result to the java.util.Set

<resultMap ...>
    ...
    <result ...
         javaType="java.util.Set" select="findEmployees" /> 
</resultMap> 

I get a lot of trouble because when the lazy loading is enabled the support for Set is broken
when I switch off the lazy loading, everything works great

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Wed Jul 25 05:40:53 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 67177 invoked from network); 25 Jul 2007 05:40:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 25 Jul 2007 05:40:52 -0000
Received: (qmail 96435 invoked by uid 500); 25 Jul 2007 05:40:53 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 96413 invoked by uid 500); 25 Jul 2007 05:40:53 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 96394 invoked by uid 99); 25 Jul 2007 05:40:53 -0000
Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jul 2007 22:40:53 -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; Tue, 24 Jul 2007 22:40:51 -0700
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 357BC71418E
	for <jasonweaver@example.org>; Tue, 24 Jul 2007 22:40:31 -0700 (PDT)
Message-ID: <4593953.1185342031216.JavaMail.jira@brutus>
Date: Tue, 24 Jul 2007 22:40:31 -0700 (PDT)
From: "Aram Mkhitaryan (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATIS-447) type collector definition is needed
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

type collector definition is needed
-----------------------------------

                 Key: IBATIS-447
                 URL: https://issues.apache.org/jira/browse/IBATIS-447
             Project: iBatis for Java
          Issue Type: New Feature
          Components: SQL Maps
    Affects Versions: 2.3.0
            Reporter: Aram Mkhitaryan
            Priority: Critical


I have already posted this feature/improvement in http://opensource.atlassian.com/confluence/oss/display/IBATIS/iBATIS+3.0+Whiteboard?focusedCommentId=9142285#comment-9142285

and initial problem is reported in https://issues.apache.org/jira/browse/IBATIS-446

I think this may/should be available before 3.0 is released!

The Problem:
 Yesterday I was mapping a result to the java.util.Set

<resultMap ...>
    ...
    <result ...
         javaType="java.util.Set" select="findEmployees" /> 
</resultMap> 

and got a lot of trouble because when the lazy loading was enabled the support for Set was broken

Solution:
 and here comes suggestion ...

what if we have a new attribute "collector" or new collector handler mapping tag?

<result ...         
    javaType="java.util.Set" select="findEmployees"
    collector="myEmployeeCollector" />

<collectorHandler javaType="XXX" collector="myCollectorForXXX" />

this collector will be responsible for handling selected objects and putting in the specified javaType object

this approach will make the code work faster, for now, when lazy loading is not enabled,
since the result objects are always collected in java.util.List and then new HashMap(list) is called for type conversion,

as you see/know, that constructor copies values from the list, but if we have collectors for the defined types (like TypeHandler, TypeHandlerCallback) we could add employees even in our domain objects like office.addEmployee(employee) 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Mon Jul 30 21:23:17 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 2671 invoked from network); 30 Jul 2007 21:23:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 30 Jul 2007 21:23:16 -0000
Received: (qmail 48802 invoked by uid 500); 30 Jul 2007 21:23:14 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 48623 invoked by uid 500); 30 Jul 2007 21:23:14 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 48598 invoked by uid 99); 30 Jul 2007 21:23:13 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2007 14:23:13 -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, 30 Jul 2007 21:23:13 +0000
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 13AE17141F6
	for <jasonweaver@example.org>; Mon, 30 Jul 2007 14:22:53 -0700 (PDT)
Message-ID: <15644030.1185830573078.JavaMail.jira@brutus>
Date: Mon, 30 Jul 2007 14:22:53 -0700 (PDT)
From: "Roaan Vos (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-234) typeAlias does not work for
 generics with 2 or more generic parameters
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

typeAlias does not work for generics with 2 or more generic parameters
----------------------------------------------------------------------

                 Key: IBATISNET-234
                 URL: https://issues.apache.org/jira/browse/IBATISNET-234
             Project: iBatis for .NET
          Issue Type: Bug
          Components: DataMapper
    Affects Versions: DataMapper 1.6.1
         Environment: .Net 2
            Reporter: Roaan Vos
            Priority: Minor


The typeresolver does not work with generic types that takes 2 (or more) generic parameters.
The problem lies in the "SplitTypeAndAssemblyNames" method of the "TypeAssemblyInfo" class.

The follow is a fix

================ CUT ==========================
            private void SplitTypeAndAssemblyNames(string originalTypeName)
            {
                if (originalTypeName.StartsWith(TypeAssemblyInfo.NULLABLE_TYPE))
                {
                    int typeAssemblyIndex = originalTypeName.LastIndexOf(TypeAssemblyInfo.NULLABLE_TYPE_ASSEMBLY_SEPARATOR);
                    if (typeAssemblyIndex < 0)
                    {
                        _unresolvedTypeName = originalTypeName;
                    }
                    else
                    {
                        _unresolvedTypeName = originalTypeName.Substring(0, typeAssemblyIndex + 2).Trim();
                        _unresolvedAssemblyName = originalTypeName.Substring(typeAssemblyIndex + 3).Trim();
                    }
                }
                else
                {
                    int typeAssemblyIndex = originalTypeName.LastIndexOf(TYPE_ASSEMBLY_SEPARATOR);
                    if (typeAssemblyIndex < 0)
                    {
                        _unresolvedTypeName = originalTypeName;
                    }
                    else
                    {
                        _unresolvedTypeName = originalTypeName.Substring(0, typeAssemblyIndex).Trim();
                        _unresolvedAssemblyName = originalTypeName.Substring(typeAssemblyIndex + 1).Trim();
                    }
                }
            }
======================= CUT =========================

Note that I changed the ".IndexOf(TYPE_ASSEMBLY_SEPARATOR)" to
".LastIndexOf(TYPE_ASSEMBLY_SEPARATOR)"

Not a brilliant fix, but I think it will do

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Tue Jul 31 05:54:26 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 53247 invoked from network); 31 Jul 2007 05:54:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 31 Jul 2007 05:54:26 -0000
Received: (qmail 24391 invoked by uid 500); 31 Jul 2007 05:54:26 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 24235 invoked by uid 500); 31 Jul 2007 05:54:25 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 24223 invoked by uid 99); 31 Jul 2007 05:54:25 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2007 22:54:25 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of jasonweaver@example.org designates 83.161.120.155 as permitted sender)
Received: from [83.161.120.155] (HELO ausmtp04.au.ibm.com) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 05:54:19 +0000
Received: from d23relay01.au.ibm.com (d23relay01.au.ibm.com [83.161.120.155])
	by ausmtp04.au.ibm.com (8.13.8/8.13.8) with ESMTP id l6V5uJhk133992
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 15:56:20 +1000
Received: from d23av04.au.ibm.com (d23av04.au.ibm.com [83.161.120.155])
	by d23relay01.au.ibm.com (8.13.8/8.13.8/NCO v8.4) with ESMTP id l6V5qnFS253876
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 15:52:49 +1000
Received: from d23av04.au.ibm.com (loopback [83.161.120.155])
	by d23av04.au.ibm.com (83.161.120.15560308/8.13.3) with ESMTP id l6V5rYCJ007380
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 15:53:34 +1000
Received: from d23ml062.in.ibm.com (d23ml062.in.ibm.com [83.161.120.155])
	by d23av04.au.ibm.com (83.161.120.15560308/8.12.11) with ESMTP id l6V5rVbW007295
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 15:53:32 +1000
Subject: SQLJ support for iBATIS for Java
To: jasonweaver@example.org
X-Mailer: Lotus Notes Release 7.0 HF277 June 21, 2006
Message-ID: <jasonweaver@example.org>
From: Mario Ds Briggs <jasonweaver@example.org>
Date: Tue, 31 Jul 2007 11:24:23 +0530
X-MIMETrack: Serialize by Router on d23ml062/23/M/IBM(Release 7.0.2HF32 | October 17, 2006) at
 31/07/2007 11:24:26
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
X-Virus-Checked: Checked by ClamAV on apache.org


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 jasonweaver@example.org Tue Jul 31 14:52:16 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 60568 invoked from network); 31 Jul 2007 14:51:57 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 31 Jul 2007 14:51:57 -0000
Received: (qmail 7161 invoked by uid 500); 31 Jul 2007 14:51:14 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 5714 invoked by uid 500); 31 Jul 2007 14:51:09 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 3242 invoked by uid 99); 31 Jul 2007 14:50:59 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 07:50:59 -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; Tue, 31 Jul 2007 14:50:34 +0000
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 0D2797141EE
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 07:49:53 -0700 (PDT)
Message-ID: <3559682.1185893393051.JavaMail.jira@brutus>
Date: Tue, 31 Jul 2007 07:49:53 -0700 (PDT)
From: "cristian manea (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-235) There should be a way to specify a
 Timeout for a specific query, instead of using always the default.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

There should be a way to specify a Timeout for a specific query, instead of using always the default.
-----------------------------------------------------------------------------------------------------

                 Key: IBATISNET-235
                 URL: https://issues.apache.org/jira/browse/IBATISNET-235
             Project: iBatis for .NET
          Issue Type: Improvement
          Components: DataMapper
    Affects Versions: DataMapper 1.6.1, DataMapper 1.6.2, DataMapper 2.0
         Environment: Microsoft Windows, DNF 2.0
            Reporter: cristian manea
            Priority: Critical


There is no way to specify a specific Timeout for a mapper query. 

This can make it blocking for an app, especially if we have some complex query used for reporting, or for search, an if the db is large enough.

It is very important to be able to say: this query should timeout in 5 secs (because it reads a record based on the index), but THIS query should timeout in 10 minutes, because it is very complex and goes in 5 tables (used for reporting, lets say). 

It is unthinkable to set the same timeout for both queries. The first one could mean that it could block my app if instead of 5 secs it would be 10 mins, and the second one would mean that I cannot do any complex query on a large DB using iBATIS.

Please think of re-implementing one or both this solutions:
1) be able to specify in the sqlmap.xml statement the timeout for the query (static timeout).
2) or be abble to specify the timeout when calling the QueryForXXXX(...) by overloading the method in order to be able to specify the timeout (dynamic timeout)

Regards.

Cristian Manea - www.atypiq.ro


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Tue Jul 31 15:02:16 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 70425 invoked from network); 31 Jul 2007 15:01:57 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 31 Jul 2007 15:01:56 -0000
Received: (qmail 40758 invoked by uid 500); 31 Jul 2007 15:00:38 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 40170 invoked by uid 500); 31 Jul 2007 15:00:36 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 39510 invoked by uid 99); 31 Jul 2007 15:00:32 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 08:00:32 -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; Tue, 31 Jul 2007 14:36:13 +0000
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id E7D6B714187
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 07:35:52 -0700 (PDT)
Message-ID: <14372276.1185892552897.JavaMail.jira@brutus>
Date: Tue, 31 Jul 2007 07:35:52 -0700 (PDT)
From: "cristian manea (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Commented: (IBATISNET-221) InvalidCastException while
 getting object out of the cache
In-Reply-To: <25370527.1176300452545.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-221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12516705 ] 

cristian manea commented on IBATISNET-221:
------------------------------------------

Hello. This is the workaround that I have used for this (although I think that in version 1.6.1 there is no more need for this, it was solved):

        public override ResourceDataCarrier Read(ResourceDataCarrier obj)
        {
            System.Object objreturn;
            objreturn = Mapper().QueryForObject<object>("SelectResource", obj);
            if (objreturn == null) 
                return (null);
             
            return ((ResourceDataCarrier) objreturn);
        }

Hope this will help you.

Regards.

www.atypiq.ro

> InvalidCastException while getting object out of the cache
> ----------------------------------------------------------
>
>                 Key: IBATISNET-221
>                 URL: https://issues.apache.org/jira/browse/IBATISNET-221
>             Project: iBatis for .NET
>          Issue Type: Bug
>          Components: DataMapper
>    Affects Versions: DataMapper 1.6.1
>         Environment: IBatis.net SVN, revision 527493, .Net 2.0
>            Reporter: Rogelio J. Baucells
>            Priority: Critical
>
> There is a problem in the implementation of CachingStatement888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4xecuteQueryForObject for .Net2.0. The following scenario triggers the InvalidCastException:
> - Create a <ResultMap>, <procedure>, <parameterMap> and <cacheModel> for a select statement.
> - Invoke the statement with parameters that does not return any results
> - Invoke the same statement again
> The first invocation will store a NULL_OBJECT in the cache for this key (CacheModel888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4this[CacheKey key]), the second statement will retrieve the NULL_OBJECT from the cache and will cause the InvalidCastException at:
> obj = (T)this.Statement.CacheModel[cacheKey];
> Also the next statement will never be TRUE since obj is of type T:
> if ((object)obj == CacheModel.NULL_OBJECT)
> The solution for this problem would be declaring obj as object and casting to T at the time of returning from the method, something like:
> object obj = null;
> ...
> return (T)obj;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


From jasonweaver@example.org Tue Jul 31 17:05:46 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 25447 invoked from network); 31 Jul 2007 17:05:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 31 Jul 2007 17:05:46 -0000
Received: (qmail 92076 invoked by uid 500); 31 Jul 2007 17:05:45 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 92060 invoked by uid 500); 31 Jul 2007 17:05:45 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 92049 invoked by uid 99); 31 Jul 2007 17:05:45 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 10:05:45 -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 jasonweaver@example.org designates 83.161.120.155 as permitted sender)
Received: from [83.161.120.155] (HELO wa-out-1112.google.com) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 17:05:39 +0000
Received: by wa-out-1112.google.com with SMTP id j5so2405976wah
        for <jasonweaver@example.org>; Tue, 31 Jul 2007 10:05:19 -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=d60uNy5Ac4ojM7eP45VHNctv1EWLIFpNhIs1qm3LokfLEuWHJdQroAPx9InKoVLP3cymOwiRkdcRSmRYQCkC3Pa77/hOdx0zyP6dfcK75q0FhL4T4iChVfuKxKFItBS3aHSexzLBkRqieuICmNDlIxiZeI711/5ixExT2rt0gh8=
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=Xm5Tyhh0nAm0+ynyZxz44ii/7NRRn9UNATInV4iZH4h6Z9i66Ki4WvUyVd+62AmBclqXfWkpBZapl4gB4F6PwACsK9bJc04JZ477imjE+NxDYBWIDXwInMINZg/YXveGzyn0PXLYzj+OcX0JurRmDk255RRtgZziFspMkNuXoGs=
Received: by 83.161.120.155 with SMTP id t2mr6879080wal.1185901519085;
        Tue, 31 Jul 2007 10:05:19 -0700 (PDT)
Received: by 83.161.120.155 with HTTP; Tue, 31 Jul 2007 10:05:19 -0700 (PDT)
Message-ID: <jasonweaver@example.org>
Date: Tue, 31 Jul 2007 11:05:19 -0600
From: "Clinton Begin" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: Re: SQLJ support for iBATIS for Java
In-Reply-To: <jasonweaver@example.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_41073_28510920.1185901519055"
References: <jasonweaver@example.org>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_41073_28510920.1185901519055
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sounds interesting.  I look forward to seeing the first demo!

Clinton

On 7/30/07, Mario Ds Briggs <jasonweaver@example.org> 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
>
>

------=_Part_41073_28510920.1185901519055
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Sounds interesting.&nbsp; I look forward to seeing the first demo!<br><br>Clinton<br><br><div><span class="gmail_quote">On 7/30/07, <b class="gmail_sendername">Mario Ds Briggs</b> &lt;<a href="mailto:jasonweaver@example.org">jasonweaver@example.org
</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;"><br>Hello,<br><br>I would like to make contributions to the iBatis Data Mapper for Java, so
<br>that it could execute SQL statements using SQLJ also (in addition to JDBC,<br>as is done currently).<br><br>The primary goal would be for users to be able to use any SQLJ vendor&#39; s<br>implementation (IBM, Oracle, Informix etc) with the Data Mapper. This would
<br>enable customers who use SQLJ to be able to use iBatis DataMapper.<br><br>Parameter and resultset (mapping) handling, cache and all other features<br>would remain unchanged and use the existing code without duplication. SQLJ
<br>would be used only to execute the SQL and return resultsets/updatecounts as<br>applicable.&nbsp;&nbsp;The approach would&nbsp;&nbsp;have a tool (contributed to the project)<br>that would generate the SQLJ implementation for the statements in the map
<br>xml files, translate and customize it. The runtime would have a<br>sqljExecutor in addition to the existing sqlExecutor (JDBC).&nbsp;&nbsp;Runtime<br>switching between using either SQLJ or JDBC would be possible<br><br>Looking to take this forward and any feedback.
<br><br>thanks<br>Mario<br><br></blockquote></div><br>

------=_Part_41073_28510920.1185901519055--

From jasonweaver@example.org Wed Aug 01 02:19:15 2007
Return-Path: <jasonweaver@example.org>
Delivered-To: jasonweaver@example.org
Received: (qmail 60081 invoked from network); 1 Aug 2007 02:19:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 1 Aug 2007 02:19:14 -0000
Received: (qmail 37683 invoked by uid 500); 1 Aug 2007 02:19:14 -0000
Delivered-To: jasonweaver@example.org
Received: (qmail 37663 invoked by uid 500); 1 Aug 2007 02:19:14 -0000
Mailing-List: contact jasonweaver@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jasonweaver@example.org>
List-Unsubscribe: <mailto:jasonweaver@example.org>
List-Post: <mailto:jasonweaver@example.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: jasonweaver@example.org
Delivered-To: mailing list jasonweaver@example.org
Received: (qmail 37652 invoked by uid 99); 1 Aug 2007 02:19:14 -0000
Received: from Unknown (HELO athena.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 19:19:14 -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 02:19:13 +0000
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 17F8C714159
	for <jasonweaver@example.org>; Tue, 31 Jul 2007 19:18:53 -0700 (PDT)
Message-ID: <22035872.1185934733095.JavaMail.jira@brutus>
Date: Tue, 31 Jul 2007 19:18:53 -0700 (PDT)
From: "noriyuki shimbo (JIRA)" <jasonweaver@example.org>
To: jasonweaver@example.org
Subject: [jira] Created: (IBATISNET-236) about dev guide (transaction
 handling with using syntax)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

about dev guide (transaction handling with using syntax)
--------------------------------------------------------

                 Key: IBATISNET-236
                 URL: https://issues.apache.org/jira/browse/IBATISNET-236
             Project: iBatis for .NET
          Issue Type: Improvement
          Components: DataAccess
    Affects Versions: DataAccess 1.9 .1
         Environment: Microsoft Windows XP Professional Service Pack 2   5.1.2600
Microsoft .NET Framework 1.1.4322.2407
Intel(R) Pentium(R) 4 CPU 3.00GHz
1536 MB RAM
            Reporter: noriyuki shimbo
            Priority: Trivial


I'm using Data Access with SQL Mapper.

See the example in the Data Access Object  Dev Guilde 1.9.1(and lower edition) Chapter5 - 5-5 - Working with Connection and Transactions - Example 5.6 
using ( IDalSession session = daoManager.OpenConnection() )
{
Account account = NewAccount();
accountDao.Create(account);
}
using ( IDalSession session = daoManager.BeginTransaction() )
{
Account account = NewAccount();
Account account2 = accountDao.GetAccountById(1);
account2.EmailAddress = "jasonweaver@example.org";
accountDao.Create(account);
accountDao.Update(account2);
session.Complete(); // Commit
}

The example code above is not kind enough. If daoManager.BeginTransaction() fails due to network trouble or connection timeout or something, the instance of IDalsession is null, so Dispose method is not called. This leaves SqlMapSession remain in the ISessionStore(CallContextSessionStore) and the next transactions all fails to produce exceptions like below even if recovered from network trouble.

IBatisNet.DataMapper.Exceptions.DataMapperException: SqlMap could not invoke BeginTransaction(). A Transaction is already started. Call CommitTransaction() or RollbackTransaction first.

You can reproduce this result by writing iteration code in which "using syntax transaction" exists.

foreach(string key in keyList) 
{
try 
{
 // call transaction method which includes the code lilke Example 5.6 here
} 
catch (Exception e) 
{
 Console.WriteLine(e.ToString());
 Console.WriteLine(e.StackTrace);
// continue next
}
}

My workaround so far is to call daoManager.CloseConnection() in the catch block like below and it works.
try
{
using ( IDalSession session = daoManager.OpenConnection() )
{
 Account account = NewAccount();
 accountDao.Create(account);
}
}
catch (Exception ex)
{
 daoManager.CloseConnection();
 throw new RDBAccessException("message",ex);
}

try
{
 using ( IDalSession session = daoManager.BeginTransaction() )
 {
  Account account = NewAccount();
  Account account2 = accountDao.GetAccountById(1);
  account2.EmailAddress = "jasonweaver@example.org";
  accountDao.Create(account);
  accountDao.Update(account2);
  session.Complete(); // Commit
 }
}
catch (Exception ex)
{
 daoManager.CloseConnection();
 throw new RDBAccessException("message",ex);
}


I'm using Data Access with SQL Mapper.

You can see the example in the Data Access Guilde 1.9.1(and lower edition) Chapter5 - 5-5 - Working with Connection and Transactions - Example 5.6 
using ( IDalSession session = daoManager.OpenConnection() )
{
 Account account = NewAccount();
 accountDao.Create(account);
}
using ( IDalSession session = daoManager.BeginTransaction() )
{
 Account account = NewAccount();
 Account account2 = accountDao.GetAccountById(1);
 account2.EmailAddress = "jasonweaver@example.org";
 accountDao.Create(account);
 accountDao.Update(account2);
 session.Complete(); // Commit
}

The example code above is not kind enough. If daoManager.OpenConnection() or daoManager.BeginTransaction() fails due to network trouble or connection timeout or something, the instance of IDalsession is null, so Dispose method is not called. This leaves SqlMapSession remain in the ISessionStore(CallContextSessionStore) and the next transactions all fails to produce an exception like below even if recovered from network trouble.

IBatisNet.DataMapper.Exceptions.DataMapperException: SqlMap could not invoke BeginTransaction(). A Transaction is already started. Call CommitTransaction() or RollbackTransaction first.

You can reproduce this result by writing iteration code in which "using syntax transaction" exists.

foreach(string key in keyList) 
{
 try 
 {
  // call transaction method which includes the code lilke Example 5.6 here
 } 
 catch (Exception e) 
 {
  Console.WriteLine(e.ToString());
  Console.WriteLine(e.StackTrace);
  // continue next
}
}

My workaround so far is to call daoManager.CloseConnection() in the catch block like below and it works.
try
{
 using ( IDalSession session = daoManager.OpenConnection() )
 {
   Account account = NewAccount();
   accountDao.Create(account);
 }
}
catch (Exception ex)
{
 daoManager.CloseConnection();
 throw new RDBAccessException("message",ex);
}

try
{
 using ( IDalSession session = daoManager.BeginTransaction() )
 {
 Account account = NewAccount();
 Account account2 = accountDao.GetAccountById(1);
 account2.EmailAddress = "jasonweaver@example.org";
 accountDao.Create(account);
 accountDao.Update(account2);
 session.Complete(); // Commit
 }
}
catch (Exception ex)
{
 daoManager.CloseConnection();
 throw new RDBAccessException("message",ex);
}

I think it will be better to describe this matter in the document.
 If you have the other better way please add it to the document.

Thanks.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



{'source': 'Apache Software Foundation Public Mail Archives'}