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 <[EMAIL PROTECTED]> 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.
