[DERBY-3870] Concurrent Inserts of rows with XML data results in an exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3, 10.4.2.1, 10.5.2.0, 10.6.1.0
• Fix Version/s: 10.8.2.2, 10.9.1.0
• Component/s: SQL
• Labels: derby_backport_reject_10_7
• Environment: System: MS windows server 2003 standard edition service pack 2. Derby is run as a server on port 1527.
• Urgency: Normal
• Issue & fix info: Known fix, Repro attached
• Bug behavior facts: Crash
• Assignee: Knut Anders Hatlen
• Reporter: Royi Ronen
• Created: 09/Sep/08 19:34
• Updated: 25/Jun/14 07:58
• Resolved: 16/Mar/12 16:30

Description

We insert rows into a table using the following prepared statement (through JDBC):

INSERT INTO USER1.PSTORE values(?,?, XMLPARSE(document CAST (? AS CLOB) preserve whitespace))

where each of the ?'s are replaced with a string.

One thread runs fine. Two or more result in the following exception:

org.apache.derby.client.am.SqlException: Java exception: 'FWK005 parse may not be called while parsing.: org.xml.sax.SAXException'.
at org.apache.derby.client.am.SqlException.<init>(Unknown Source)
at org.apache.derby.client.am.SqlException.<init>(Unknown Source)

We believe that this comes from the dBuilder.parse(InputSource) method.

Issue Links

• is related to: DERBY-5263 xmlTestTriggerWithXMLOperators(org.apache.derbyTesting.functionTests.tests.upgradeTests.BasicSetup) fails with java.lang.NoSuchMethodError