How can I fix Out Of Memory error while executing XML updates stored procedure?

This exception is typically found only on 32-bit JVMs. Native memory leak is the reason for java.lang.OutOfMemoryError exception while running XML update stored procedure. The java heap size should be updated to fix this problem.

The below command updates java heap size to 1024.

db2 update dbm cfg using JAVA_HEAP_SZ 1024

execute the source code mate

I am not able to add a new element to XML document using XMLUPDATE stored procedure. I am not sure if I am missing something. Can someone give a working sample?

Suppose that we have to add a new e-email address for clients. Below example shows how to add a new element in an XML document using the XMLUPDATE stored procedure.

CALL DB2XMLFUNCTIONS.XMLUPDATE(
'<updates>
<update action="append" col="1" path="/addr">
<Email>newEmail@yahoo.com</Email>
</update>
</updates>',
'select doc from CLIENTS where id=77',
'update CLIENTS set contactinfo=? where id=77', ?, ?);

i) action=”append” : we add new element
ii) col=”1” : we work with the first XML column returned by querySQL.
iii) path=”/addr” : the element we add will be a child to this element.
iv) <Email>newEmail@yahoo.com</Email> : the new element
v) ‘select doc from CLIENTS where id=77’ : Our querySQL
vi) ‘update CLIENTS ser cotactinfo=? Where id=77’ : Our updateSQL

How can I validate xml document against an xml schema while updating an existing xml data in the database using update stored procedure?

First you need to create and register xml schema. Here, consider test.schema xml schema has been registered.

In the below example we are trying to update xml document stored in info column and validate the updated document against the test.schema2 xml schema.