[jira] Created: (IBATIS-375) Provide a way for not creating items from nested ResultMaps when the items contain only null values

2006-12-01 Thread Stefan Langer (JIRA)
Provide a way for not creating items from nested ResultMaps when the items 
contain only null values
---

 Key: IBATIS-375
 URL: http://issues.apache.org/jira/browse/IBATIS-375
 Project: iBatis for Java
  Issue Type: Improvement
  Components: SQL Maps
Affects Versions: 2.2.0
Reporter: Stefan Langer


Taken the following resultmaps (uneeded parts are left out) for a simple 
domainmodel where notebook contains 0 or more pages.

resultMap class=notebook groupBy=id id=notebookResult
   result column=NB_ID jdbcType=VARCHAR property=id/
   result javaType=java.util.List property=pages 
resultMap=Note.pageResult/
/resultMap

resultMap class=page groupBy=id id=pageResult
  result column=P_ID jdbcType=VARCHAR property=id/
/resultMap 

and the following select statement:
select id=selectNotebook parameterClass=java.lang.String 
resultMap=notebookResult
SELECT nb.id as nb_id, p.id as p_id,
FROM notebook nb LEFT JOIN page p ON nb.id = p.notebook_id
WHERE nb.id = #id#
/select 

Do to the left join this query will always result in at least one page being 
created even though the pages are actually empty. 
It would be nice if the mapping framework could somehow not create these empty 
objects. 
The following suggestions come to mind: 
Either do not create objects where all parameters are null (this indicates the 
left or right join scenario)
or provide a way to tag a property in the resultMap which may not be null in 
order for the object to be created.
Example:
resultMap class=page groupBy=id id=pageResult
  result column=P_ID jdbcType=VARCHAR property=id 
doNotCreateOnNull=true/
/resultMap 
This would greatly ease the use of complex mappings where one wants to prevent 
the dreaded N+1 Select Problem.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] Closed: (IBATIS-337) Add documentation item to left nav in Get help section to improve usability of the webpage

