I'm reviving this thread, given that the author resolved their issue, but I have a very similar issue and can not get it working.
Due to legacy, I am using stored procedures for CRUD with SQL Server 7.0 and the jTDS driver (v1.0.3). I am having a problem with my <sql-insert>. When I put custom SQL inside this tag everything works fine. But when I put a call to my stored proc inside, I am getting the following stack trace:
org.hibernate.HibernateException: The database returned no natively generated identity value
at org.hibernate.id.IdentifierGeneratorFactory.getGeneratedIdentity(IdentifierGeneratorFactory.java:33)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1761)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:468)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:463)
at org.springframework.orm.hibernate3.HibernateTemplate$18.doInHibernate(HibernateTemplate.java:615)
my class:
public class Patient {
private Integer id;
private String firstName;
private String lastName;
public Patient() {}
public Integer getId() {return id;}
private void setId(Integer id) {this.id = id;}
public String getFirstName() {return firstName;}
public void setFirstName(String firstName) {this.firstName = firstName;}
public String getLastName() {return lastName;}
public void setLastName(String lastName) {this.lastName = lastName;}
}
<hibernate-mapping>
<class name="edu.ucsf.memory.lava.model.Patient">
<id name="id">
<column name="PIDN" not-null="true"/>
<generator class="native"/>
</id>
<property name="firstName" column="FName"/>
<property name="lastName" column="LName"/>
<loader query-ref="spPatientNameOnlyView"/>
<sql-insert callable="true">{call spPatientNameOnlyAdd (?, ?)}</sql-insert>
<sql-update callable="true">{? = call spPatientNameOnlyUpdate (?, ?, ?)}</sql-update>
<sql-delete callable="true">{? = call spPatientNameOnlyDelete (?, ?)}</sql-delete>
</class>
</hibernate-mapping>
The above throws the:
The database returned no natively generated identity value exception.
But if I remove <sql-insert> altogether or put substitute this:
<sql-insert>insert into patient (fname, lname) values (?, ?)</sql-insert>
things work fine and the id is generated properly. I can see that Hibernate is calling:
SELECT @@IDENTIFY AS ID
but for some reason it does not do this if I call a stored procedure. Unfortunately I can not use the SelectGenerator because there are no other keys (and for some reason, I can't get Select Generator to work anyways)
The stored proc is:
CREATE PROCEDURE spPatientNameOnlyAdd @LName varchar(25), @FName varchar(25) AS
INSERT INTO patient (LName, FName) values (@LName, @FName)
RETURN 1
Any ideas ? Any restrictions on the stored procedure, or perhaps jTDS driver settings ?
Thanks,
Charlie
Login
FAQ
Search
