CODEWITHSUNDEEP
javasqloracle-databasehibernate
Imran Qadir Baksh - Baloch
Imran Qadir Baksh - Baloch

Reputation: 34064

Execute Insert and Select queries simultaneously from Hibernate

I have the following pl/sql query,

INSERT INTO Table(ID,..................) 
VALUES(SEQ.nextval,....................); 
SELECT SEQ.currval ID FROM DUAL;

I need to get ID using hibernate. I am using the following query which showing error,

.....getDataSession().createSQLQuery(hQuery).list()

Any one help me.

Upvotes: 0

Views: 1556

Answers (1)

danny.lesnik
danny.lesnik

Reputation: 18639

Create new Object and save it using session.save() method it will return this object id.

 Object object = new Object();
    //add object properties 
    object.setXXX(value);
    //now save the object   
    String id =(String)getDataSession().save(object);

Hope it helps.

Upvotes: 1

Related Questions