Help needed for executing Sybase stored procedure using Hibernate

[Yaman Kalyani]

I need some help on stored procedure. I am getting exception on this. Someone plsease help.

I have a simple stored procedure in sybase which returns a sequence number.

The arguments for the procedure are Name of type string and Count of type integer.

The underlying table has Columns String and SeqNo. What the procedure does is, increment SeqNo by the specified count for a given Name.

 
CREATE PROC stpGetNextSeqNo
(
   @Name   char(20), 
   @Count  int = 1 
)
as
declare @SeqNo int
 
begin tran
 
       UPDATE  NextSeqNo
       SET     SeqNo  = SeqNo + @Count
       WHERE   Name     = @Name
 
       if @@error != 0
       begin
  rollback tran
  select @SeqNo = -1
       end
       else
  commit tran
       end
 
       return @SeqNo
end

My mapping file looks like this

 
<?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>
<class name="packagename.NextSeqNo" table="NextSeqNo">
<id name="name" type="string" column="Name" >
   <generator class="assigned"/>
  </id>
  <property name="seqNo">
         <column name="SeqNo" />
  </property>
</class>
<sql-query name="getNextID_SP">
    <return alias="number" class="packagename.NextSeqNo">
    <return-property name="seqNo" column="SeqNo"/>
     <return-property name="name" column="Name"/>
    </return>
    ? = call stpGetNextSeqNo(:Id, :Increment)
</sql-query>
</hibernate-mapping>
 

My class looks like

 
public class NextSeqNo {
 
    int seqNo;
    String name;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getSeqNo() {
        return seqNo;
    }
    public void setSeqNo(int seqNo) {
        this.seqNo = seqNo;
    }
    
    
}

My Main looks like this.

 
public static void main(String[] args) {
Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = session.beginTransaction();
ScrollableResults results = session.getNamedQuery("getNextID_SP").setParameter("Id", "PrdId").setParameter("Increment", new Integer(1)).scroll() ;
}