You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Jeff Butler (JIRA)" <ib...@incubator.apache.org> on 2007/01/18 17:51:30 UTC
[jira] Closed: (IBATIS-383) IBATIS - SYBASE Stored Procedure NULL
POINTER EXCEPTION
[ 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