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-unsubscr...@ibatis.apache.org For additional commands, e-mail: dev-h...@ibatis.apache.org
