I have a JAVA code calling a SP in SQL Server through IBATIS. the procedure
expects around 26params and one of them is OUT. While executing the
procedure, i am getting "Unknown output datatype:-99999999" error. Nothing
else is provided in terms of error details. The snippet of my XML looks like
<resultMap class="java.util.HashMap" id="insertIDEAPrincipalResults">
<result property="id" column="ID"/>
</resultMap>
<parameterMap class="java.util.Map" id="insertIDEAPrincipalParameters">
<parameter property="MerchantNumber" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="OwnershipPercentage" jdbcType="INTEGER"
javaType="java.lang.Integer" />
<parameter property="FirstName" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="MiddleInitial" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="LastName" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="Suffix" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="BirthDate" jdbcType="DATE"
javaType="java.util.Date"
/>
<parameter property="SocialSecurityNumber" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="DriverLicenseNumber" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="DriverLicenseState" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="DriverLicenseExpirationDate"
jdbcType="DATE"
javaType="java.util.Date" />
<parameter property="ResidenceAddress1" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidenceAddress2" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidenceCity" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidenceState" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidencePostalCode" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidencePhoneNumber" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="ResidenceRentOwn" jdbcType="INTEGER"
javaType="java.lang.Integer" />
<parameter property="ResidenceEstablishmentDate" jdbcType="DATE"
javaType="java.util.Date" />
<parameter property="PrimaryPrincipal" jdbcType="INTEGER"
javaType="java.lang.Integer" />
<parameter property="AdditionalBusinessName1" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="OwnershipPercentage1" jdbcType="INTEGER"
javaType="java.lang.Integer" />
<parameter property="AdditionalBusinessName2" jdbcType="VARCHAR"
javaType="java.lang.String" />
<parameter property="OwnershipPercentage2" jdbcType="INTEGER"
javaType="java.lang.Integer" />
<parameter property="TotalLiquidAssets" jdbcType="INTEGER"
javaType="java.lang.Long" />
<parameter property="ID" jdbcType="INTEGER"
javaType="java.lang.Integer"
mode="OUT" />
</parameterMap>
<procedure id="insertIDEAPrincipal"
parameterMap="insertIDEAPrincipalParameters">
{call
dbo.InsertIDEAPrincipal(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
</procedure>
Please help.
--
View this message in context:
http://old.nabble.com/Unknown-output-datatype%3A-99999999-while-calling-Procedure-VIA-Ibatis-tp26964568p26964568.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
