ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randle <vikasvirgo...@yahoo.com>
Subject Unknown output datatype:-99999999 while calling Procedure VIA Ibatis
Date Wed, 30 Dec 2009 06:42:57 GMT

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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message