Your code would be useful. The code from the dev guide...not so much. :) Larry
On Mon, Feb 1, 2010 at 2:51 AM, rajnishp <hi_rajn...@yahoo.com> wrote: > > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@ibatis.apache.org For additional commands, e-mail: dev-h...@ibatis.apache.org
