Hibernate Community • View topic - Hibernate, HQL INSERT INTO SELECT Subquery, Alias

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate, HQL INSERT INTO SELECT Subquery, Alias

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ihusr

Post subject: Hibernate, HQL INSERT INTO SELECT Subquery, Alias

Posted: Wed Jun 28, 2017 2:59 pm

Newbie

Joined: Wed Jun 28, 2017 2:51 pm
Posts: 1

Code:

 INSERT INTO TableA(id,key,value) SELECT c.id,(SELECT key FROM TABLEB WHERE ID=c.ID),c.name FROM TABLEC c

c.ID not correct conversion alias in the subquery

Top

vlad

Post subject: Re: Hibernate, HQL INSERT INTO SELECT Subquery, Alias

Posted: Thu Jun 29, 2017 12:53 am

Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1628
Location: Romania

Try to elaborate your question with mappings and data access code because it's not clear what's the problem.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum