ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From StevenF <ste...@web2.filipowicz.com>
Subject RE: insert going wrong after going from Sybase to MySQL
Date Sat, 23 Jan 2010 22:20:43 GMT

Hi Guys,

Still no luck here.

I have this, but doesn't work:
----------------------------
    <statement id = "insertChesser"
parameterClass="nl.chessone40.domain.Chesser" >
    <selectKey resultClass="int" keyProperty="chesserId">
      select last_insert_id() as value
    </selectKey>    
        INSERT INTO Chesser
            (login,
            password,
            firstName,
            lastName,
            credits)
        values
            (#login#,
            #password#,
            #firstName#,
            #lastName#,
            #credits#)
    </statement>
----------------------------

Also tried:
----------------------------
    <insert id = "insertChesser"
parameterClass="nl.chessone40.domain.Chesser" >
    <selectKey resultClass="int" keyProperty="chesserId">
      select last_insert_id() as value
    </selectKey>    
        INSERT INTO Chesser
            (login,
            password,
            firstName,
            lastName,
            credits)
        values
            (#login#,
            #password#,
            #firstName#,
            #lastName#,
            #credits#)
    </insert >
---------------------------

This gives an error:
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state
[null]; error code [0]; Insert statements cannot be executed as a query.;
nested exception is java.sql.SQLException: Insert statements cannot be
executed as a query.

What is the difference between <statement id="...> and <insert id="...> ?

Thanks for the help!!


Niels Beekman-2 wrote:
> 
> 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
>  
> 
> 

-- 
View this message in context: http://old.nabble.com/insert-going-wrong-after-going-from-Sybase-to-MySQL-tp27274795p27290482.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


Mime
View raw message