Does that work with this syntax??
I don't see how to express the Handler here??
Thanks for all your help.
Cheers,
-- Chris
<insert id="insertBlogEntryMySQL" parameterClass="blogEntryBean" >
INSERT INTO Blog (Name, Title, Text, CreateUTC)
VALUES (#name#, #title#, #text#, #createUTC#)
<selectKey keyProperty="id" resultClass="int" >
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
On 7/4/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Hold off on the JIRA issue - I just wrote a test and the select key DOES
honor the type handler if you specify it on the generated field. This this
mapping worked in my test:
<insert id="testInsert" parameterClass="test.Animal">
<selectKey resultClass="test.WierdKey" keyProperty="id">
select max(id) + 1 from Animal <!-- bad practice - just for test -->
</selectKey>
insert into Animal values (#id,handler=test.WierdKeyHandler#, #type#,
#name#)
</insert>
Try it out.
Jeff Butler
On 7/4/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
>
>
> Currently there is no way to use a type handler with <selectKey> - but I
think that would be a logical enhancement for iBATIS. If you want, make a
new JIRA issue for this. Or, if you don't want to access JIRA let me know
and I'll do it.
>
>
> Jeff Butler
>
>
> On 7/4/06, Chris Berry <[EMAIL PROTECTED] > wrote:
> > This stuff works great!!
> > Is there anyway to use this to specify a TypeHandler with <selectkey> ??
> >
> > <insert id="insertBlogEntryMySQL" parameterClass="blogEntryBean" >
> > insert into Blog (Name, Title, Text) values (#name#, #title#, #text#)
> >
> > <selectKey keyProperty="idInt" resultClass="int" >
> > select LAST_INSERT_ID()
> > </selectKey>
> > </insert>
> >
> > Thanks,
> > -- Chris
> >
> >
> > On 7/4/06, Chris Berry < [EMAIL PROTECTED]> wrote:
> > > Thank you Jeff
> > >
> > > On 7/4/06, Jeff Butler <[EMAIL PROTECTED] > wrote:
> > > >
> > > > There's a link here:
> > > >
> > > > http://ibatis.apache.org/javadownloads.html
> > > >
> > > > "Latest Open Office Documents in Subversion", you want
iBATIS-SqlMaps-2.pdf.
> > > >
> > > > The syntax is:
> > > >
> > > >
#propertyName,javaType=?,jdbcType=?,mode=?,nullValue=?,handler=?#
> > > >
> > > >
> > > > Jeff Butler
> > > >
> > > >
> > > > On 7/4/06, Chris Berry < [EMAIL PROTECTED]> wrote:
> > > > > Thanks Jeff.
> > > > > For posterity (and to save me and others the trouble of finding
the
> > > > > pdf in SVN ;-) would you mind posting the syntax??
> > > > > Thank you.
> > > > > Cheers,
> > > > > -- Chris
> > > > >
> > > > > On 7/4/06, Jeff Butler < [EMAIL PROTECTED]> wrote:
> > > > > >
> > > > > > If you use a parameter map, then you need to use question marks
in the
> > > > > > statement rather than named parameters. This is why we rarely
recommend
> > > > > > using formal parameters maps - the inline maps seem more
intuitive.
> > > > > >
> > > > > > There is syntax with inline parameter maps to add type a type
handler -
> > > > see
> > > > > > the latest sqlmap pdf in SVN for details (I just recently added
> > > > > > documentation for it, but it's been available for quite some
time).
> > > > > >
> > > > > >
> > > > > > Jeff Butler
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 7/4/06, Chris Berry < [EMAIL PROTECTED] > wrote:
> > > > > > > Greetings,
> > > > > > > This question is related to a previous post I previously made
about
> > > > > > > <selectkey>, but this one is about using <update> and
<parameterMap>
> > > > > > >
> > > > > > > I am using iBatis coupled with Axis. This is a great
combination. Axis
> > > > > > > generates "XMLBeans" for the Request/Response, and I map them
directly
> > > > > > > into SQLMaps using iBatis. Thus, very little code is required.
> > > > > > >
> > > > > > > Axis tends to wrap primitives (from the XSD) in it's own types
(e.g.
> > > > > > > UnsignedLong). This is not normally a problem, except when
dealing
> > > > > > > with keys.
> > > > > > >
> > > > > > > I am having a great deal of trouble getting <parameterMap> to
work
> > > > > > > with <update>. Could someone please help?? I must be doing
something
> > > > > > > silly, but I cannot see what it is???
> > > > > > >
> > > > > > > Thanks,
> > > > > > > -- Chris
> > > > > > >
> > > > > > > Details follow::
> > > > > > >
> > > > > > > <parameterMap class="blogEntryClass" id="blogEntryParams" >
> > > > > > > <parameter property="name" />
> > > > > > > <parameter property="title" />
> > > > > > > <parameter property="text" />
> > > > > > > <parameter property="updateUTC" />
> > > > > > > <parameter property="id"
> > > > > > > jdbcType="INTEGER"
> > > > > > >
> > > > javaType="org.apache.axis.types.UnsignedLong "
> > > > > > >
> > > > > >
> > > >
typeHandler="etrade.utils.ibatis.UnsignedLongTypeHandler"
> > > > > > />
> > > > > > > </parameterMap>
> > > > > > >
> > > > > > > <update id="updateBlogEntry" parameterMap="blogEntryParams">
> > > > > > > update Blog set Name=#name#, Title=#title#, Text=#text#,
> > > > > > > UpdateUTC=#updateUTC# where Id=#id#
> > > > > > > </update>
> > > > > > >
> > > > > > > I always get a
> > > > > > > [junit] --- The error occurred in config/sqlMap- blog.xml.
> > > > > > > [junit] --- The error occurred while applying a parameter
map.
> > > > > > > [junit] --- Check the blogEntryParams.
> > > > > > > [junit] --- Check the parameter mapping for the 'name'
property.
> > > > > > > [junit] --- Cause: java.sql.SQLException: Parameter index
out of
> > > > > > > range (1 > number of parameters, which is 0).]; nested
exception is
> > > > > > > com
> > > > > > >
.ibatis.common.jdbc.exception.NestedSQLException:
> > > > > > >
> > > > > > > I get this error in whatever order I put together the
> > > > <parameterMap>!!!
> > > > > > >
> > > > > > > The BlogEntry_t Class looks like this::
> > > > > > >
> > > > > > > public class BlogEntry_t implements java.io.Serializable {
> > > > > > > .....
> > > > > > > public org.apache.axis.types.UnsignedLong
getId()
> > > > {
> > > > > > > return id;
> > > > > > > }
> > > > > > > public void setId(
> > > > org.apache.axis.types.UnsignedLong
> > > > > > id) {
> > > > > > > this.id = id;
> > > > > > > }
> > > > > > > ......
> > > > > > >
> > > > > > > I cannot see what is wrong with my <parameterMap> ????
> > > > > > >
> > > > > > >
> > > > > >
> > > >
-----------------------------------------------------------------------
> > > > > > > But if I DON'T use a <parameterMap>, and do this
> > > > > > >
> > > > > > > <update id="updateBlogEntry" parameterClass="blogEntryBean">
> > > > > > > update Blog set Name=#name#, Title=#title#, Text=#text#,
> > > > > > > UpdateUTC=#updateUTC# where Id=#idInt#
> > > > > > > </update>
> > > > > > >
> > > > > > > And then build a "wrapper Bean", like this
> > > > > > >
> > > > > > > public class BlogEntryBean
> > > > > > > extends BlogEntry_t
> > > > > > > {
> > > > > > > .....
> > > > > > > public BlogEntryBean( BlogEntry_t base )
> > > > > > > {
> > > > > > > .....
> > > > > > > }
> > > > > > >
> > > > > > > .....
> > > > > > > public int getIdInt()
> > > > > > > {
> > > > > > > org.apache.axis.types.UnsignedLong uid =
> > > > > > super.getId ();
> > > > > > > return uid.intValue();
> > > > > > > }
> > > > > > > }
> > > > > > >
> > > > > > > And call like this::
> > > > > > > getSqlMapClientTemplate().update(
> > > > "updateBlogEntry",
> > > > > > new
> > > > > > > BlogEntryBean(entry) );
> > > > > > >
> > > > > > > Then it works perfectly.
> > > > > > >
> > > > > > > But I really don't want to use a wrapper Bean. It would be so
much
> > > > > > > cleaner without one.
> > > > > > > (I am trying to establish a pattern for building Axis/iBatis
web
> > > > > > > services at my company)
> > > > > > >
> > > > > > > Thanks,
> > > > > > > -- Chris
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
>
>
