Collation problem

Hi all.
I have a problem with collation in SQLServer database. My table contains few
rows in field of type char(20),
field and server Collation is set to Croatian_CI_AS (Windows collation).
When I execute query SELECT field FROM table ORDER BY field, return set is
ordered as follows
---
field
---
+
-
7
7-
7+
7+1
71
7-1
72
Why does value 7-1 is placed between values 71 and 72 and not after 7+1.
Is there any way to tell SQLServer to set order of returned resultset in the
same way that windows
would set order of files in explorer. Collation Croatian_CI_AS is important
for me because of
correct order of special Croatian characters.

TomislavTomislav Stilinovi (Tomislav.Stilinovic@.zg.htnet.hr) writes:
> I have a problem with collation in SQLServer database. My table contains
> few rows in field of type char(20), field and server Collation is set to
> Croatian_CI_AS (Windows collation). When I execute query SELECT field
> FROM table ORDER BY field, return set is ordered as follows
> ---
> field
> ---
> +
> -
> 7
> 7-
> 7+
> 7+1
> 71
> 7-1
> 72
> Why does value 7-1 is placed between values 71 and 72 and not after 7+1.

I think most Unicode sorting algorithms with some level of sophistication
considers hyphen to be an ignorable character, at least on primary level.
This is also how you sort in a dictionary.

> Is there any way to tell SQLServer to set order of returned resultset in
> the same way that windows would set order of files in explorer.

No. And it appears that the one that is really the odd one out is
Explorer. I entered your data in Word, and asked it to sort, and I
got the same result as in SQL Server.

I ran my tests with Finnish_Swedish collations, and regional settings
set to Swedish, but I don't think this makes a difference in this case.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Codepage 932 is not supported by the Java environment.

I have a JDBC type 4 driver, connecting to a Japanese SQL Server 2000. The connection gives this SQL exception:

SQLException: Codepage 932 is not supported by the Java environment.

SQL State: null

SQL Code: 0

This same software has been in use and working just fine for over 2 years with other servers. Does anyone know the solution to this problem?

Thanks!

pds2

What JDBC driver are you using?

The exception "Codepage 932 is not supported by the Java environment." doesn't sound like it's coming from SQL Server so the driver is likely raising it based on server configuration.

Try checking the database collation on SQL Server. That may have changed.

If this new SQL Server is running on a different machine is it possible that the Windows OS is running with a different locale?

Hope this helps,

Vaughn

|||

Hi,

The Microsoft SQL Server 2005 JDBC Driver relies on nio Charset support in the JVM to map from CHAR/VARCHAR/TEXT values with SQL collations to Java String instances. To do that, it needs to have charsets.jar, provided by your JVM vendor, installed and accessible via your application's classpath. Some JVM vendors choose not install charsets.jar, depending on what languages are supported by the host operating system at the time when the JVM is installed. So you may need to install charsets.jar separately.

For further information, please refer to:

http://java.sun.com/j2se/1.4.2/docs/guide/intl/encoding.doc.html

If you have charsets.jar installed and are still seeing this issue, please reply to this thread and I'll attempt to diagnose the issue further.

Thank you,

--David

|||

This fixed the problem! Many thanks!

pds2

|||

Hi David,

I have same error message from running agent on Domino server 7 tried to connect to SQL 2005 as:

java.lang.NoClassDefFoundError:java/nio/charset/Charset

at com.microsoft.sqlserver.jdbc.SQLCollation.readCollation

at com.microsoft.sqlserver.jdbc.SQLCollation.<init>

at com.microsoft.sqlserver.jdbc.IOBuffer.processEnvChange

at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets

at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon

...

at java.sql.DriverManager.getConnection(DriverManager.java:539)

at java.sql.DriverManager.getConnection(DriverManager.java:211)

...

And I had installed j2sdk1.4.2_13 from Sun, and checked the charsets.jar is in place in c:\j2sdk1.4.2_13\jre\lib,

All the code with old three jar files were running well with SQL 2000 server before, after the harware failure on that server, we are now with SQL 2005 server, all the agents connected to it changed to new JDBC driver and new jar - sqljdbc.jar are not working at all becuase of this problem...

I had sqljdbc.jar in classpath too, here we are in US (enu). I don't know what else I 've under looked?

Thanks for your help.

Evelyn

|||

Instead of using MS JDBC driver1.1, downloaded jTDS jdbc driver solved the problem!

Code Problem - Updating parameter

I want to update a parameter in order to know whether a certain type of row
has been printed so that I can suppress it later. the code below generates
an error " Reference to a non-shared member requires an object reference" .
How do I pass in /reference my parameter so that I can set the value? Any
help greatly appreciated
Public Function PrintCensus() As Integer
if Parameters!PrintCensus.Value = 0 Then
Parameters!PrintCensus.Value = 1
Return 0
end if
return 1
End FunctionWhat you have to do is:
1. Define your function as:
> Public Function PrintCensus(PrintCensusValue as integer) As Integer
>
> if PrintCensusValue= 0 Then
> Return 1
> else
Return 0
> end if
> End Function
2. Call your function from expresion field as:
=Code.PrintCensus(Parameters!PrintCensus.Value)
Hope this helps,
Mónica
"Peter Feakins" <PeterFeakins@.discussions.microsoft.com> escribió en el
mensaje news:71D8DF3A-A67F-41CB-8B8B-CE71E0FF63E4@.microsoft.com...
>I want to update a parameter in order to know whether a certain type of row
> has been printed so that I can suppress it later. the code below
> generates
> an error " Reference to a non-shared member requires an object reference"
> .
> How do I pass in /reference my parameter so that I can set the value? Any
> help greatly appreciated
> Public Function PrintCensus() As Integer
> if Parameters!PrintCensus.Value = 0 Then
> Parameters!PrintCensus.Value = 1
> Return 0
> end if
> return 1
> End Function|||apparently you cannot change the value of a parameter after it is set prior
to report execution.
"Peter Feakins" wrote:
> I want to update a parameter in order to know whether a certain type of row
> has been printed so that I can suppress it later. the code below generates
> an error " Reference to a non-shared member requires an object reference" .
> How do I pass in /reference my parameter so that I can set the value? Any
> help greatly appreciated
> Public Function PrintCensus() As Integer
> if Parameters!PrintCensus.Value = 0 Then
> Parameters!PrintCensus.Value = 1
> Return 0
> end if
> return 1
> End Function

Code page translations are not supported for the text data type. From: 1252 To: 950.

Code page translations are not supported for the text data type. From:
1252 To: 950.

I would like to know what this message means. I also installed the
language packs in advanced settings, Everything is set to English. My
windows XP computer is XP English. For some reason I cant get an update
to go thru using ADO. like Recordset.Update

Although other routines using .update work

Any ideas?Is it possible that If I installed MSDE when I had set under advanced
settings the nonunicode programs to Chinese that this would happen? I
have also noticed I can get around this by using the N' like select *
from some where something = N'something'

Anyway, how does one normally get around this issue, would an uninstall
of MSDE and then reinstall while XP is set to English fix this issue?|||That worked, uninstaled MSDE and reinstalled while XP was set to
english.
But I think the only setting change I made was under
control panel
regional settings
advanced language for nonunicode programs to Chinese(Taiwan).|||Hi

The collation was probably not explicitly set for the installation see
http://msdn.microsoft.com/library/d...istsql_84xl.asp
http://msdn.microsoft.com/library/d..._ca-co_2e95.asp

John

<sdowney717@.msn.com> wrote in message
news:1110744591.148218.180470@.z14g2000cwz.googlegr oups.com...
> That worked, uninstaled MSDE and reinstalled while XP was set to
> english.
> But I think the only setting change I made was under
> control panel
> regional settings
> advanced language for nonunicode programs to Chinese(Taiwan).|||Yes, it gives no options on the install, it must just use whatever is
set for the language. That does answer another question I was wondering
about, involving default collations. Is there an updated install for
MSDE, I only have the one off my Office XP CDROM. from 2000|||Hi

The latest release is downloadable from
http://www.microsoft.com/downloads/...&displaylang=en
this includes SP3a although you can apply SP3a to your existing system using
the appropriate download from
http://www.microsoft.com/sql/downloads/2000/sp3.asp

John

<sdowney717@.msn.com> wrote in message
news:1110749126.795817.193210@.f14g2000cwb.googlegr oups.com...
> Yes, it gives no options on the install, it must just use whatever is
> set for the language. That does answer another question I was wondering
> about, involving default collations. Is there an updated install for
> MSDE, I only have the one off my Office XP CDROM. from 2000|||sdowney717@.msn.com (sdowney717@.msn.com) writes:
> Is it possible that If I installed MSDE when I had set under advanced
> settings the nonunicode programs to Chinese that this would happen? I
> have also noticed I can get around this by using the N' like select *
> from some where something = N'something'

The N' means that the literal is nvarchar and thus Unicode, and thus not
subject to conversion between different 8-bit character sets.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Code Completion of SQL Statements in 2005

Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql

USE pubs
GO

SELECT pub.
FROM publishers AS pub

When I type the "pub." will I see a list of the available columns in the publishers table. This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release.

Cheers,

Colin

Hi Colin -
I am sad to say that you will not see this feature in SQL Server 2005. We will try our best to add it in the future releases.

Regards,
Michael|||Thanks for the reply, I've added a suggestion to MSDN Feedback

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=d02919ba-6429-4532-9bb7-4bc63e80c9b9

Hopefully we will get this feature "eventually" although if we have to wait for the version of SQL Server AFTER 2005 then I think we are in for a long wait.|||One of my coleagues who went to the code-off at PDC said that someone there demo'd intellisense for SQL. I'm sad I missed that session...|||I suspect this was one of the LINQ sessions, in this case the intellisense is inside of the VS Editor as long as you are using System.Query which will be in the next version of VS after VS2005.|||Here is the like to the product, and at $25 is pretty reasonable:
http://www.promptsql.com/index.html|||This may have been the video they saw at the PDC:
http://channel9.msdn.com/Showpost.aspx?postid=121794
Regard,
Damian

Code Completion of SQL Statements in 2005

Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql

USE pubs
GO

SELECT pub.
FROM publishers AS pub

When I type the "pub." will I see a list of the available columns in the publishers table. This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release.

Cheers,

Colin

Hi Colin -
I am sad to say that you will not see this feature in SQL Server 2005. We will try our best to add it in the future releases.

Regards,
Michael|||Thanks for the reply, I've added a suggestion to MSDN Feedback

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=d02919ba-6429-4532-9bb7-4bc63e80c9b9

Hopefully we will get this feature "eventually" although if we have to wait for the version of SQL Server AFTER 2005 then I think we are in for a long wait.

|||One of my coleagues who went to the code-off at PDC said that someone there demo'd intellisense for SQL. I'm sad I missed that session...|||I suspect this was one of the LINQ sessions, in this case the intellisense is inside of the VS Editor as long as you are using System.Query which will be in the next version of VS after VS2005.|||Here is the like to the product, and at $25 is pretty reasonable:
http://www.promptsql.com/index.html|||This may have been the video they saw at the PDC:
http://channel9.msdn.com/Showpost.aspx?postid=121794
Regard,
Damian

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause of blocking.
What does CMEMTHREAD mean?
http://sqldev.net/misc/WaitTypes.htm
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause
of blocking.
What does CMEMTHREAD mean?http://sqldev.net/misc/WaitTypes.htm
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>

CMEMTHREAD

CMEMTHREAD is displayed as a last wait type. This specific SPID is a cause of blocking.
What does CMEMTHREAD mean?http://sqldev.net/misc/WaitTypes.htm
--
Andrew J. Kelly SQL MVP
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:77CDDCCA-7716-4C8C-9C23-3615DE1AED89@.microsoft.com...
> CMEMTHREAD is displayed as a last wait type. This specific SPID is a
cause of blocking.
> What does CMEMTHREAD mean?
>

Clustering more than one SQL Server instance at a time

Hi, ever since last week I have a doubt about a type of clustering
implementation. Is it possible to cluster more than one SQL Server
instance. I mean i know it is possible to cluster one instance... so
that when that instance fails the other one enter into context be it
either manually or automatically... but what happens when there are 3
instances? if one instance fails the other two instances would be
forced to pass their execution to the other server even when maybe
everthing was ok with them
Thanks in advance for the response
AlanI think you misunderstand the relationship between an instance and a server
in a cluster.
A cluster is a group of machines that share a common storage unit and are
configured for failover. The cluster software arbitrates the shared storage
unit so that only one host computer (node) can control a logical disk (LUN)
at a time. Note that the storage logical disk appears to a node as a
physical disk.
A node is a particular host computer within a cluster.
An instance is a virtualized SQL server. It has one or more LUNs from the
shared unit, its own network name and IP address. It is hosted on a single
node at a tim, but can move to another node either in response to a failure
event or by administrator command. It is important to understand the
separation of nodes and instances. Instances are part of the overall
cluster. Nodes are either current or potential hosts. This type of
clustering is called "shared nothing" since no node requires any resource
from any other node in order to operate. When an instance moves to another
host node, the client sees the SQL Server stop and a restart. It still
connects exactly as before, since the IP address and network name moved to
the new host node along with the rest of the instance resources.
Just as a stand-alone system can support multiple instances, o can a
cluster. Each instance is completely independent of any other instance
(more of the "shared nothing" design). Each new instance must have its own
disk(s), IP address, and network name. You can move instances around on
various cluster nodes as you want, completely independent of each other. Of
course, each host node has a finite amount of processor and memory, which
must be shared between any instances it currently hosts.
So yes, you can have many instances in a cluster. Note that with shared
storage systems other than SCSI, you can have more than two nodes in a
cluster. Clusters with X nodes and X- instances are classified as N-1
Clusters.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<aferrandiz@.gmail.com> wrote in message
news:1187730948.651429.86880@.r23g2000prd.googlegroups.com...
> Hi, ever since last week I have a doubt about a type of clustering
> implementation. Is it possible to cluster more than one SQL Server
> instance. I mean i know it is possible to cluster one instance... so
> that when that instance fails the other one enter into context be it
> either manually or automatically... but what happens when there are 3
> instances? if one instance fails the other two instances would be
> forced to pass their execution to the other server even when maybe
> everthing was ok with them
> Thanks in advance for the response
> Alan
>|||Hi Geoff,
I believe that the cluster appears to the application as a single IP
address that it connects to. Is it mandatory that this IP address
happens to be one of the nodes participating in the cluster? Or is it a
virtual one?
If yes, what happens when the node whose IP address is visible to the
application happens to crash? If no, does the externally visible IP
address that was mapped to the node that crashed get transferred to
another node that is available and has been elected as the new interface
to the application?
How does this happen exactly?
Thanks,
Sanchet|||The IP ia a virtual one and cannot be a host IP address.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Sanchet Dighe" <sanchetd@.gmail.com> wrote in message
news:46CC35EA.3030706@.gmail.com...
> Hi Geoff,
> I believe that the cluster appears to the application as a single IP
> address that it connects to. Is it mandatory that this IP address happens
> to be one of the nodes participating in the cluster? Or is it a virtual
> one?
> If yes, what happens when the node whose IP address is visible to the
> application happens to crash? If no, does the externally visible IP
> address that was mapped to the node that crashed get transferred to
> another node that is available and has been elected as the new interface
> to the application?
> How does this happen exactly?
> Thanks,
> Sanchet|||Hi, ever since last week I have a doubt about a type of clustering
implementation.
Is it possible to cluster more than one SQL Server instance. I mean i know
it is possible to cluster one instance...
-- Yes is possible, for each SQL Server instance in a custer you need the
following :
-- A group for each instance of SQL
-- In the new group one disk(lun) o more, It is for install the new SQL
instance, if you plan to have more than 1 disk for the instance at the end
you need to add the disk like dependecies of SQL Server resource in the group
-- Ip Addrees, the setup ask for the ip and at the end of the setup
automatically add the ip resource into the group,
-- SQL name (instance name) , the setup ask for the instance name and at
the end of the setup automatically add the instance name resource into the
group,
so that when that instance fails the other one enter into context be it
either manually or automatically...
-- automatically
but what happens when there are 3 instances? if one instance fails the other
two instances would be forced to pass their execution to the other server
even when maybe everthing was ok with them
-- No, just the instance failed pass to other node in the cluster.. the
other instances still working without problem
Let me know any doubt about the problem...
"aferrandiz@.gmail.com" wrote:
> Hi, ever since last week I have a doubt about a type of clustering
> implementation. Is it possible to cluster more than one SQL Server
> instance. I mean i know it is possible to cluster one instance... so
> that when that instance fails the other one enter into context be it
> either manually or automatically... but what happens when there are 3
> instances? if one instance fails the other two instances would be
> forced to pass their execution to the other server even when maybe
> everthing was ok with them
> Thanks in advance for the response
> Alan
>|||> If yes, what happens when the node whose IP address is visible to the
> application happens to crash? If no, does the externally visible IP
> address that was mapped to the node that crashed get transferred to
> another node that is available and has been elected as the new interface
> to the application?
> How does this happen exactly?
How does this work is how TCP/IP ARP (address resolution protocol) works.
When node A that currently has an IP resource crashes and the cluster service
decides to bring the IP resource up on node B, node B will broadcast an ARP
request to force all the nodes on the subnet to update their ARP cache to map
the IP address to the machine address of node B. So when an external computer
tries to access that same IP address, that IP address now will be resolved to
node B.
I believe in Longhorn this will work slightly differently because the "same
subnet" restriction will be lifted. But the general principle is the same. So
the IP address is not really 'moved', it is just being resolved to a
different computer.
Linchi
"Sanchet Dighe" wrote:
> Hi Geoff,
> I believe that the cluster appears to the application as a single IP
> address that it connects to. Is it mandatory that this IP address
> happens to be one of the nodes participating in the cluster? Or is it a
> virtual one?
> If yes, what happens when the node whose IP address is visible to the
> application happens to crash? If no, does the externally visible IP
> address that was mapped to the node that crashed get transferred to
> another node that is available and has been elected as the new interface
> to the application?
> How does this happen exactly?
> Thanks,
> Sanchet
>

