Hibernate 3

Hello!
I create a store procedure in SQLServer 2000 call SPINSERT and do the mapping, see:

<sql-insert callable="true">{spinsert ?, ?}</sql-insert>
or
<sql-insert callable="true">{exec spinsert ?, ?}</sql-insert>
or
<sql-insert callable="true">{spinsert (?, ?)}</sql-insert>
or
<sql-insert callable="true">{exec spinsert (?, ?)}</sql-insert>

all the ways it occurs this exception:

Hibernate: {exec spinsert ?, ?}
WARN JDBCExceptionReporter:57 - SQL Error: 0, SQLState: 22019
ERROR JDBCExceptionReporter:58 - Unrecognized SQL escape 'exec' at line position 10.

Obs: To exeute a store procedure on SQLServer I use command "exec" ou "execute", so can´t I use command "call".

If somebody help...
Thanks

well - we just execute the query as any other callable statement.

dont know how exec/spinsert differs from callable ?

.max

See my program:

Store Procedure in SQLServer

CREATE PROCEDURE spinsert
@nomPartido varchar(50),
@sglPartido char(10),
@return int output
AS
insert into partido (nomPartido, sglPartido) values (@nomPartido,@sglPartido)
set @return = @@identity
return @return
GO

Mapping:

hibernate-mapping>
<class name="br.com.camara.camadanegocio.negocio.to.PartidoTO" table="partido">
<id name="codigo" column="idePartido" type="integer">
<generator class="native" />
</id>
<property name="nomePartido" column="nomPartido" type="string"/>
<property name="sigla" column="sglPartido" type="string"/>

<sql-insert callable="true">{call spinsert ?, ?, 0}</sql-insert>
</class>
</hibernate-mapping>

Now i try run with "call" and happend this exception:

Hibernate: {call spinsert ?, ?, 0}
ERROR PersistenciaManager:128 - Durante SAVE
org.hibernate.HibernateException: The database returned no natively generated identity value

Thank for your help

yes - please read the stacktrace!

"The database returned no natively generated identity value"

so you have mapped you pojos to have ids using the native generator.
So, the stored procedure needs to return to hibernate which id it assigned to the object.