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

procedures as a select? This seems much more efficient to me as I can take advantage of sending a VO as a parameter without having to create custom classes for each stored proc. On 3/15/07, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Hi Collin, I struggled with this for a bit as well...Here's how we're

RE: Understanding stored procedure return types

FROMsave_member_basic(?, ?, ?, ?, ?, ?); /select On 3/15/07, Dave Rodenbaugh [EMAIL PROTECTED] wrote: 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

Simple question...

Is the following a legal config in the dao.xml? iBATIS 2.2.0 allows this initialization (i.e. no XML barfing), but I the first DB access (relating to the order/sql-map-config.xml) when I use this construct gives me a There is no statement named 'findOrderBy...' in this SqlMap... I'm trying to

RE: Simple question...

and include all SqlMaps from there. See the developers guide (from the website) for some samples. Niels -Original Message- From: Dave Rodenbaugh [mailto:[EMAIL PROTECTED] Sent: donderdag 1 maart 2007 18:57 To: user-java@ibatis.apache.org Subject: Simple question... Is the following a legal

RE: Transaction issue with 2.2.0

the lock level? which isolation level do you use? i think this works for two JTA resources without XA (means Tx code off) because there the transaction manager need no two phase commit. Dave Rodenbaugh wrotes: Yes, I saw the release, just after I had completed implementation with 2.2.0

Difference in two queryForObject signatures

Hello, Can someone differentiate for me the reasoning behind these two functions in SqlMapDaoTemplate: Object queryForObject(String id, Object parameters); and Object queryForObject(String id, Object parameters, Object result); The docs appear very similar on them except that the first

RE: Using a Type Handler for SELECT stmt

-Original Message- From: Dave Rodenbaugh Sent: Monday, February 05, 2007 4:59 PM To: user-java@ibatis.apache.org Subject: Using a Type Handler for SELECT stmt Hi everyone, I have a custom type handler I'm using for Java 1.5 enums to map to a VARCHAR column in Oracle. I've read the SqlMap doc about

Using a Type Handler for SELECT stmt

Hi everyone, I have a custom type handler I'm using for Java 1.5 enums to map to a VARCHAR column in Oracle. I've read the SqlMap doc about TypeHandlers but there are some missing details...I'm sure my TypeHandler syntax definition is off, but I'm having a hard time finding the right place for

RE: Deployment question

the class loader was invoked to pull the resource at runtime. Putting them in package-qualified directories (or renaming the files) fixed the problem. -D From: Dave Rodenbaugh Sent: Thursday, January 25, 2007 11:18 AM To: user-java@ibatis.apache.org Subject

Calling a single-param SP

Hi everyone, New question If I have a stored proc that takes a single parameter...is this the right way to call it in the SQL Map XML? parameterMap id='paramFooProc' class='java.lang.String' parameter property='singleParamName' jdbcType='VARCHAR' javaType='java.lang.String' mode='IN'/

RE: Using parameterMaps

Jeff Butler On 12/11/06, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Hello all, I have a question regarding the valid values for the attribute class in the parameterMap. So far, the docs make it clear that I can use pkg-qualified names there, but don't say

RE: Using parameterMaps

. Larry On 12/12/06, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Thanks for the feedback...That all makes sense, except #4. CDATA sections, while not necessary here, are placed there because in the future, I probably won't be the one maintaining this code. If someone alters a WHERE clause

Using parameterMaps

Hello all, I have a question regarding the valid values for the attribute class in the parameterMap. So far, the docs make it clear that I can use pkg-qualified names there, but don't say much else. If I have: parameterMap id=orderByStatusAndType class=map parameter