Mapping documents:
I am facing probs Accessing SP from NHibernate
callable throws me an error .
can some body pls help me.
and tell me how to access SP's
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="TestNIHIBwithFireBird.BookDetails,TestNIHIBwithFireBird" table="Books" >
<id name="BOOKID" column="BOOKID" type="Int32" unsaved-value="0">
<generator class="increment" />
</id>
<property name="BOOKNAME" column="BOOKNAME" type ="String" length="40"/>
<property name="AUTHOR" column="AUTHOR" type ="String" length="20"/>
<property name="PUBLICATION" column="PUBLICATION" type ="String" length="20"/>
<property name="PRICE" column="PRICE" type ="Int32" length="15"/>
</class>
<sql-query name="TESTSELECTSP" callable="true" check="none">
<return class="TestNIHIBwithFireBird.BookDetails,TestNIHIBwithFireBird">
<return-property name="BookId" column="BookId"/>
<return-property name="BookName" column="BookName"/>
<return-property name="Author" column="Author"/>
<return-property name="Publication" column ="Publication"/>
<return-property name="Price" column ="Price"/>
</return>
<![CDATA[
{call TESTSELECTSP()}
]]>
</sql-query>
</hibernate-mapping>
|