ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MrNobody <tony.loz...@pepsi.com>
Subject Re: Can't get this selectKey element working
Date Tue, 20 Nov 2007 21:02:10 GMT

Right!

I kept thinking it was going to create that variable on the fly, it didn't
even occur to me that it would be setting a parameter on my parameter class
to be used later.

thanks! free Mt. Dew for you!



Larry Meadors-2 wrote:
> 
> The select key sets the id on the parameter class.
> 
> If that helps, do I get a free Mt. Dew?
> 
> If that doesn't help, can you post the bean class (if you aren't using
> a Map), the mapped statement, and the java code used to call it?
> 
> Larry
> 
> 
> On Nov 20, 2007 1:50 PM, MrNobody <tony.lozina@pepsi.com> wrote:
>>
>> I am trying to use selectKey to generate my ID from an Oracle sequence
>> but I
>> can't figure out the correct usage. Searching on the Internet yields many
>> tutorials and when I try doing them EXACTLY as they instruct I get
>> errors-
>> probably due to version differences.
>>
>> Here's what I'm trying to do:
>>
>> <selectKey keyProperty="id" resultClass="int">
>>   SELECT MY_SEQ.nextVal AS id FROM DUAL
>> </selectKey>
>> insert into MyTable (my_id, my_value)
>> values (#id#, #value#)
>>
>> And I get the error:
>>
>> Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing
>> XPath
>> '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException:
>> Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing
>> XPath
>> '/sqlMap/insert'.  Cause: com.ibatis.common.beans.ProbeException: There
>> is
>> no READABLE property named 'id' in class 'com.mytest.MyTest'
>>
>> why does it keep trying to load id from the parameter class while
>> ignoring
>> the selectKey ??
>> --
>> View this message in context:
>> http://www.nabble.com/Can%27t-get-this-selectKey-element-working-tf4846284.html#a13865417
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/Can%27t-get-this-selectKey-element-working-tf4846284.html#a13865740
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message