Do you need to store XML documents with Xindice?
You must be logged in to the O'Reilly Network to post a talkback.

Showing messages 1 through 9 of 9.

• XIndice with JBoss 4.0.1 or later
  2006-03-19 08:26:22  Deepak Vohra | [Reply | View]
  
  
  To configure XIndice with JBoss:
  1.Install JDK 5.0
  2.In jboss-4.0.2\bin\run batch file set JAVA_HOME to J2SE 5.0 JDK.
  3. Modify <Xindice>/Xindice-webapp/xindice-1.1b4/xindice-1.1b4.war to xindice.war.
  4. Copy the xindice.war file to the \jboss-4.0.2\server\default\deploy directory.
  5. Start the JBoss server. This starts the Xindice database server in the JBoss server and opens the default Xindice database, db. The Xindice server web application gets deployed in the JBoss server.
  6. The Xindice server URL is shown as http://localhost:/8080/xindice.
  7. Collection context for xindice server is
  -c xmldb:xindice://localhost:8080/db

• XIndiceDB.java
  2006-03-19 06:56:33  Deepak Vohra | [Reply | View]
  
  
  XIndiceDB.java
  
import org.apache.xindice.client.xmldb.services.*;
import org.apache.xindice.util.XindiceException;
import org.apache.xindice.xml.dom.*;
import org.w3c.dom.Document;
import org.xml.sax.SAXException;
import org.xmldb.api.*;
import org.xmldb.api.base.*;
import org.xmldb.api.modules.*;
import java.io.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;


public class XIndiceDB {
private Collection collection;
private Collection catalogCollection;
String resourceID;

public void createCollection() {
try {
String xindiceDriver = "org.apache.xindice.client.xmldb.DatabaseImpl";
Database xindiceDatabase = (Database) ((Class.forName(xindiceDriver)).newInstance());
DatabaseManager.registerDatabase(xindiceDatabase);

String url = "xmldb:xindice://localhost:7001/db";
collection = DatabaseManager.getCollection(url);

String collectionName = "catalog";
CollectionManager collectionManagerService = (CollectionManager) collection.getService("CollectionManager",
"1.0");

String collectionConfig = "<collection compressed=\"true\" " +
" name=\"" + collectionName + "\">" +
" <filer class=\"org.apache.xindice.core.filer.BTreeFiler\"/>" +
"</collection>";

catalogCollection = collectionManagerService.createCollection(collectionName,
DOMParser.toDocument(collectionConfig));
} catch (XindiceException e) {
} catch (XMLDBException e) {
} catch (ClassNotFoundException e) {
} catch (InstantiationException e) {
} catch (IllegalAccessException e) {
}
}

public void addDocument() {
try {
String xindiceDriver = "org.apache.xindice.client.xmldb.DatabaseImpl";
Database xindiceDatabase = (Database) ((Class.forName(xindiceDriver)).newInstance());
DatabaseManager.registerDatabase(xindiceDatabase);
collection = DatabaseManager.getCollection(
"xmldb:xindice://localhost:7001/db/catalog");

DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();

File datafile = new File("c:/XIndice/catalog.xml");

DocumentBuilder builder = factory.newDocumentBuilder();
Document document = builder.parse(datafile);

resourceID = collection.createId();

XMLResource resource = (XMLResource) (collection.createResource(resourceID,
"XMLResource"));
resource.setContentAsDOM(document);

collection.storeResource(resource);
}
catch (SAXException e) {
} catch (ParserConfigurationException e) {
} catch (XMLDBException e) {
System.out.println(e.getMessage());
} catch (IOException e) {
System.out.println(e.getMessage());
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
} catch (InstantiationException e) {
System.out.println(e.getMessage());
} catch (IllegalAccessException e) {
System.out.println(e.getMessage());
}
}

public void retrieveDocument() {
try {
XMLResource resource = (XMLResource) (collection.getResource(resourceID));

System.out.println(resource.getContent());
} catch (XMLDBException e) {
}
}

public void queryDocument() {
try {
String xpath = "/catalog/journal[1]/article/title";
XPathQueryService queryService = (XPathQueryService) collection.getService("XPathQueryService",
"1.0");
ResourceSet resourceSet = queryService.query(xpath);
ResourceIterator iterator = resourceSet.getIterator();

while (iterator.hasMoreResources()) {
Resource resource = iterator.nextResource();
System.out.println(resource.getContent());
}
} catch (XMLDBException e) {
}
}

public void updateDocument() {
try {
String xindiceDriver = "org.apache.xindice.client.xmldb.DatabaseImpl";
Database xindiceDatabase = (Database) ((Class.forName(xindiceDriver)).newInstance());
DatabaseManager.registerDatabase(xindiceDatabase);
collection = DatabaseManager.getCollection(
"xmldb:xindice://localhost:7001/db/catalog");

String xupdate = "<xupdate:modifications version=\"1.0\"" +
" xmlns:xupdate=\"http://www.xmldb.org/xupdate\">" +
" <xupdate:insert-after select=\"/catalog/journal[3]\">" +
" <journal date=\"Aug 2005\">" + " <article>" +
" <title>iBatis DAO</title>" +
" <author>Sunil Patil</author>" + " </article>" +
" </journal>" + " </xupdate:insert-after>" +
"</xupdate:modifications>";

XUpdateQueryService queryService = (XUpdateQueryService) collection.getService("XUpdateQueryService",
"1.0");
queryService.update(xupdate);

xupdate = "<xupdate:modifications version=\"1.0\"" +
" xmlns:xupdate=\"http://www.xmldb.org/xupdate\">" +
" <xupdate:remove select=\"/catalog/journal[1]\"/>" +
"</xupdate:modifications>";

queryService.update(xupdate);

xupdate = "<xupdate:modifications version=\"1.0\"" +
" xmlns:xupdate=\"http://www.xmldb.org/xupdate\">" +
" <xupdate:update select=\"/catalog/journal[2]/article/title\">Maven with Swing</xupdate:update>" +
"</xupdate:modifications>";

queryService.update(xupdate);

XMLResource resource = (XMLResource) (collection.getResource(resourceID));
System.out.println(resource.getContent());
} catch (XMLDBException e) {
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
} catch (InstantiationException e) {
System.out.println(e.getMessage());
} catch (IllegalAccessException e) {
System.out.println(e.getMessage());
}
}

public void deleteDocument() {
try {
XMLResource resource = (XMLResource) (collection.getResource(resourceID));
collection.removeResource(resource);
} catch (XMLDBException e) {
}
}

public static void main(String[] argv) {
XIndiceDB xindicedb = new XIndiceDB();
xindicedb.createCollection();

xindicedb.addDocument();
xindicedb.retrieveDocument();
xindicedb.queryDocument();
xindicedb.updateDocument();
xindicedb.deleteDocument();
}
}


