Execute Insert and Select queries simultaneously from Hibernate

Question

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.

Go read the documentation about auto-generated IDs. This should be handled automatically by Hibernate. Don't use SQL queries: you're defeating the purpose of using Hibernate. docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single — JB Nizet
– JB Nizet, Commented Oct 4, 2011 at 14:14
I am not using any class. I am using createSQLQuery. Can you please update my code if possibel or it is impossible with createSQLQuery. I am very new in hibernate. Hopefully you will help me. — Imran Qadir Baksh - Baloch
– Imran Qadir Baksh - Baloch, Commented Oct 4, 2011 at 14:23
Don't use Hibernate as a mean to execute SQL queries. That's not its goal. Use straight JDBC if you want to do that. If you want to use Hibernate, use it as intended, by defining persistent entities and persisting them. — JB Nizet
– JB Nizet, Commented Oct 4, 2011 at 14:29
OK, Will this means that SEQ.currval will be automatically return? Can you provide me a link about auto generte IDs. Thanks, BTW. — Imran Qadir Baksh - Baloch
– Imran Qadir Baksh - Baloch, Commented Oct 4, 2011 at 14:32
I already did. But here it goes again: docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single — JB Nizet
– JB Nizet, Commented Oct 4, 2011 at 14:35

danny.lesnik · Accepted Answer · 2011-10-04 14:13:39Z

1

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.

answered Oct 4, 2011 at 14:13

danny.lesnik

18.6k31 gold badges142 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Imran Qadir Baksh - Baloch Over a year ago

I am using createSQLQuery. Can you please tell me where should I place my sql? I am not using any class

danny.lesnik Over a year ago

Please read @JB Nizen comment he is 100% right :) don't use Hibernate in this case this is ORM application.

Collectives™ on Stack Overflow

Execute Insert and Select queries simultaneously from Hibernate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related