-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: question about native SQL
PostPosted: Thu Nov 04, 2004 7:10 pm 
Newbie

Joined: Thu Sep 30, 2004 5:35 pm
Posts: 7
Hi

I am sure this question might have already asked/answered. If someone can point me any documentation or answer that will be great.

Basically, I would like to write a native SQL using hibernate to update selective columns in one of my tables. Eg, I have a table TableA with 132 columns and I want to update only few columns, like modified_dt. When I use HIbernate its HQL updates all the columns of this table (or only modified columns when I use dynamic-update). But I want to write the SQL like
update TableA set Modified_dt = CURRENT TIMESTAMP.

Currently I am using separate JDBC connection to achieve this.

Please help me.

Thanks


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.