• Correction-Configuring Xindice with WebLogic Server
  2006-03-19 06:47:19  Deepak Vohra | [Reply | View]
  
  
  In the Configuring XIndice with WebLogic Server section make the following corrections:
  1. Please replace xindice-1.1b4.war with xindice.war in 1.
  2. Please replace server.xml with system.xml and xindice.jar with xindice.war in 2.
  3. Please replace server.xml with system.xml in 3.
  4. Please replace xindice.jar with xindice.war and server.xml with system.xml in 4.
  5. Please replace xindice.jar with xindice.war in 5.
  
• Correction-Configuring Xindice with WebLogic Server
  2006-03-19 06:49:43  Deepak Vohra | [Reply | View]
  
  
  Correction.
  Please replace xindice-1.1b4.jar with xindice-1.1b4.war in 1.
  

• Searching / WHERE equivalent?
  2006-03-11 19:20:23  noahgreen [Reply | View]
  
  
  (Sorry for previous empty post).
  Hi,
  Great article - just a few questions. Does this database allow you to perform queries with a WHERE clause equivalent? That is, something like, "find me all documents whose subject is 'adenine'" or something like that? That would seem to me to be the most important function of any database.
  
  Thanks,
  -Noah
• Searching / WHERE equivalent?
  2006-03-12 07:56:26  Deepak Vohra | [Reply | View]
  
  
  "find me all documents whose subject is 'adenine'"
  
  To retrieve all documents with a common subject store the documents in the same collection.
  For example, create a collection called adenine.
  
  >xindice ac -c xmldb:xindice://localhost:7001/db -n adenine
  
  Add couments to the collections as explained in the tutorial. List all the documents in the collection with action ld.
  
  >xindice ld -c xmldb:xindice://localhost:7001/db/adenine
  
  
  
  
• Searching / WHERE equivalent?
  2006-03-12 07:49:48  Deepak Vohra | [Reply | View]
  
  
  Querying in Xindice is performed with XPath.
  An XPath expression retrieves a node or a node set. The query is run in the context of a collection. XPath query does not retrieve documents, but an XPath query is run on all the documents in the specified collection.
  
  "find me all documents whose subject is 'adenine'"
  
  A document that is stored as adenine.xml may be retrieved with:
  >xindice rd -c xmldb:xindice://localhost:7001/db/catalog
-n adenine.xml
  
  Only one document may be retrieved with rd action.
• Searching / WHERE equivalent?
  2006-03-13 21:47:56  noahgreen [Reply | View]
  
  
  This is great - thanks!
  -Noah
  

• Searching / WHERE equivalent?
  2006-03-11 19:18:56  noahgreen [Reply | View]