ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rajnishp <hi_rajn...@yahoo.com>
Subject IBatis2.3.4 throws : java.sql.SQLException: Invalid column type when property is not set in POJO while inserting data.
Date Mon, 01 Feb 2010 09:51:53 GMT

IBatis throws SQL exception while inserting data using InlineParameterMap

The error occurred while applying a parameter map.
--- Check the insertAllocationInstruction-InlineParameterMap.
--- Check the parameter mapping for the 'userID' property.
--- Cause: java.sql.SQLException: Invalid column type

Ibatis throws error because the attribute userID is not set while inserting
data in database(Oracle 10g).
After doing googling I got help in
Solution provided :--
                      <statement id=”insertProduct”
                       insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
                      values (#id:NUMERIC:-999999#,
Providing Default value if attribut not set.

This solution is not working.

Please provided correct solution solution (Only by IBatis not setting
default value in POJO)

Thanking In Advance.

View this message in context: http://old.nabble.com/IBatis2.3.4-throws-%3A-java.sql.SQLException%3A-Invalid-column-type-when-property-is-not-set-in-POJO-while-inserting-data.-tp27401733p27401733.html
Sent from the iBATIS - Dev mailing list archive at Nabble.com.

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

View raw message