[
https://issues.apache.org/jira/browse/DERBY-7134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17503702#comment-17503702
]
Richard N. Hillegas commented on DERBY-7134:
--------------------------------------------
I don't know why you get that cryptic error message. The 23502 error message is
in the German localization for engine messages. Glad to hear that the problem
goes away for you too when you add wurfdatum to the INSERT branch of the MERGE.
> MERGE not Working over Nework
> -----------------------------
>
> Key: DERBY-7134
> URL: https://issues.apache.org/jira/browse/DERBY-7134
> Project: Derby
> Issue Type: Bug
> Components: Network Client
> Affects Versions: 10.15.2.0
> Environment: Windows , Derby
> Reporter: Thomas Lußnig
> Priority: Major
>
> I Receive an error after sending Merge Statement via Netowrk to derby network
> server.
> The error was first mentioned 5 Years ago:
> *
> [https://stackoverflow.com/questions/41587515/derby-merge-statement-results-in-insufficient-data-while-reading-from-the-netwo]
> And is till now active in derby.
> SQL-Fehler: Unzureichende Daten beim Lesen aus dem Netz. Erwartet wurden
> mindestens 21.272 Byte, empfangen wurden jedoch nur 0 Byte. Die Verbindung
> wurde beendet.
> MERGE INTO HUND USING SYSIBM.SYSDUMMY1 ON HUND.name='name'
> WHEN MATCHED THEN UPDATE SET zwinger='ZW',zbn='zb'
> WHEN NOT MATCHED THEN INSERT (name,zwinger,zbn)VALUES('a','zw','zb')
> ;
> Tue Mar 08 07:23:32 CET 2022 : Cannot invoke "String.length()" because
> "<parameter1>" is null
> java.lang.NullPointerException: Cannot invoke "String.length()" because
> "<parameter1>" is null
> at
> org.apache.derby.impl.drda.DDMWriter.maxEncodedLength(DDMWriter.java:1138)
> at org.apache.derby.impl.drda.DDMWriter.writeString(DDMWriter.java:1252)
> at
> org.apache.derby.impl.drda.DRDAConnThread.writeSQLCAGRP(DRDAConnThread.java:6338)
> at
> org.apache.derby.impl.drda.DRDAConnThread.writeSQLCARD(DRDAConnThread.java:6167)
> at
> org.apache.derby.impl.drda.DRDAConnThread.writeSQLCARDs(DRDAConnThread.java:6109)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:836)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:300)
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