2006-12-01 Thread Jeff Butler (JIRA)
 [ http://issues.apache.org/jira/browse/IBATIS-337?page=all ]

Jeff Butler closed IBATIS-337.
--

Resolution: Fixed
  Assignee: Jeff Butler

In SVN.  Will be in the next refresh of the site.


 Add documentation item to left nav in Get help section to improve 
 usability of the webpage
 --

 Key: IBATIS-337
 URL: http://issues.apache.org/jira/browse/IBATIS-337
 Project: iBatis for Java
  Issue Type: Improvement
  Components: Documentation
Reporter: Torsten Michelmann
 Assigned To: Jeff Butler
Priority: Trivial

 To find the documentation easier I suggest to add a link to a new page 
 http://ibatis.apache.org/documentation.html in the Get help section of the 
 left navigation.
 The section would then look like
 - How to get help
 +Documentation
 - Wiki
 - FAQ
 - Mailing Lists
 - Issue Tracker
 This page (/documentation.html) contains just a link list to to the current 
 locations (eg. for the iBatis Java there would be a link to 
 http://ibatis.apache.org/javadownloads.html) 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




Re: Status of 2.3 Release

2006-12-01 Thread Jeff Butler

We discussed this some weeks ago.  IIRC, Clinton wanted to do a new release
rather than voting for GA on 2.2.

Jeff Butler



On 12/1/06, Brandon Goodin [EMAIL PROTECTED] wrote:


Curious why we are superceding 2.2 wit 2.3? 2.2 has been available for
some time and contains several bug fixes over 2.1.7. I would also say that
2.2.0 could be made GA. The other thought is that there is no guarantee
that 2.3 will be GA quality after we get it out there for 2 weeks, however
unlikely that may be. Thanks for getting this all together!

B

On 11/30/06, Jeff Butler [EMAIL PROTECTED] wrote:

 Hi All,

 I have everything built for 2.3, and have everything signed and
 checksummed.  Unfortunately, there are permission problems in the .../dist
 directories, so I'm stuck right now.  I've sent a note to infra@ and as soon
 as they get the permission problems resolved, then I'll be able to publish
 the release.

 This will be the first iBATIS/Java release that uses the Apache
 mirroring structure - I'm going to implement the new Apache release policy
 according to the notice the committers received a couple of weeks ago.

 My release plan looks like this:

 1. Post the 2.3 and 2.1.7 builds to the mirrors.  2.3 will superceed 2.2,
 so no need to post it
 2. Label 2.3 as beta, 2.1.7 is still the GA release
 3. Call for a vote for 2.3 GA two weeks after 2.3 is posted

 I'll keep you posted - hopefully I'll get it done tomorrow.

 Jeff Butler






Re: iBATIS for Java 2.3.0 Released!

2006-12-01 Thread Jeff Butler

You might need to select a different mirror.  I know the files have been
propogated to some of the mirrors, but not all.

You could also use the backup mirrors at the end of the list.

Jeff Butler



On 12/1/06, Tom Duffey [EMAIL PROTECTED] wrote:



 On Dec 1, 2006, at 11:20 AM, Jeff Butler wrote:

 You can obtain the new release here:

http://ibatis.apache.org/javadownloads.cgi


Hate to crash your party but the download link doesn't work :)


Tom



iBATIS for Java 2.3.0 Released!

2006-12-01 Thread Jeff Butler

iBATIS for Java version 2.3.0 is now available.

This release includes several bug fixes and enhancements. Additionally, this
release offers new support for local caching of prepared statements. Caching
prepared statements can lead to significant performance improvements in many
environments.

The Java DAO framework has been deprecated and removed from iBATIS as of
release 2.3.0. We heartily recommend that you consider using the Spring
Framework http://www.springframework.org/ for all your DAO needs! Spring
offers great support for iBATIS.

The paginated list methods have been deprecated with this release. The
methods were confusing to many users and often misused. We suggest using
native database support for paging, or that you use the query methods with
skip and max settings.
Release 2.3.0 supercedes the 2.2.0 release which will remain at beta status
due to minor bugs. We recommend that all 2.2.0 users upgrade to version
2.3.0.

I expect that there will be a vote to promote 2.3.0 to General Availability
status in two weeks.

You can obtain the new release here:

http://ibatis.apache.org/javadownloads.cgi

Enjoy!

Jeff Butler


Re: iBATIS for Java 2.3.0 Released!

2006-12-01 Thread Clinton Begin

Nice job Jeff.

This also marks the first time someone else has done the full build and
deploy cycle of iBATIS.  This is a milestone that shows iBATIS is truly a
team effort (i.e. bus factor  1 ;-)

Great job to the whole team on another successful release.

Cheers,
Clinton

On 12/1/06, Jeff Butler [EMAIL PROTECTED] wrote:


iBATIS for Java version 2.3.0 is now available.

This release includes several bug fixes and enhancements. Additionally,
this release offers new support for local caching of prepared statements.
Caching prepared statements can lead to significant performance improvements
in many environments.

The Java DAO framework has been deprecated and removed from iBATIS as of
release 2.3.0. We heartily recommend that you consider using the Spring
Framework http://www.springframework.org/ for all your DAO needs! Spring
offers great support for iBATIS.

The paginated list methods have been deprecated with this release. The
methods were confusing to many users and often misused. We suggest using
native database support for paging, or that you use the query methods with
skip and max settings.
Release 2.3.0 supercedes the 2.2.0 release which will remain at beta
status due to minor bugs. We recommend that all 2.2.0 users upgrade to
version 2.3.0.

I expect that there will be a vote to promote 2.3.0 to General
Availability status in two weeks.

You can obtain the new release here:

http://ibatis.apache.org/javadownloads.cgi

Enjoy!

Jeff Butler




Re: Status of 2.3 Release

2006-12-01 Thread Clinton Begin

To clarify, what I suggested a week or so ago was:

We can vote for GA anytime, even after another release makes it to GA.  The
beta, alpha, GA status is always flexible.  We could vote for GA on 2.2.
right now actually. 

So a little closer to what Brandon is suggesting.  However, I'm more
interested in leaving 2.1.7 and 2.2 in the past and getting 2.3 to GA.

Cheers,
Clinton

On 12/1/06, Jeff Butler [EMAIL PROTECTED] wrote:


We discussed this some weeks ago.  IIRC, Clinton wanted to do a new
release rather than voting for GA on 2.2.

Jeff Butler



On 12/1/06, Brandon Goodin [EMAIL PROTECTED] wrote:

 Curious why we are superceding 2.2 wit 2.3? 2.2 has been available for
 some time and contains several bug fixes over 2.1.7. I would also say
 that 2.2.0 could be made GA. The other thought is that there is no
 guarantee that 2.3 will be GA quality after we get it out there for 2
 weeks, however unlikely that may be. Thanks for getting this all together!

 B

 On 11/30/06, Jeff Butler [EMAIL PROTECTED]  wrote:
 
  Hi All,
 
  I have everything built for 2.3, and have everything signed and
  checksummed.  Unfortunately, there are permission problems in the .../dist
  directories, so I'm stuck right now.  I've sent a note to infra@ and as soon
  as they get the permission problems resolved, then I'll be able to publish
  the release.
 
  This will be the first iBATIS/Java release that uses the Apache
  mirroring structure - I'm going to implement the new Apache release policy
  according to the notice the committers received a couple of weeks ago.
 
  My release plan looks like this:
 
  1. Post the 2.3 and 2.1.7 builds to the mirrors.  2.3 will superceed
  2.2, so no need to post it
  2. Label 2.3 as beta, 2.1.7 is still the GA release
  3. Call for a vote for 2.3 GA two weeks after 2.3 is posted
 
  I'll keep you posted - hopefully I'll get it done tomorrow.
 
  Jeff Butler
 
 





Re: Status of 2.3 Release

2006-12-01 Thread Clinton Begin

My vote is to leave it the way it is.  My conservative, pragmatic and
adventurous sides are all satisfied by having a single GA release as well as
the latest Beta release available for download.  2.2 is available in the
past releases if people want it.

Cheers,
Clinton

On 12/1/06, Jeff Butler [EMAIL PROTECTED] wrote:


I forgot about that conversation, I was thinking of this one:

http://www.mail-archive.com/dev@ibatis.apache.org/msg01855.html

A great example of selective memory on my part :)

Anyway I'm open to a GA vote for 2.2 if we need to.  But maybe we should
let the dust settle on 2.3 for a few days.  If it looks like it will fly,
then we could do the 2.3 GA vote a little sooner.  The major thing in 2.3was 
prepared statement caching and I know there's already been some public
testing of it.  Most of the fixes I did were for esoteric issues.  I think
2.3 is pretty solid.

Your thoughts - should I post the 2.2 build to the mirrors?  That wouldn't
take much effort now that I know how to sign releases (it was a strange trip
into command line hacker heaven).

Jeff Butler



On 12/1/06, Clinton Begin [EMAIL PROTECTED] wrote:

 To clarify, what I suggested a week or so ago was:

 We can vote for GA anytime, even after another release makes it to GA.
 The beta, alpha, GA status is always flexible.  We could vote for GA on
 2.2. right now actually. 

 So a little closer to what Brandon is suggesting.  However, I'm more
 interested in leaving 2.1.7 and 2.2 in the past and getting 2.3 to GA.

 Cheers,
 Clinton

 On 12/1/06, Jeff Butler [EMAIL PROTECTED]  wrote:
 
  We discussed this some weeks ago.  IIRC, Clinton wanted to do a new
  release rather than voting for GA on 2.2.
 
  Jeff Butler
 
 
 
  On 12/1/06, Brandon Goodin [EMAIL PROTECTED]  wrote:
  
   Curious why we are superceding 2.2 wit 2.3? 2.2 has been available
   for some time and contains several bug fixes over 2.1.7. I would
   also say that 2.2.0 could be made GA. The other thought is that
   there is no guarantee that 2.3 will be GA quality after we get it
   out there for 2 weeks, however unlikely that may be. Thanks for getting 
this
   all together!
  
   B
  
   On 11/30/06, Jeff Butler [EMAIL PROTECTED]  wrote:
   
Hi All,
   
I have everything built for 2.3, and have everything signed and
checksummed.  Unfortunately, there are permission problems in the 
.../dist
directories, so I'm stuck right now.  I've sent a note to infra@ and as 
soon
as they get the permission problems resolved, then I'll be able to 
publish
the release.
   
This will be the first iBATIS/Java release that uses the Apache
mirroring structure - I'm going to implement the new Apache release 
policy
according to the notice the committers received a couple of weeks ago.
   
My release plan looks like this:
   
1. Post the 2.3 and 2.1.7 builds to the mirrors.  2.3 will
superceed 2.2, so no need to post it
2. Label 2.3 as beta, 2.1.7 is still the GA release
3. Call for a vote for 2.3 GA two weeks after 2.3 is posted
   
I'll keep you posted - hopefully I'll get it done tomorrow.
   
Jeff Butler
   
   
  
  
 




Re: Status of 2.3 Release

2006-12-01 Thread Brandon Goodin

I'm fine with pushing 2.3. But, I had a conversation on the list with
someone who feared upgrading to 2.2 because it wasn't GA. This was,
apparently, a company policy. They need a feature that is available in
2.2but will not upgrade because it is not GA. If we do not make
2.2 GA then their company policy will continue to hold them up. I guess I
don't see a reason why we wouldn't make it GA. It has been available for
some time with fewer bugs than 2.1.7. If I were to blow off any release I'd
blow off 2.1.7 because it conatins more bugs than 2.2.

Brandon

On 12/1/06, Clinton Begin [EMAIL PROTECTED] wrote:



My vote is to leave it the way it is.  My conservative, pragmatic and
adventurous sides are all satisfied by having a single GA release as well as
the latest Beta release available for download.  2.2 is available in the
past releases if people want it.

Cheers,
Clinton

On 12/1/06, Jeff Butler [EMAIL PROTECTED] wrote:

 I forgot about that conversation, I was thinking of this one:

 http://www.mail-archive.com/dev@ibatis.apache.org/msg01855.html

 A great example of selective memory on my part :)

 Anyway I'm open to a GA vote for 2.2 if we need to.  But maybe we should
 let the dust settle on 2.3 for a few days.  If it looks like it will
 fly, then we could do the 2.3 GA vote a little sooner.  The major thing
 in 2.3 was prepared statement caching and I know there's already been
 some public testing of it.  Most of the fixes I did were for esoteric
 issues.  I think 2.3 is pretty solid.

 Your thoughts - should I post the 2.2 build to the mirrors?  That
 wouldn't take much effort now that I know how to sign releases (it was a
 strange trip into command line hacker heaven).

 Jeff Butler



 On 12/1/06, Clinton Begin [EMAIL PROTECTED]  wrote:
 
  To clarify, what I suggested a week or so ago was:
 
  We can vote for GA anytime, even after another release makes it to
  GA.  The beta, alpha, GA status is always flexible.  We could vote for GA on
  2.2. right now actually. 
 
  So a little closer to what Brandon is suggesting.  However, I'm more
  interested in leaving 2.1.7 and 2.2 in the past and getting 2.3 to
  GA.
 
  Cheers,
  Clinton
 
  On 12/1/06, Jeff Butler [EMAIL PROTECTED]  wrote:
  
   We discussed this some weeks ago.  IIRC, Clinton wanted to do a new
   release rather than voting for GA on 2.2.
  
   Jeff Butler
  
  
  
   On 12/1/06, Brandon Goodin [EMAIL PROTECTED]  wrote:
   
