Kind of funny but looking at the possible cause to this problem that I've got a text type column called MessageText of MailMessages table.

Now whenever I am trying to read this through Java, it is throwing this exception:

Java Exception error '80004005'

ACD_Exception: No data found


Note here that this is not the Java problem because I've been using this program for last 10 years and this problem is only occuring with one record where the messageText size is 15360

" select Len(Cast (MessageText as varchar(max))) from MailMessages_Sick "

However, as soon as I do this, the program runs smooth:

Update MailMessages_Sick set MessageText = substring(MessageText, 0, 100000000 )

I am running the following MSSQL version:

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

[select @@version]

Curious. What happens when you execute your select statement directly on the database server, rather than through Java?

No exceptions; it works like a charm.

Now don't direct me it should be JdBC but why only to this record, why why why

Dunno dunno dunno why why why.
But I'll move this thread to the Java forum, and maybe somebody there can give you some direction.

Thanks Mate!