ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: insert going wrong after going from Sybase to MySQL
Date Fri, 22 Jan 2010 22:54:21 GMT
Your XML is simply invalid, use an editor that supports DTD validation.
The selectKey element can only be used inside select elements.

I also think that resultClass="java.lang.Long" is obsolete, and should
be removed.

Niels

-----Original Message-----
From: StevenF [mailto:steven@web2.filipowicz.com] 
Sent: Friday, January 22, 2010 11:32 PM
To: user-java@ibatis.apache.org
Subject: Re: insert going wrong after going from Sybase to MySQL


Hi Thanks for the reply!

Ok so I did this:

    <statement id = "insertChesser"
parameterClass="nl.chessone40.domain.Chesser"
resultClass="java.lang.Long">
        INSERT INTO Chesser
            (login,
            password,
            firstName,
            lastName,
            credits)
        values
            (#login#,
            #password#,
            #firstName#,
            #lastName#,
            #credits#)
    <selectKey resultClass="int" keyProperty="value">
      select last_insert_id() as value
    </selectKey>
    </statement>

But this doesn't work. The project doesn't even start in Tomcat/Eclipse.

In eclipse it gives this error msg: "The content of element type must
match
(include|dynamic|and a whole lot more...)"

I'm no expert at Ibatis, but when I normally would do an insert, I would
use
<insert id="xxxx" parameterClass...etc> I don't really understand why
<statement id="xxxx" parameterClass...etc> is used.

I'm using Ibatis version 2.3.4

Any ideas what could be wrong here? Thanks a million!


CORRECTION

select last_insert_id()

Damn these fat fingers

--- On Fri, 2
-- 
View this message in context:
http://old.nabble.com/insert-going-wrong-after-going-from-Sybase-to-MySQ
L-tp27274795p27280982.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message