Results 1 to 2 of 2

Thread: Question on xml

  1. #1
    Join Date
    May 2011
    Posts
    15

    Unanswered: Question on xml

    HI,

    i have error in this code

    String xmlfilename = "c:/book.xml";
    int shred = 1;

    // Decompose the XML document by calling the SYSPROC.XDBDECOMPXML


    CallableStatement callStmt = con.prepareCall("CALL SYSPROC.XDBDECOMPXML(?,?,?,?,?, NULL, NULL, NULL)");
    File xmlfile = new File(xmlfilename);
    FileInputStream xmlfileis = new FileInputStream(xmlfile);
    callStmt.setString(1, relSchema );
    callStmt.setString(2, schemaName );
    callStmt.setBinaryStream(3, xmlfileis, (int)xmlfile.length() );
    callStmt.setString(4, schemaName );
    callStmt.setInt(5, shred);

    callStmt.execute();

    xmlfileis.close();
    callStmt.close();
    System.out.println("**** CALL SYSPROC.XDBDECOMPXML SUCCESSFULLY");


    the error is



    Error Msg: [jcc][10143][10845][3.62.56] Invalid parameter 4: Parameter is not set nor registered. ERRORCODE=-4461, SQLSTATE=42815
    SQLState: 42815
    SQLError: -4461


    plz answer me quickly

  2. #2
    Join Date
    May 2011
    Posts
    15
    how can i solve the problem??

    this procedure SYSPROC.XDBDECOMPXML is stored in db2

    how can i use it ?
    Last edited by TDVH; 06-17-11 at 06:59.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •