[
https://issues.apache.org/jira/browse/IBATIS-383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Butler closed IBATIS-383.
------------------------------
Resolution: Invalid
Not a bug - this was related to intermediate result sets in the SP. Use the
IGNORE_DONE_IN_PROC driver setting to fix.
> IBATIS - SYBASE Stored Procedure NULL POINTER EXCEPTION
> -------------------------------------------------------
>
> Key: IBATIS-383
> URL: https://issues.apache.org/jira/browse/IBATIS-383
> Project: iBatis for Java
> Issue Type: Bug
> Environment: I am Using WAS5.1,Window Platform, IBATIS, SYBASE
> Reporter: Aravind
> Priority: Minor
>
> I have a Stored Procedure which insert Data into a Table and a Select
> statement after that which returns the identity Column value back.
> The following is the Parameter Map i am using Object
> <!--Procedure to Save in Transaction Master STARTS -->
> <resultMap id="saveTransactionResult" class="Transaction">
> <result property="transactionId" column="TXN_ID"/>
> </resultMap>
> <parameterMap id="saveTransactionParam" class="Transaction">
> <parameter property="assetInformation.price" jdbcType = "INTEGER"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="profile.profileId" jdbcType = "VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="transactionType" jdbcType = "VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="assetInformation.draftFlag" jdbcType = "VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="account.accountNumber" jdbcType = "VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="assetInformation.assetId" jdbcType = "VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="userId" jdbcType = "VARCHAR" javaType="java.lang.String"
> mode="IN"/>
> </parameterMap>
> <procedure id="SAVE_TRANSACTION" parameterMap ="saveTransactionParam"
> resultMap="saveTransactionResult">
> { call sp_savetransaction(?,?,?,?,?,?,?) }
> </procedure>
> Java Code where i make the Call to Stored Procedure is below..
> Transaction tran = (Transaction)queryForObject(SAVE_TRANSACTION,
> transactionDto.getTransaction());
> I am using QueryforObject Method to Invoke the Stored Procedure.
> Whenever the Stored Procedure has Select statements alone.. I am getting back
> the Object with Data...But if the Stored Procedure is having Insert
> Statements and then a select Statement ..The Object is not Returned and
> giving NULL POINTER Exception while trying to Access the Object. But
> Eventhough i get no object back the Insert Statement get executed
> Successfully and i can see the Details in the Table.
> Please help me on this Issue as we are not able to Proceed further...and we
> are falling behind on our deadline dates for the project to go into Prodn due
> to this issue...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
