XML Database (MOSC)

MOSC Banner

calling DBMS_XDB_REPOS.CREATERESOURCE function from Java

edited Nov 29, 2021 9:28AM in XML Database (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center