clustered vs non clustered indexes

can someone bottom line this for me? whats the difference between the two
and how do I know when to use which type?
any info is greatly appreciated. Thanks.The first place to look for information about sql server is in the online
documentation (BOL - Books Online).
Creating and Maintaining Databases/Indexes/Designing an Index/Using
Clustered Indexes
This section has a wealth of information about indexes. Try giving that a
thorough reading.
"djc" <noone@.nowhere.com> wrote in message
news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> can someone bottom line this for me? whats the difference between the two
> and how do I know when to use which type?
> any info is greatly appreciated. Thanks.
>|||As Scott states you should read up on it but the main difference is that you
can only have one clustered index per table since it physically sorts the
data in the order of the column(s) in the index expression. The leaf level
(lowest level) of the clustered index is the actual row of data where as in
a non-clustered index the leaf level points to the key in the clustered
index. Most tables should have a clustered index if for no other reason as
that is the only way to control fragmentation and avoid forwarding pointers.
But a CI can be extremely useful with lookups especially if you have range
type queries that use the expression the Ci is built on.
--
Andrew J. Kelly SQL MVP
"djc" <noone@.nowhere.com> wrote in message
news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> can someone bottom line this for me? whats the difference between the two
> and how do I know when to use which type?
> any info is greatly appreciated. Thanks.
>|||Thanks Scott. I may have to do that but I was hoping for one of the experts
here to bottom line it for me since I don't need all the detail yet. I'm
just being resourceful.
Thanks for the reply though.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%233J0%23hlmEHA.2864@.tk2msftngp13.phx.gbl...
> The first place to look for information about sql server is in the online
> documentation (BOL - Books Online).
> Creating and Maintaining Databases/Indexes/Designing an Index/Using
> Clustered Indexes
> This section has a wealth of information about indexes. Try giving that a
> thorough reading.
> "djc" <noone@.nowhere.com> wrote in message
> news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> > can someone bottom line this for me? whats the difference between the
two
> > and how do I know when to use which type?
> >
> > any info is greatly appreciated. Thanks.
> >
> >
>|||That will do. Thank you very much!
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ODyJ5ulmEHA.2764@.TK2MSFTNGP11.phx.gbl...
> As Scott states you should read up on it but the main difference is that
you
> can only have one clustered index per table since it physically sorts the
> data in the order of the column(s) in the index expression. The leaf
level
> (lowest level) of the clustered index is the actual row of data where as
in
> a non-clustered index the leaf level points to the key in the clustered
> index. Most tables should have a clustered index if for no other reason
as
> that is the only way to control fragmentation and avoid forwarding
pointers.
> But a CI can be extremely useful with lookups especially if you have range
> type queries that use the expression the Ci is built on.
> --
> Andrew J. Kelly SQL MVP
>
> "djc" <noone@.nowhere.com> wrote in message
> news:uFq3wSlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> > can someone bottom line this for me? whats the difference between the
two
> > and how do I know when to use which type?
> >
> > any info is greatly appreciated. Thanks.
> >
> >
>

