Hibernate Community • View topic - Insert Statement Not working in HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Insert Statement Not working in HQL

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

prashant_mishra8

Post subject: Insert Statement Not working in HQL

Posted: Mon Aug 25, 2008 2:51 am

Newbie

Joined: Thu Jul 17, 2008 2:16 am
Posts: 11

Hi,
I am trying to insert a row in my table but it doesn't work and gives the error unexpected token: VALUES .

My query is:

INSERT INTO Trnhst(xwbccd,
xwe4nb, xwricd, xwc8dt, xwbncd, xwbdcd, person, xwaacs, xwabcd, xwagcd, xwahcd, xwaicd,
xwt8tx, xwordn, xwa5qt, xwvalu) VALUES('ACC44', 00200201, 'INV', 9, 'AG', 'USA', 'STU', 'USA',
'000078', '22', '30', '39', 'PR123', 12, 6.0, 77.94)

Plz Help me its very urgent
Thanks

Top

nordborg

Post subject:

Posted: Mon Aug 25, 2008 3:20 am

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

For inserts, only the INSERT INTO ... SELECT ... form is supported. Read http://www.hibernate.org/hib_docs/v3/re ... tch-direct for more information.

Top

prashant_mishra8

Post subject: Thanks

Posted: Mon Sep 22, 2008 4:13 am

Newbie

Joined: Thu Jul 17, 2008 2:16 am
Posts: 11

Thanks for the help

Top

hibertom

Post subject: Re: Insert Statement Not working in HQL

Posted: Sat May 09, 2009 4:50 am

Newbie

Joined: Sat May 09, 2009 4:44 am
Posts: 2

And if you really need this, you can use SQLQuery query = session.createSQLQuery("inser into xxx () values ()"); I am using it for many-to-many relation changes without version increase

Top

Page 1 of 1

[ 4 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