[
https://issues.apache.org/jira/browse/DERBY-6923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15886568#comment-15886568
]
Gordon Innes commented on DERBY-6923:
-------------------------------------
I've modified my NetworkOnly example to use a single connection. When I tried
running the section with non-matrialized Blob and Clob, it works as expected
with the correct data written.
However, the manually materialized section throws the following NullPointer
exception:
{quote}
Exception in thread "main" java.lang.NullPointerException
at
org.apache.derby.client.net.NetStatementRequest.buildEXTDTA(NetStatementRequest.java:962)
at
org.apache.derby.client.net.NetStatementRequest.writeExecute(NetStatementRequest.java:166)
at
org.apache.derby.client.net.NetPreparedStatement.writeExecute_(NetPreparedStatement.java:156)
at
org.apache.derby.client.am.ClientPreparedStatement.writeExecute(ClientPreparedStatement.java:1834)
at
org.apache.derby.client.am.ClientPreparedStatement.flowExecute(ClientPreparedStatement.java:2052)
at
org.apache.derby.client.am.ClientPreparedStatement.executeX(ClientPreparedStatement.java:1622)
at
org.apache.derby.client.am.ClientPreparedStatement.execute(ClientPreparedStatement.java:1607)
at DerbyNetworkOnly.main(DerbyNetworkOnly.java:68)
{quote}
> Passing a ClientClob or ClientBlob from another connection to an INSERT
> statement results in 'null' being written.
> ------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6923
> URL: https://issues.apache.org/jira/browse/DERBY-6923
> Project: Derby
> Issue Type: Bug
> Components: Network Client, Network Server
> Affects Versions: 10.13.1.1
> Environment: Java 8
> MacOS
> Windows
> Reporter: Gordon Innes
> Priority: Critical
> Attachments: DerbyEmbeddedOnly.java, DerbyNetworkOnly.java,
> DerbyNetworkRead.java, DerbyNetworkWrite.java
>
>
> When assigning a Blob or Clob from a ResultSet to a PreparedStatement
> parameter on a second connection, null is written to the column instead.
> Attached the same example using Embedded->Embedded, Embedded->Network,
> Network->Embedded and Network->Network.
> Only the Network->Network example exhibits the fault.
> Originally discovered in HA-JDBC's sync code with 2 derby instances on
> Windows. Example were tested using MacOS. Both were running on Oracle Java 8
> VMs.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
