File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Clustered columns  confusion in MS SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Clustered columns  confusion in MS SQL" Watch "Clustered columns  confusion in MS SQL" New topic
Author

Clustered columns confusion in MS SQL

Chinmay Bajikar
Ranch Hand

Joined: Dec 08, 2001
Posts: 159
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


The strength of the Wolf is the pack & the strength of the pack is the wolf....Rudyard Kipling
Chinmay Bajikar
Ranch Hand

Joined: Dec 08, 2001
Posts: 159
hi,
Anybdy got any ideas on this???
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Clustered columns confusion in MS SQL