Mapping associations for resultsets obtained from cursors (iBatis 3beta10)

2010-03-08 Thread Martin Tupper
I have a resultMap which maps an association between eg. Parent and Child objects. When I use the resultMap with association for a select which joins parent and child tables everything works fine. When I use the same select in an Oracle stored procedure returning refCursor and I use the same r

Re: Mapping associations for resultsets obtained from cursors (iBatis 3beta10)

2010-03-08 Thread Clinton Begin
Hmmm... RefCursors might be defaulting to the FastResultSetHandler, which doesnt' load relationships. Should be a simple fix. Unfortunately I'm without my computer (no way!) right now. If anyone's interested in why you should never buy Lenovo, let me know. ;-) Clinton On Mon, Mar 8, 2010 at 4

Re: SQL Maps connection mgmt in servlet

2010-03-08 Thread François Schiettecatte
Andrew The answer is yes, though I am not sure how efficient the simple data source is as pooling, you might want to look at C3P0 which I use ( http://www.mchange.com/projects/c3p0/ ) or DBCP from Apache ( http://commons.apache.org/dbcp/ ). François On Mar 6, 2010, at 4:28 PM, Andrew Broderi

SqlSession question

2010-03-08 Thread J S
Please exercise some patience if what I am about to ask sounds dumb.  I'm still new to Ibatis; so far it has been a very pleasant experience. I get the impression that the SqlSession class bundles the functionality of both, transactions and a persistence context.  This mixture is still unclear t

Re: SqlSession question

2010-03-08 Thread Clinton Begin
The only rationale there is to allow for you to commit more than once within a session scope. In previous versions of iBATIS this was possible, but was messy because Session, Transaction and Batches were all managed separately. Because we've now merged all three into this one concept, we didn't w

iBatis upgrade question

2010-03-08 Thread Rudra . Panda
Hi, I use ibatis-2.3.0.677 in my current project. I wanted to upgrade to iBatis 3.0, and hence replaced ibatis-2.x.jar with ibatis-3-core-3.0.0.220.jar. However, I get compilation error for the followings import com.ibatis.sqlmap.client.event.RowHandler; import com.ibatis.sqlmap.engine.executio

Re: iBatis upgrade question

2010-03-08 Thread François Schiettecatte
Rudra I have just updated a project from 2.x to 3.x. Specifically to your point, RowHandler was replaced by ResultHandler which passes in a ResultContext from which you can get the object using ResultContext.getResultObject(). More generally, you will need to: - review your ibatis xml configur