Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Clustered columns confusion in MS SQL

 
Chinmay Bajikar
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,
I understand this is more of an MS SQL issue than a JDBC issue,but I havent
been able to find the reason as to why this happens.
the trouble is,I am firing the following query,
"update LOG_HDR set MSG=?, COMMENT=?, SIZE=? , CONTENTS=? ,AUDIT=? where ID=? "
In this query, ID is a primary key clustered column.
All the columns being updated are varchar,except for CONTENTS,which
is an Image type column.
On firing this Query,I get an exception.
On doing some search,I found that ID is clustered and clustered keys have problems in updates.(Wht problems..I dont know)
But on removing the Clustered constraint,we could fire the Query properly
w/o any hassles.
But even though I made the code to work,I fail to understand what is the issue.
Plzzz let me know if anybdy has any clues,
Thanks,
Chinmay
 
Chinmay Bajikar
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
Anybdy got any ideas on this???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic