Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2010
    Posts
    3

    Unanswered: Text column; funny behaviour

    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]

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Curious. What happens when you execute your select statement directly on the database server, rather than through Java?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Sep 2010
    Posts
    3
    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


  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Sep 2010
    Posts
    3
    Thanks Mate!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •