This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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