Tuesday, 15 June 2010

java - iBatis insert statement throwing NPE -



java - iBatis insert statement throwing NPE -

i new ibatis. in project using ibatis persist java objects in oracle db. have class, classa, having 3 columns : id, name , description. info going persisted in tablea. there sequence in db generate value id column in table. wrote insert statement table follows,

<insert id="inserttablea" parameterclass="com.classa"> <selectkey resultclass="java.lang.long" keyproperty="id"> select seq_tablea.nextval id dual </selectkey> insert tablea(id, name, description) values (#id#, #name#, #description#) </insert>

this worked fine.

but becaude of our inhouse ui framework limitation had alter design. need first generate id long sequence, set value in instance of classa along name , description , insert db. in case insert statment doesn not need selectkey attribute. id, name , description values in object. when updated query below, throwing null pointer exception.

<insert id="inserttablea" parameterclass="com.classa"> insert tablea(id, name, description) values (#id#, #name#, #description#) </insert>

how can insert info table without using . generating key sequence first , populate object values including id , trying phone call statement java follows,

getsqltemplate().insert("process.inserttablea", instanceclassa);

any pointers welcome,

thanks, sd

just sure, did include getid() method in classa class homecoming value of id field?

java ibatis ibator

No comments:

Post a Comment