muharremtac.com

Calling SQL Server 2005 Stored Procedure with Hibernate

My environment : Java5, Hibernate 3, Spring 2.0.5, Eclipse Europa (3.3),Tomcat 6, SQL Server 2005 Express

Procedure
---------------------------------------------------------
CREATE PROCEDURE PROCEDURE_DENEME
@anchor varchar(10)
AS
SELECT ANCHOR, BASLIK
FROM ANASAYFA
WHERE ANCHOR=@anchor


Mapping
-------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping
DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.btdeneyim.model">
<class name="Anasayfa" table="ANASAYFA" lazy="false">
<cache usage="nonstrict-read-write"/>
<id name="id" column="METIN_ID" type="integer">
<generator class="identity"/>
</id>
<property name="baslik" column="BASLIK" length="255" type="string"/>
<property name="anchor" column="ANCHOR" length="255" type="string"/>
</class>

 

<sql-query name="procedureCalistir" callable="true">
{call PROCEDURE_DENEME(?)}
</sql-query>

DAO Method
------------------------------------------------------
public List procedureCalistir() {
Query queryObj =getHibernateTemplate().getSessionFactory().getCurrentSession().getNamedQuery("procedureCalistir");
queryObj.setParameter(0, "deneme");
List procedureList = queryObj.list();
return procedureList;


DATA SOURCE CONFIGURATION

-------------------------------------------------------

<Resource name="jdbc/btdeneyim" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" username="sa" password="xxxxx" url="jdbc:sqlserver://localhost:1433;databaseName=BTDENEYIM" defaultAutoCommit="true" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>