Curious why we are superceding 2.2 wit 2.3? 2.2 has been available
for some time and contains several bug fixes over 2.1.7. I would
also say that 2.2.0 could be made GA. The other thought is that
there is no guarantee that 2.3 will be GA quality after we get it
out there for 2 weeks, however unlikely that may be. Thanks for getting 
this
all together!
   
B
   
On 11/30/06, Jeff Butler [EMAIL PROTECTED]  wrote:

 Hi All,

 I have everything built for 2.3, and have everything signed and
 checksummed.  Unfortunately, there are permission problems in the 
.../dist
 directories, so I'm stuck right now.  I've sent a note to infra@ and 
as soon
 as they get the permission problems resolved, then I'll be able to 
publish
 the release.

 This will be the first iBATIS/Java release that uses the Apache
 mirroring structure - I'm going to implement the new Apache release 
policy
 according to the notice the committers received a couple of weeks ago.

 My release plan looks like this:

 1. Post the 2.3 and 2.1.7 builds to the mirrors.  2.3 will
 superceed 2.2, so no need to post it
 2. Label 2.3 as beta, 2.1.7 is still the GA release
 3. Call for a vote for 2.3 GA two weeks after 2.3 is posted

 I'll keep you posted - hopefully I'll get it done tomorrow.

 Jeff Butler


   
   
  
 




