RE: iBatis and JBoss

I found the problem. Will post in case anyone has the same. Always, really always, pack your objects to be mapped to sql in jar and put them to lib directory. Only in this way they will be found. -- View this message in context: http://www.nabble.com/iBatis-and-JBoss-tf3401674.html#a9492652

RE: Understanding stored procedure return types

Hi Collin, I struggled with this for a bit as well...Here's how we're doing it (and it works, which is always a bonus). SQLMap fragment: parameterMap id='paramPartnerReferenceUnique' class='map' parameter property='returnvaluecolumn' jdbcType='VARCHAR' javaType='java.lang.String'

RE: Understanding stored procedure return types

That's a question for the authors. I found this way to be the only one that worked to invoke SPs. The docs pretty much spell it out that way. I'm not sure how you'd invoke the SP in a select tag anyhow, since the select is supposed to map into JDBC as a PreparedStatement. SPs are special in

Is it possible to have an optional property in resultMap?

Hi everyone, I'm just wondering if it is possible to have an optional property in a resultMap? For example, I have a UserVO class which I use to load users into. It has fields such as user_id, username, firstname, lastname, password, etc... I also want to use this class as a 'sub'-resultMap

Re: Is it possible to have an optional property in resultMap?

Collin Peters schrieb: Hi everyone, I'm just wondering if it is possible to have an optional property in a resultMap? For example, I have a UserVO class which I use to load users into. It has fields such as user_id, username, firstname, lastname, password, etc... I also want to use this

RE: Understanding stored procedure return types

Well, glad that it works...Personally, I wouldn't expect that to be a cross-DB friendly solution, nor does it seem to be the least astonishing method of accomplishing the goal. But hey, if you're cool with it, that's what matters I guess. -D -Original Message- From: Collin Peters

Is it possible to create 1:N + 1:M object.

Hi, Is it possible to create 1:N + 1:M object. I think iBatis can create 1:N object, if I use groupBy. So it is possible to create 1:N + 1:M object? For example; resultMap id=aaa groupBy=a ... result property=xxx resultMap=bbb/ result property=yyy resultMap=ccc/ /resultMap resultMap

Re: Is it possible to have an optional property in resultMap?

You could use dynamic SQL to do that, just make the password '' in the cases you don't want it. select... select ... isEqual property=showPassword compareValue=truepassword/isEqual isEqual property=showPassword compareValue=false'' as password/isEqual ... /select Larry On 3/15/07, Collin

IBatis.NET and Dao Manager

I know that Java users are encouraged to use the String DAO templates despite old fashion Dao Manager. Is this going to happen to the .NET version as well?. I'm evaluating this product and I'd like to make an idea if it will be good to integrate IBatis.NET with Spring.NET from the beginning.

Error When creating XML file from Database with Character conversion error

Hi I am using ibatis to create XML file from database, i have the following sqlMap select id=getFooter4 resultClass=xml parameterClass= java.math.BigDecimal xmlResultName=FOOTER4 SELECT P704SPEC, P704LINE, P704DETL, P704USER, P704DATE, P704TIME FROM PU27041 WHERE P704SPEC =

Re: Is it possible to have an optional property in resultMap?

You could do two things: 1. Hava a BaseUserVO and FullUserVO that extends BaseUserVO. Write seperate result maps and use as appropriate 2. Have UserVO as now, but write two different resultMaps - a base resultMap and a full resultMap that extends the base resultMap. Then specify the