db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3977) Clob.truncate with a value greater than the Clob length raises different exceptions in embedded and client driver
Date Mon, 08 Dec 2008 13:12:44 GMT
Clob.truncate with a value greater than the Clob length raises different exceptions in embedded
and client driver
-----------------------------------------------------------------------------------------------------------------

                 Key: DERBY-3977
                 URL: https://issues.apache.org/jira/browse/DERBY-3977
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.4.2.0, 10.3.3.0
            Reporter: Kristian Waagan
            Priority: Minor


Calling Clob.truncate with a value that is greater then the Clob length raises different SQLExceptions
in the client and the embedded driver.
 o Client: SQLState.BLOB_LENGTH_TOO_LONG - XJ079
 o Embedded: SQLState.BLOB_POSITION_TOO_LARGE - XJ076

I believe the fix is simple enough  - change one of the exceptions.
Which one most closely describes the situation?

A release note is needed for this fix.

Also note the following from the Java API docs:
"void truncate(long len)
              throws SQLException

    Truncates the CLOB value that this Clob designates to have a length of len characters.

    Note: If the value specified for pos is greater then the length+1 of the CLOB value then
the behavior is undefined. Some JDBC drivers may throw a SQLException while other drivers
may support this operation.
"

This opens for a change of behavior as well.
There seems to an inconsistency in the docs, possibly due to rephrasing - it references both
len and pos. The latter isn't used anywhere else in the JavaDoc for truncate.
And what should the result of truncate(length+1) be?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message