Hi
I am having a primary key in my table as Clustered
But when I fire an SQL Update (I am updating an Image type column!) Query through my Java (JDBC) code,I get an exception
If the same column was not clustered then the exception doesnt appear and update fires properly
Any ideas why something like this should happen
Thanks in Adv
ChinmayHi
What kind of exeption did you get?
Do you have PRIMARY KEY on image type column?
"Chinmay" <anonymous@.discussions.microsoft.com> wrote in message
news:770F912B-465B-499E-B5BC-E21D67787B42@.microsoft.com...
> Hi,
> I am having a primary key in my table as Clustered.
> But when I fire an SQL Update (I am updating an Image type column!) Query
through my Java (JDBC) code,I get an exception.
> If the same column was not clustered then the exception doesnt appear and
update fires properly.
> Any ideas why something like this should happen.
> Thanks in Adv,
> Chinmay|||I got it some weeks back
Yes and i dont have a Primary Key on Image column
The Primary Key is on a normal varchar column.
The thing is now I dont get it
Also the exception that I got was comething like "Could not prepare a Query Plan for clustered.....
Also I found this artical on the Microsoft site...(but I m confused still
"http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;818729
Thanks
Chinma
-- Uri Dimant wrote: --
H
What kind of exeption did you get
Do you have PRIMARY KEY on image type column
"Chinmay" <anonymous@.discussions.microsoft.com> wrote in messag
news:770F912B-465B-499E-B5BC-E21D67787B42@.microsoft.com..
> Hi
> I am having a primary key in my table as Clustered
> But when I fire an SQL Update (I am updating an Image type column!) Quer
through my Java (JDBC) code,I get an exception
> If the same column was not clustered then the exception doesnt appear an
update fires properly
> Any ideas why something like this should happen
>> Thanks in Adv
> Chinma|||Hi
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/reskit/sql7res/part9/sqc13.asp
"Chinmay" <anonymous@.discussions.microsoft.com> wrote in message
news:CB5EF10C-6B9E-4591-BDBD-05C9C739482E@.microsoft.com...
> I got it some weeks back.
> Yes and i dont have a Primary Key on Image column.
> The Primary Key is on a normal varchar column.
> The thing is now I dont get it.
> Also the exception that I got was comething like "Could not prepare a
Query Plan for clustered....."
> Also I found this artical on the Microsoft site...(but I m confused
still)
> "http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;818729"
> Thanks,
> Chinmay
>
> -- Uri Dimant wrote: --
> Hi
> What kind of exeption did you get?
> Do you have PRIMARY KEY on image type column?
> "Chinmay" <anonymous@.discussions.microsoft.com> wrote in message
> news:770F912B-465B-499E-B5BC-E21D67787B42@.microsoft.com...
> > Hi,
> > I am having a primary key in my table as Clustered.
> > But when I fire an SQL Update (I am updating an Image type column!)
Query
> through my Java (JDBC) code,I get an exception.
> > If the same column was not clustered then the exception doesnt
appear and
> update fires properly.
> > Any ideas why something like this should happen.
> >> Thanks in Adv,
> > Chinmay
>
>|||thanks Uri for the link...
But have u or anybdy have come across succha problem bfor
I just realised that I have 2 Image columns being updated and the clustered column is in the where clause
The whole issue is that we are not able to regenerate it again
thanks
Chinma
-- Uri Dimant wrote: --
H
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtech
ol/sql/reskit/sql7res/part9/sqc13.as
"Chinmay" <anonymous@.discussions.microsoft.com> wrote in messag
news:CB5EF10C-6B9E-4591-BDBD-05C9C739482E@.microsoft.com..
>> I got it some weeks back
> Yes and i dont have a Primary Key on Image column
> The Primary Key is on a normal varchar column
> The thing is now I dont get it
> Also the exception that I got was comething like "Could not prepare
Query Plan for clustered.....
>> Also I found this artical on the Microsoft site...(but I m confuse
still
>> "http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;818729
>> Thanks
> Chinma
>> -- Uri Dimant wrote: --
>> H
> What kind of exeption did you get
> Do you have PRIMARY KEY on image type column
>> "Chinmay" <anonymous@.discussions.microsoft.com> wrote in messag
> news:770F912B-465B-499E-B5BC-E21D67787B42@.microsoft.com..
>> Hi
>> I am having a primary key in my table as Clustered
>> But when I fire an SQL Update (I am updating an Image type column!
Quer
> through my Java (JDBC) code,I get an exception
>> If the same column was not clustered then the exception doesn
appear an
> update fires properly
>> Any ideas why something like this should happen
>> Thanks in Adv
>> Chinma
>>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment