Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

F.3.3 Delete Data Using Direct Access Key

The following is a sample program to delete data with the direct access key using the Java APIs.

Data to be Deleted

<course>
  <id>0001</id>
  <name>Business negotiation</name>
  <instructor>
    <first-name>Max</first-name>
    <last-name>cameron</last-name>
  </instructor>
  <capacity>40</capacity>
  <current-auditors>30</current-auditors>
</course>

Defined Direct Access Key

key /course/id/text()

An Example of Using the APIs

The following is a sample program using the Java APIs.

import com.fujitsu.shun.ShunConnection;
import com.fujitsu.shun.ShunPreparedKey;
import com.fujitsu.shun.common.ShunException;

/*** Delete data using direct access key ***/
public class DirectAccessSample3 {

        public static void main(String[] args) {
        ShunConnection con = null;
        ShunPreparedKey keystmt = null;
        
        try {
                 //Direct access key name
                 String sCoursKeyName = "key";
                 //Direct access key
                 String key = "0001";

            // Create ShunConnection object
            // Host name for the connection destination: DirSvr1
            //       Port number: 33101
            //  If the Shunsaku File name is shunsakuFile1
                        con = new ShunConnection("DirSvr1", 33101, "shunsakuFile1");


            //Create ShunPreparedKey object for deleting data
            keystmt = con.prepareDeleteKey(sCoursKeyName);
            
            //Add the direct access key of the data to be deleted
            keystmt.add(key);
            
            //Delete course information
            keystmt.deleteByKey();
            System.out.println("Deletion complete");

            keystmt.close();
            con.close();
            
                }
                // Processing to perform if an error occurs while the application is running
                catch (ShunException ex) {
                        int errorLevel = ex.getErrLevel();
                        switch (errorLevel) {
                        case ShunException.SHUN_ERROR:
                                System.out.println("Error level  :SHUN_ERROR");
                                break;
                        case ShunException.SHUN_ERROR_CONNECTION_TERMINATED:
                                    System.out.println("Error level  :SHUN_ERROR_CONNECTION_TERMINATED");
                                break;
                        }
                        System.out.println("Error message:" + ex.getMessage());
                        ex.printStackTrace();
                }
                catch (Exception ex) {
                        System.out.println("Error message:" + ex.getMessage());
                        ex.printStackTrace();
                }
                // Recovery procedure in the event of an error
                finally {
                        try {
                                if(keystmt != null) keystmt.close();
                        }
                        catch (ShunException ex) {
                                int errorLevel = ex.getErrLevel();
                                switch (errorLevel) {
                                case ShunException.SHUN_ERROR:
                                        System.out.println("Error level  :SHUN_ERROR");
                                        break;
                                case ShunException.SHUN_ERROR_CONNECTION_TERMINATED:
                                        System.out.println("Error level  :SHUN_ERROR_CONNECTION_TERMINATED");
                                        break;
                                }
                                System.out.println("Error message:" + ex.getMessage());
                                ex.printStackTrace();
                        }
                        try {
                                if(con != null) con.close();
                        }
                        catch (ShunException ex) {
                                int errorLevel = ex.getErrLevel();
                                switch (errorLevel) {
                                case ShunException.SHUN_ERROR:
                                        System.out.println("Error level  :SHUN_ERROR");
                                        break;

                                case ShunException.SHUN_ERROR_CONNECTION_TERMINATED:
                                        System.out.println("Error level  :SHUN_ERROR_CONNECTION_TERMINATED");
                                        break;
                                }
                                System.out.println("Error message:" + ex.getMessage());
                                ex.printStackTrace();
                        }
                }
       }

}

Execution Results

Deletion complete