Re: Status of 2.3 Release

2006-12-01 Thread Clinton Begin

That's a great point.  I've had similar discussions.

How about this:  Let's do the vote for 2.2. GA right now.  Assuming it
passes (I don't see why not considering how long it's been out), we update
2.1.7 to 2.2 on the website by Monday.

Then, next Friday (7 days) we start the vote for 2.3 GA and give it 7 more
days to settle.  Within two weeks we'll have a 2.2 and a 2.3 GA.

I agree that we should probably GA 2.2 because people are already using it,
but also because it's the last DAO release...that way we have a GA'd final
DAO.

Sound good?

Clinton

On 12/1/06, Brandon Goodin [EMAIL PROTECTED] wrote:


I'm fine with pushing 2.3. But, I had a conversation on the list with
someone who feared upgrading to 2.2 because it wasn't GA. This was,
apparently, a company policy. They need a feature that is available in 2.2but 
will not upgrade because it is not GA. If we do not make
2.2 GA then their company policy will continue to hold them up. I guess I
don't see a reason why we wouldn't make it GA. It has been available for
some time with fewer bugs than 2.1.7. If I were to blow off any release
I'd blow off 2.1.7 because it conatins more bugs than 2.2.

Brandon

On 12/1/06, Clinton Begin [EMAIL PROTECTED]  wrote:


 My vote is to leave it the way it is.  My conservative, pragmatic and
 adventurous sides are all satisfied by having a single GA release as well as
 the latest Beta release available for download.  2.2 is available in
 the past releases if people want it.

 Cheers,
 Clinton

 On 12/1/06, Jeff Butler  [EMAIL PROTECTED] wrote:
 
  I forgot about that conversation, I was thinking of this one:
 
  http://www.mail-archive.com/dev@ibatis.apache.org/msg01855.html
 
  A great example of selective memory on my part :)
 
  Anyway I'm open to a GA vote for 2.2 if we need to.  But maybe we
  should let the dust settle on 2.3 for a few days.  If it looks like it
  will fly, then we could do the 2.3 GA vote a little sooner.  The major
  thing in 2.3 was prepared statement caching and I know there's already
  been some public testing of it.  Most of the fixes I did were for esoteric
  issues.  I think 2.3 is pretty solid.
 
  Your thoughts - should I post the 2.2 build to the mirrors?  That
  wouldn't take much effort now that I know how to sign releases (it was a
  strange trip into command line hacker heaven).
 
  Jeff Butler
 
 
 
  On 12/1/06, Clinton Begin [EMAIL PROTECTED]  wrote:
  
   To clarify, what I suggested a week or so ago was:
  
   We can vote for GA anytime, even after another release makes it to
   GA.  The beta, alpha, GA status is always flexible.  We could vote for GA 
