Hibernate Community • View topic - translating sql to hql problem

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

translating sql to hql problem

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

indie_life

Post subject: translating sql to hql problem

Posted: Fri May 09, 2008 11:22 am

Newbie

Joined: Wed May 02, 2007 6:37 am
Posts: 6

Dear All,

I am having problems translating the following SQL query into HQL:

Code:

UPDATE Table1 AS one SET col1 = two.col2
FROM Table2 AS two
WHERE two.col1 LIKE one.col2
[/code[

The query is updating table one based on the results of the select query. HIbernate doesnt like the use of FROM in this query. A subquery will generate more than one row in this instance. Any ideas would be great!

Top

Page 1 of 1

[ 1 post ]

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