insert always returning null (urgent )

[Yuvraj Shinde]

Hi all 

 

 I am using insert query. it is always returning a null value. how to
get the value of inserted object?

 

 Following is mine insert statement

 

  <insert id="LIMNAME_INSERT"
parameterClass="com.sungard.energy.zainet.shared.business.domain.Limname
DTO" >

    insert into LIMNAME (AUDIT_ACTIVE, AUDIT_AGEN, AUDIT_AOP0,
AUDIT_ADATE0, AUDIT_ATIME0,

      AUDIT_AOP1, AUDIT_ADATE1, AUDIT_ATIME1, AUDIT_ALF, AUDIT_AOHM,
AUDIT_ROHM, AUDIT_REFRESH,

      AUDIT_ZKEY, AUDIT_XKEY, AUDIT_UTIL1, AUDIT_UTIL2, LIMNAME_NAME,
LIMNAME_DSC, LIMNAME_FILTER,

      LIMNAME_FILTERA, LIMNAME_FILTERB, LIMNAME_FILTERC,
LIMNAME_RUNVIEW)

    values (#active:DECIMAL#, #agen:DECIMAL#, #aop0:CHAR#,
#adate0:TIMESTAMP#,

      #atime0:DECIMAL#, #aop1:CHAR#, #adate1:TIMESTAMP#,
#atime1:DECIMAL#,

      #alf:TIMESTAMP#, #aohm:TIMESTAMP#, #rohm:TIMESTAMP#,
#refresh:DECIMAL#,

      #zkey:DECIMAL#, #xkey:DECIMAL#, #util1:DECIMAL#, #util2:DECIMAL#,

      #limnameName:VARCHAR#, #limnameDsc:VARCHAR#,
#limnameFilter:VARCHAR#,

      #limnameFiltera:VARCHAR#, #limnameFilterb:VARCHAR#,
#limnameFilterc:VARCHAR#,

      #limnameRunview:CHAR#)

  </insert>

 

 Regards

 Yuvraj

Yuvraj Shinde * Senior Software Engineer -  Zainet*  SunGard * Offshore
Services * Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati Bapat
Road, shivajinagar,Pune 411016 Tel Direct +91 20 66248045 * Main +91 20
66248000 * Fax +91 20  25606222 [EMAIL PROTECTED]
<blocked::mailto:[EMAIL PROTECTED]>  * www.sungard.com
<blocked::http://www.sungard.com>