Hi Madhan,

I am facing the problem of adding special characters to the collection Database in below cases,

What do you mean by "problem", and what are "special characters"? Christian

Case-1: if the xml file size is huge(in GBs),at the time the collection Database creation tacking more time, Case-2: if the more no.of xml files are adding to the particular collection Database continuously

Example:

in Xml file <MyTag myAttribute="10" ...</MyTag>

The values are adding like the following in collection <MyTag myAttribute="A" ...</MyTag>

Sample Collection adding code :

/* This method takes the xml files list as input and process the list Create the xml collection DB, adds xml to the collection if already exists replace it */

public static void createCollection(ArrayList<String> listFiles){ ClientSession clientSession = null; String strIndexedFile=""; try { clientSession = new ClientSession("<<IP_ADDRESS>>", 1984, "<<USER>>", "<<PWD>>"); String strDbName = "Sample_Collection"; String strKeysFileLocation = "D:\TEMP\7GB_Collection_TestingTeam\Files";

        String res = clientSession.execute("XQUERY db:exists('" +

strDbName + "')"); //DB existence checking if (!res.equalsIgnoreCase("true")) { clientSession.execute("CREATE DB " + strDbName); } else { clientSession.execute("OPEN " + strDbName); }

        for (int i = 0; i < listFiles.size(); i++) {
            strIndexedFile = listFiles.get(i);
            String tempFlag=clientSession.execute("XQUERY db:exists('" +

strDbName + "','" + strIndexedFile + "')"); clientSession.execute("ADD " + strKeysFileLocation + File.separator + strIndexedFile); } System.out.println("InFormation:: "+clientSession.execute("INFO")); //optimizing the current opend DB using OPTIMIZE ALL command clientSession.execute("OPTIMIZE ALL"); System.out.println("InFormation:: "+clientSession.execute("INFO"));

    } catch (Exception e) {
        System.out.println("Exception files DB Updating: " +

e.getMessage()); e.printStackTrace(); } finally { if (clientSession != null) { try { clientSession.close(); } catch (IOException ex) { ex.printStackTrace(); } } } }

Hardware Specifications of Basex Sever :

Operating System : Red Hat Enterprise Linux 64bit OS Version : Linux 2.6.32 Hard Disk : 500 GB Memory Capacity : 16 GB Ram Processor Family : Intel (R) Xeon(R) CPU E5 -2680 V2 Processor Speed : 2.80 GHz Physical Processors : 8 Virtual Processors/cores : 4 Server Version : basex 7.9 -- Thanks & Regards Madhangopal.P