Hi Madhan,
I see you are using BaseX 7.9. Does the problem persist when using our latest release? What is the output of db:info() (or INFO DB)?
Best, Christian
On Mon, Nov 9, 2015 at 3:33 PM, madhan gopal madhangopal828@gmail.com wrote:
Dear Christian,
Here the problem is,the xml attribute values are replacing with Alphabet "A"
Example: in my Xml file i have the tag <MyTag myAttribute="10" > ..</MyTag> if i add this xml to collection database, the value of attribute myAttribute is replacing 10 with 'A'
Note:Please check once attachment.
On Mon, Nov 9, 2015 at 4:52 PM, Christian Grün christian.gruen@gmail.com wrote:
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("XQUERYdb: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
-- Thanks & Regards Madhangopal.P
Hi Christian, Currently am using baseX version 7.9,i can't able to find the RCA for this problem.so please do needful.
The output of the db:info() function is: <database> <databaseproperties> <name>MyCollectionName</name> <size>913 MB</size> <nodes>51679859</nodes> <documents>32</documents> <binaries>0</binaries> <timestamp>2015-10-14-15-13-14</timestamp> </databaseproperties> <resourceproperties> <timestamp>2015-10-14-14-38-19</timestamp> <encoding>UTF-8</encoding> <chop>true</chop> </resourceproperties> <indexes> <uptodate>false</uptodate> <textindex>false</textindex> <attrindex>false</attrindex> <ftindex>false</ftindex> <language>English</language> <stemming>false</stemming> <casesens>false</casesens> <diacritics>false</diacritics> <stopwords/> <updindex>false</updindex> <maxcats>100</maxcats> <maxlen>96</maxlen> </indexes> </database>
On Mon, Nov 9, 2015 at 8:06 PM, Christian Grün christian.gruen@gmail.com wrote:
Hi Madhan,
I see you are using BaseX 7.9. Does the problem persist when using our latest release? What is the output of db:info() (or INFO DB)?
Best, Christian
On Mon, Nov 9, 2015 at 3:33 PM, madhan gopal madhangopal828@gmail.com wrote:
Dear Christian,
Here the problem is,the xml attribute values are replacing with Alphabet "A"
Example: in my Xml file i have the tag <MyTag myAttribute="10" > ..</MyTag> if i add this xml to collection database, the value of attribute myAttribute is replacing 10 with 'A'
Note:Please check once attachment.
On Mon, Nov 9, 2015 at 4:52 PM, Christian Grün <
christian.gruen@gmail.com>
wrote:
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("XQUERYdb: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
-- Thanks & Regards Madhangopal.P
I see you are using BaseX 7.9. Does the problem persist when using our latest release?
Currently am using baseX version 7.9,i can't able to find the RCA for this problem.so please do needful.
We can only provide unpaid support for the latest version, so once again please try the latest version and tell us what happens. As an alternative, please provide us with something we can reproduce. For help on older versions, you can also ask for commercial support.
What is the output of db:info() (or INFO DB)?
The output of the db:info() function is: [...]
Thanks. Everything looks fine here (913 MB, and 50 million nodes, is far away from the current limits for a single database).
<database> <databaseproperties> <name>MyCollectionName</name> <size>913 MB</size> <nodes>51679859</nodes> <documents>32</documents> <binaries>0</binaries> <timestamp>2015-10-14-15-13-14</timestamp> </databaseproperties> <resourceproperties> <timestamp>2015-10-14-14-38-19</timestamp> <encoding>UTF-8</encoding> <chop>true</chop> </resourceproperties> <indexes> <uptodate>false</uptodate> <textindex>false</textindex> <attrindex>false</attrindex> <ftindex>false</ftindex> <language>English</language> <stemming>false</stemming> <casesens>false</casesens> <diacritics>false</diacritics> <stopwords/> <updindex>false</updindex> <maxcats>100</maxcats> <maxlen>96</maxlen> </indexes> </database>
On Mon, Nov 9, 2015 at 8:06 PM, Christian Grün christian.gruen@gmail.com wrote:
Hi Madhan,
I see you are using BaseX 7.9. Does the problem persist when using our latest release? What is the output of db:info() (or INFO DB)?
Best, Christian
On Mon, Nov 9, 2015 at 3:33 PM, madhan gopal madhangopal828@gmail.com wrote:
Dear Christian,
Here the problem is,the xml attribute values are replacing with Alphabet "A"
Example: in my Xml file i have the tag <MyTag myAttribute="10" > ..</MyTag> if i add this xml to collection database, the value of attribute myAttribute is replacing 10 with 'A'
Note:Please check once attachment.
On Mon, Nov 9, 2015 at 4:52 PM, Christian Grün christian.gruen@gmail.com wrote:
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("XQUERYdb: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
-- Thanks & Regards Madhangopal.P
-- Thanks & Regards Madhangopal.P
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
madhan gopal