( IBatis ) After inserting values into database ibatis is returning null

[Praveen Sangolli]

I have this code in my Enquiry.xml file

<insert id="saveEnq" parameterClass="EnquiryBean123">
    insert into user_enquiry (
    Name,
    Email,
Phone,
Course,
 DoEnq, 
Media
     )
      
    values (
      #name#, #email#, #contactNumber#, #course#, #dateOfEnquiry#, #media#
    )
  </insert>
 

 
Reader r =Resources.getResourceAsReader("com/data/SqlMapConfig.xml");
sqlMapClient =SqlMapClientBuilder.buildSqlMapClient(r);
r.close();
Integer i=(Integer) sqlMapClient.insert("saveEnquiryDetails", enq);
 
the reurn type for sqlMapClient.insert("saveEnquiryDetails", enq) is always null;

can anyone help me on how to get a value or a confirmation after successfully inserting data into DataBase...

[Dhananjay Patkar]

Hey,
Use <selectKey> ibatis tag ,Then you will achieve what you are expecting.
Its child tag of <insert>.

Cheers,
Dhananjay

[Abhie Singh]

i have a question
i am using ibatis insert with JTA trasaction.
My insert is not getting committed though i am using startTransaction commitTrasaction and endTrasaction(in finally block)

Also got to know that ibatis insert returns null.
If ibatis insert returns some value, will it commit the trasaction?

I have been using same code on stand alone java program using JDBC type driver and it is commiting.