Problem in SP Calling using Hibernate

[Venkat Raman Parasuraman]

Hi,

Kindly give suggestion for the below error.

Iam calling a stored function using Hibernate. My calling always throws invalid column index. But the same is executed in SQL Delveloper. Please find the HBM entry below.

 

<sql-query name="getContactCentres" callable="true">
		<return class="com.tnt.ContactCentreDTOImpl" alias="c">
			<return-property name="businessLocationId"
				column="BUL_CSYS_ID" />
			<return-property name="contactCentreTypeId"
				column="KNC_TYPE_CD" />

		</return>



		<![CDATA[{
		 CALL TEP00001.Execute001 (:CountryId, :ContactCentreTypeId,:employeeId,:groupId,:pageNumber,:size,:orderBy) 
		}]]>






	</sql-query>

I am setting the parameters for the above query. I get the below exception...



Hibernate: {
CALL TEP00001.Execute001 (?, ?,?,?,?,?,?)
}
Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
at com.tnt.FastLaneReaderImpl.executeSP(FastLaneReaderImpl.java:41)
at com.tnt.TestSP.main(TestSP.java:13)




Caused by: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OraclePreparedStatement.setNullInternal(OraclePreparedStatement.java:3662)
at oracle.jdbc.driver.OracleCallableStatement.setNull(OracleCallableStatement.java:4145)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:76)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:65)
at org.hibernate.loader.Loader.bindNamedParameters(Loader.java:1748)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 8 more