on
   2.2. right now actually. 
  
   So a little closer to what Brandon is suggesting.  However, I'm more
   interested in leaving 2.1.7 and 2.2 in the past and getting 2.3 to
   GA.
  
   Cheers,
   Clinton
  
   On 12/1/06, Jeff Butler [EMAIL PROTECTED]  wrote:
   
We discussed this some weeks ago.  IIRC, Clinton wanted to do a
new release rather than voting for GA on 2.2.
   
Jeff Butler
   
   
   
On 12/1/06, Brandon Goodin [EMAIL PROTECTED]  wrote:

 Curious why we are superceding 2.2 wit 2.3? 2.2 has been
 available for some time and contains several bug fixes over
 2.1.7. I would also say that 2.2.0 could be made GA. The other
 thought is that there is no guarantee that 2.3 will be GA
 quality after we get it out there for 2 weeks, however unlikely that 
may be.
 Thanks for getting this all together!

 B

 On 11/30/06, Jeff Butler [EMAIL PROTECTED]  wrote:
 
  Hi All,
 
  I have everything built for 2.3, and have everything signed
  and checksummed.  Unfortunately, there are permission problems in 
the
  .../dist directories, so I'm stuck right now.  I've sent a note to 
infra@
  and as soon as they get the permission problems resolved, then I'll 
be able
  to publish the release.
 
  This will be the first iBATIS/Java release that uses the
  Apache mirroring structure - I'm going to implement the new Apache 
release
  policy according to the notice the committers received a couple of 
weeks
  ago.
 
  My release plan looks like this:
 
  1. Post the 2.3 and 2.1.7 builds to the mirrors.  2.3 will
  superceed 2.2, so no need to post it
  2. Label 2.3 as beta, 2.1.7 is still the GA release
  3. Call for a vote for 2.3 GA two weeks after 2.3 is posted
 
  I'll keep you posted - hopefully I'll get it done tomorrow.
 
  Jeff Butler