clustered index on nvarchar column or int...

Users can approach their userprofile on my site using:www.mysite.com/name=peter
Name is a unique value within my database (db type: nvarchar(50))

Now, I have created a clustered index on the username column.
However, IMHO its faster to create a clustered index on the (also unique) usercode column since that is of type int.

BUT since a user can approach my site based on username I feel that I HAVE to live with this setback in performance...

Is that true or is there a better way to solve this issue?Your clustered index does not have to include the primary key column. Check out this page fortips on performance tuning clustered indexes.

Clustered columns confusion

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 th
rough my Java (JDBC) code,I get an exception.
If the same column was not clustered then the exception doesnt appear and up
date 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,
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.
> Chinmay|||Hi
http://www.microsoft.com/technet/tr...chnet/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...
Query
> through my Java (JDBC) code,I get an exception.
appear and
> update fires properly.
>
>|||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,
Chinmay
-- Uri Dimant wrote: --
Hi
http://www.microsoft.com/technet/tr...chnet/prodtechn
ol/sql/reskit/sql7res/part9/sqc13.asp
"Chinmay" <anonymous@.discussions.microsoft.com> wrote in message
news:CB5EF10C-6B9E-4591-BDBD-05C9C739482E@.microsoft.com...
> 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....."
still)
> Chinmay
> What kind of exeption did you get?
> Do you have PRIMARY KEY on image type column?
> news:770F912B-465B-499E-B5BC-E21D67787B42@.microsoft.com...
Query
> through my Java (JDBC) code,I get an exception.
appear and
> update fires properly.

Clustered columns confusion

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
>>