calling DBMS_XDB_REPOS.CREATERESOURCE function from Java
I have a valid XML , was trying to create a resource as XML to xml db repository using java sql API calling DBMS_XDB_REPOS.CREATERESOURCE function
String absPath ="xml_db_repo_path/test.xml";
SQLXML xmltoupload = pConnection.createSQLXML();
/* Step -1 : Fetch the XML file on disk in FileInputStream */
BufferedReader br;
br = new BufferedReader(new FileReader("D:\\local_path\\test.xml"));
String content = br.lines().collect(Collectors.joining("\n"));
xmltoupload.setString(content);
CallableStatement cstatement = pConnection.prepareCall("{? = call DBMS_XDB_REPOS.CREATERESOURCE(?,?)}");
cstatement.registerOutParameter(1, OracleTypes.PLSQL_BOOLEAN);
cstatement.setString(2, absPath);
cstatement.setSQLXML(3,sqlXml);
cstatement.executeUpdate();
Getting the following error
java.sql.SQLException: ORA-31011: XML parsing failed