Enrico (JIRA | 4 Jul 2007 16:23
Picon
Favicon

Created: (IBATIS-445) SqlText setText function and tab (\t) character in text definition

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;
  }

(Continue reading)

Clinton Begin | 8 Jul 2007 07:54
Picon

iBATIS Survey (10 Minutes)

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

Clinton Begin | 9 Jul 2007 15:42
Picon

Re: iBATIS Survey (10 Minutes)

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 <clinton.begin <at> gmail.com> 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.
>
(Continue reading)

Michael Schall (JIRA | 17 Jul 2007 18:41
Picon
Favicon

Created: (IBATISNET-231) sqlServer20005 misspelled in providers.config

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

Mario Briggs (JIRA | 18 Jul 2007 15:50
Picon
Favicon

Commented: (IBATIS-440) Contribute DB2 SQL Schema and Load scripts for the shipped JPetstore example application


    [
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
(Continue reading)

Oikonomopoulos Spyros (JIRA | 19 Jul 2007 09:44
Picon
Favicon

Created: (IBATISNET-232) Nested left joins with group by cause NPE when two subsequent levels have null values

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.

Max Jonas Werner (JIRA | 19 Jul 2007 18:50
Picon
Favicon

Commented: (IBATIS-436) Defaults for <settings/> element aren't applied if it doesn't exist


    [
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
(Continue reading)

Max Jonas Werner (JIRA | 19 Jul 2007 18:50
Picon
Favicon

Issue Comment Edited: (IBATIS-436) Defaults for <settings/> element aren't applied if it doesn't exist


    [
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
(Continue reading)

Michael Schall (JIRA | 23 Jul 2007 21:32
Picon
Favicon

Created: (IBATISNET-233) SQLite Provider node uses abandoned library. Updated node included

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 V1.0.43.0"
    enabled="true"
    assemblyName="System.Data.SQLite, Version=1.0.43.0, 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"
(Continue reading)

Miika Mäkinen (JIRA | 25 Jul 2007 03:08
Picon
Favicon

Commented: (IBATISNET-194) Support for non-public constructors


    [
https://issues.apache.org/jira/browse/IBATISNET-194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12515130
] 

Miika Mäkinen commented on IBATISNET-194:
-----------------------------------------

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

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

public .ctor(){
   _isNew = true;
}

and give iBatis access to internals of my DTO dll... now this is not possible.

> 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
(Continue reading)


Gmane