Hibernate version:
hibernate3.jar (april 18th?)
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping default-lazy="false">
<class name="com.X" mutable="false" table="x" >
<id name="id" column="x_id" type="int"/>
<loader query-ref="selectXByY"/>
</class>
<sql-query name="selectXByY" callable="true">
<return alias="xz" class="com.X" lock-mode="none">
<return-property name="id" column="x_id"/>
</return>
select_x_by_y(?)
</sql-query>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():Code:
Query query = session.getNamedQuery("selectXbyY");
query.setInteger(0, bean.getY());
query.setFirstResult(bean.getFirstResult());
query.setMaxResults(bean.getMaxResults());
return query.list();
Full stack trace of any exception that occurs:
java.sql.SQLException: Invalid parameter index 1.
Name and version of the database you are using:
mssql2k jtds 1.0.3
The generated SQL (show_sql=true):
Hibernate: select top 10_x_by_y(?)
It makes sense for this not to work - but from an API user's perspective,
it looks like it should work.
Should this be added to to the ref section:
16.3.2.1. Rules/limitations for using stored procs
Or am I missing something here?
Login
FAQ
Search
