Provides Tutorials on Web Technologies.

Couch DB Java Integration : Couchdb4j

  •  COUCHDB4J API is library for accessing Documents from couch database.
  • This Library is downloaded from the link:-
          http://code.google.com/p/couchdb4j/downloads/list
  • In this Demo , "Using FUTON Web Interface a student database is created and 4 student documents are created.The java program is written for accessing these documents and displaying the details in console output".
  • The Student Database in Futon looks like,


  •  This library has some dependencies to these libraries,
           commons-httpclient-3.1.jar, commons-beanutils.jar, 
          commons-codec-1.3.jar, commons-collections.jar, 
          commons-lang.jar,commons-logging-1.1.jar,
          json-lib-2.0-jdk15.jar, ezmorph-1.0.3.jar 


  • The Project Structure,showing all the dependencies jar libraries in the CLASSPATH,
        
  •  The Java code is CouchDBTest.java is,
package com.sandeep.couchdb.util;

import java.util.List;
import com.fourspaces.couchdb.Database;
import com.fourspaces.couchdb.Document;
import com.fourspaces.couchdb.Session;
import com.fourspaces.couchdb.ViewResults;

public class CouchDBTest {

 /*These are the keys of student document in couch db*/
 public static final String STUDENT_KEY_NAME ="name";
 
 public static final String STUDENT_KEY_MARKS ="marks";
 
 public static final String STUDENT_KEY_ROLL="roll";
 
 public static final String STUDENT_KEY_CONTACT ="contact";
 
 public static void main(String[] args){
  
  /*Creating a session with couch db running in 5984 port*/
  Session studentDbSession = new Session("localhost",5984);
  
  /*Selecting the student database from list of couch database*/
  Database studentCouchDb = studentDbSession.getDatabase("student");
  
  /*Fetching all Student Document to ViewResult object*/
  ViewResults couchViewResults = studentCouchDb.getAllDocuments();
  
  /*Retieving all document as result to a List*/
  List<Document> studentDocuments = couchViewResults.getResults();
  
  
  for(Document couchDocument: studentDocuments){
   
   String id = couchDocument.getJSONObject().getString("id");
   
   Document studentRow = studentCouchDb.getDocument(id);
   
   System.out.println("__________START OF DOCUMENT("+studentRow.get("_id")+")_________");
   
   if(studentRow.containsKey(STUDENT_KEY_NAME)){
    
    System.out.println("NAME : "+studentRow.get(STUDENT_KEY_NAME));
    
   }
   if(studentRow.containsKey(STUDENT_KEY_MARKS)){
    
    System.out.println("MARK : "+studentRow.get(STUDENT_KEY_MARKS));
    
   }
   
   if(studentRow.containsKey(STUDENT_KEY_ROLL)){
    
    System.out.println("ROLL : "+studentRow.get(STUDENT_KEY_ROLL));
    
   }
   if(studentRow.containsKey(STUDENT_KEY_CONTACT)){
    
    System.out.println("CONTACT : "+studentRow.get(STUDENT_KEY_CONTACT));
    
   }
   
  }
 }
}

  •  ViewResults(com.fourspaces.couchdb.ViewResults) is the class which stores all the document.The debug point screenshot,
 
  • Couch db stores the data in Document format (com.fourspaces.couchdb.Document) package.
  • The output:-
 __________START OF DOCUMENT(326e49164d9b414a6c1ce2c8a802d175)_________
NAME : sandeep
MARK : 75
ROLL : 4
CONTACT : +91-1234567890
__________START OF DOCUMENT(326e49164d9b414a6c1ce2c8a802d28e)_________
NAME : sumanta
MARK : 80
ROLL : 3
__________START OF DOCUMENT(326e49164d9b414a6c1ce2c8a802dda1)_________
NAME : sangeeta
MARK : 95
ROLL : 7
__________START OF DOCUMENT(326e49164d9b414a6c1ce2c8a802f200)_________
NAME : Surabhi
MARK : 73
ROLL : 7 

  • The output screenshot in java console,