Hi,
i want to use the selectKey within a insert via java annotation.

my first try was something like this:
@Insert( { "INSERT INTO city (postcode,city)",
                        "VALUES (#{postcode},#{city})",
                        "<selectKey keyProperty=\"id\" order=\"AFTER\" 
resultType=\"int\">",
                                "SELECT cast(last_value as int) AS value",
                                "FROM city_id_seq",
                        "</selectKey>"          
        })

which failed (org.postgresql.util.PSQLException: ERROR: syntax error at or
near "<")

I Read that selectKey within annotations should somehow be possible at 
http://opensource.atlassian.com/confluence/oss/display/IBATIS/iBATIS+3.0+Whiteboard#iBATIS3.0Whiteboard-ConfigurationwithAnnotations
ibatis wiki 

please give me a hint :-(
-- 
View this message in context: 
http://www.nabble.com/selectKey-in-annotation-tp25267744p25267744.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


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

Reply via email to