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

Hi,
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
http://ibatisnet.sourceforge.net/DevGuide.html
Solution provided :--
                      <statement id=”insertProduct”
parameterClass=”product”>
                       insert into PRODUCT (PRD_ID, PRD_DESCRIPTION)
                      values (#id:NUMERIC:-999999#,
#description:VARCHAR:NO_ENTRY#);
                      </statement>
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


Mime
View raw message