Hibernate Community • View topic - UPDATE TABLE SET... FROM ...

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

UPDATE TABLE SET... FROM ...

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

alexkun

Post subject: UPDATE TABLE SET... FROM ...

Posted: Mon Dec 26, 2011 8:20 pm

Newbie

Joined: Mon Oct 24, 2011 5:46 pm
Posts: 3

Hi. I can do in a HQL:

Code:

INSERT INTO Bean (pro1,pro2,pro3,n) SELECT ... FROM ...

but I can't do

Code:

UPDATE Bean SET pro1 = b.pro2 FROM Bean b WHERE ...

i catch the next error:

line 3:1: unexpected token: FROM
Error
java.lang.IllegalArgumentException: node to traverse cannot be null!

Thanks

Top

kajh

Post subject: Re: UPDATE TABLE SET... FROM ...

Posted: Thu Dec 29, 2011 5:50 am

Beginner

Joined: Tue Aug 16, 2005 3:44 pm
Posts: 33

alexkun wrote:

Code:

UPDATE Bean SET pro1 = b.pro2 FROM Bean b WHERE ...

Hi :)

I'm have not testet the following code but what about something like

Code:

UPDATE Bean SET pro1 = pro2 WHERE...

-Kaj :)

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