MQSeries.net :: View topic

soudhanya · Posted: Mon Dec 09, 2019 9:36 pm Post subject: Oracle XMLTYPE column

Hi, I am trying to insert xml data in xmltype datatype field in database below is my code snippet but i am getting Unsupported feature.

ps1 = connection.prepareStatement(InsertQuery);
SQLXML xmlVal = connection.createSQLXML();
String dobleXML="";
xmlVal.setString(dobleXML);
ps1.setSQLXML(5, xmlVal);
ps1.executeUpdate();

I tried to insert as string like below but it is working for 2KB file but not 10 KB file.
byte bBlob[] = dobleXmlElem.toBitstream(null, null, null, 546, 1208, 0);
String dobleXml = new String(bBlob);
ps1 = connection.prepareStatement(InsertQuery);
ps1.setString(i++, dobleXml);
ps1.executeUpdate();

how to insert data in xmltype fieild. Any help on this?