Java methods to connect to and manipulate Sedna XML databases

This article illustrates how Java can connect to and manipulate Sedna XML databases. Share with you for your reference. Specific analysis is as follows:

Sedna is a native XML database that provides full-featured core database services, including persistent storage, ACID transactions, indexing, security, hot standby, UTF8, and more. The W3C XQuery specification is implemented to support full-text search and node-level updates.

import ru.ispras.sedna.driver.*; 
public class SednaClient { 
 public static void main(String args[]) { 
  SednaConnection con = null; 
  try { 
    
   con = DatabaseManager.getConnection("localhost", 
                     "testdb", 
                     "SYSTEM", 
                     "MANAGER"); 
    
   con.begin(); 
    
   SednaStatement st = con.createStatement(); 
    
   System.out.println("Loading data ..."); 
   boolean res; 
   res = st.execute("LOAD 'C:/region.xml' 'region'"); 
   System.out.println("Document 'region.xml' "+ 
     "has been loaded successfully"); 
    
   System.out.println("Executing query"); 
   res = st.execute("doc('region')/*/*"); 
    
   printQueryResults(st); 
    
   System.out.println("Removing document ..."); 
   res = st.execute("DROP DOCUMENT 'region'"); 
   System.out.println("Document 'region' " + 
         "has been dropped successfully"); 
    
   con.commit(); 
  } 
  catch(DriverException e) { 
    e.printStackTrace(); 
  } 
  finally { 
    
   try { if(con != null) con.close(); } 
   catch(DriverException e) { 
    e.printStackTrace(); 
   } 
  } 
 } 
  
 private static void printQueryResults(SednaStatement st) 
  throws DriverException { 
  int count = 1; 
  String item; 
  SednaSerializedResult pr = st.getSerializedResult(); 
  while ((item = pr.next()) != null) { 
   System.out.println(count + " item: " + item); 
   count++; 
  } 
 } 
}

I hope this article has been helpful to your Java programming.