db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2017) Client driver can insert and commit partial data when a LOB stream throws IOException or does not match the specified length
Date Mon, 30 Oct 2006 09:03:20 GMT
     [ http://issues.apache.org/jira/browse/DERBY-2017?page=all ]

Knut Anders Hatlen updated DERBY-2017:
--------------------------------------

    Attachment: StreamErrRepro.java

Attached a repro which shows the problem when using PreparedStatement.setCharacterStream()
with a stream that is longer than the specified length.

The embedded driver aborts the query and throws "java.sql.SQLException: An IOException was
thrown when reading a 'java.sql.String' from an InputStream."

The client driver completes the query (inserts a row) and throws "java.sql.SQLException: Network
protocol error: the specified size of the InputStream, parameter #1, is less than the actual
InputStream length."

The client driver should abort the the query and not insert the row.

> Client driver can insert and commit partial data when a LOB stream throws IOException
or does not match the specified length
> ----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2017
>                 URL: http://issues.apache.org/jira/browse/DERBY-2017
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC, Network Client
>    Affects Versions: 10.2.1.6
>            Reporter: Knut Anders Hatlen
>         Attachments: StreamErrRepro.java
>
>
> When a LOB stream throws an exception or does not match the specified length, the client
driver does not raise an exception until it has finished executing the statement. Therefore,
the statement will be executed (and possibly committed) on the server even though the client
reports that the statement failed.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message