Problem trying to avoid N+1 selects

2007-05-15 Thread Carlos Botto
Hi all, I'm new to iBatis and I'm coverting the existing code to implement iBatis, so sorry in advance if my questions are too simple. I have a problem trying to avoid the n+1 selects. The following Application.xml works fine:

Can you inject input parameters into a result map?

2007-05-15 Thread Paul Sanders
Tried hard to find a good title but that probably isn't it. Here's my problem I am using a sproc which fetches a bunch of records based on a matching key, which is also a property of the bean. No big deal, but the sproc doesn't return the key in the result set :( I get the List of items as ex

Re: Ibatis 2.0.8/Oracle 9 question: rollback on select

2007-05-15 Thread Herbert Wu
Thanks so much for the help! -Herbert On 5/15/07, Jeff Butler <[EMAIL PROTECTED]> wrote: I'll speak to WebSphere (which has a similar issue). This generally improves performance because the app server doesn't need to do anything to clean up abandoned transactions. But all performance statement

Re: Ibatis 2.0.8/Oracle 9 question: rollback on select

2007-05-15 Thread Jeff Butler
I'll speak to WebSphere (which has a similar issue). This generally improves performance because the app server doesn't need to do anything to clean up abandoned transactions. But all performance statements are best prefixed with "your milage may vary". Jeff Butler On 5/15/07, Herbert Wu <[E

Re: Ibatis 2.0.8/Oracle 9 question: rollback on select

2007-05-15 Thread Herbert Wu
Is this going to cause database server performance issue if the SELECT traffic is heavy? -Herbert On 5/15/07, Jeff Butler <[EMAIL PROTECTED]> wrote: This could be related to the underlying app server - iBATIS will always start a transaction, but will not always commit the transaction. In some c

Re: Ibatis 2.0.8/Oracle 9 question: rollback on select

2007-05-15 Thread Jeff Butler
This could be related to the underlying app server - iBATIS will always start a transaction, but will not always commit the transaction. In some case this will cause the app server to rollback the transaction. To alter this behavior, specify this: Jeff Butler On 5/15/07, Herbert Wu

Ibatis 2.0.8/Oracle 9 question: rollback on select

2007-05-15 Thread Herbert Wu
I am using Java iBatis 2.0.8 and Oracle DBA reported that a single SELECT can trigger rollback. I did not use any transaction: So I copied the ibatis com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.java/JdbcTransactionConfig.java to create a TestTransactionConfig.java tx man

Re: maven issue of iBatis 2.3

2007-05-15 Thread Clinton Begin
See the last comment: "iBATIS 2.3.0 has been pushed to iBiblio for Maven 2. I'm going to leave this issue open until we get a plan of action in place that we all agree on for getting this to ibiblio when we release." ~ Brandon Goodin Clinton On 5/15/07, Daigo Kobayashi <[EMAIL PROTECTED]> wrote

maven issue of iBatis 2.3

2007-05-15 Thread Daigo Kobayashi
I found jira about maven. http://issues.apache.org/jira/browse/IBATIS-122 iBatis 2.3 is already uploaded to maven central repository. However IBATIS-122 is not closed yet. Which status of this issue is correct?