MaxDB Database Administration using JDBC – Part 1

MaxDB Database Administration using JDBC – Part 1

Database Administration is one among those tasks which is given a high priority. MaxDB Database administration can be achieved with the help of JDBC interfacing technique. This is much simplified and makes it possible for us to execute all the DBM commands with the help of Java. Java provides the package com.sap.dbtech.powertoys for the MaxDB database administration purpose.This weblog discusses the same with some sample Java programs.

The below links will be useful to learn more about the JDBC and MaxDB
MaxDB Documentation
JDBC Technology

The main steps that are to be followed when we access the MaxDB database is given below
1. Connecting to the Database
2. Executing DBM Commands
3. Ending the Connection

To establish a connection to an existing MaxDB Database instance we must first import the com.sap.dbtech.powertoys.DBM class. Then to handle the exeception we must import the com.sap.dbtech.rte.comm.RTEException. We can use the DBM.dbDBM method to connect to the database. The syntax for the same is Var_Name = DBM.dbDBM(“Server_Name”,”Database_Name”); . The program for establishing a connection is given below.

import com.sap.dbtech.powertoys.*;import com.sap.dbtech.rte.comm.RTEException;public class  MaxDBJDBC3{ public MaxDBJDBC3() { } public static void main(String[] args)  {  DBM session;  // Establishing a connection to the server and database.  try  {   session = DBM.dbDBM(“localhost”,”KATHIR”);   System.out.println(“\nConnection Established Successfully\n”);  }        catch (RTEException RE1)   {            System.out.println (“connect failed: ” + RE1.toString());            return;        } }}

Once connection is established we can execute the DBM commands. The cmd method is used to execute the DBM commands. The syntax of the same is DBM_Session_Variable.cmd(“DBM_COMMAND”).

import com.sap.dbtech.powertoys.*;import com.sap.dbtech.rte.comm.RTEException;public class  MaxDBJDBC3{ public MaxDBJDBC3() { } public static void main(String[] args)  {  DBM session;  // Establishing a connection to the server and database.  try  {   session = DBM.dbDBM(“localhost”,”KATHIR”);   System.out.println(“\nConnection Established Successfully\n”);  }        catch (RTEException RE1)   {            System.out.println (“\nConnection failed: ” + RE1.toString());            return;        }  // Executing a DBM command   try  {   String result = session.cmd (“db_enum”);   System.out.println(“\n The Result of the command Executed is :\n\n”);   System.out.println(result);  }        catch (RTEException RE2)   {            System.out.println (“\nConnection failed: ” + RE2.toString());            return;        }  catch(DBMException DE1)  {   System.out.println(“\nError executing command:” + DE1.toString());  } }}

The task is to close the active connection once all the necessary processing is done. The can be achieved with the help of release method. The syntax of the same is DBM_Session_Variable.release().

import com.sap.dbtech.powertoys.*;import com.sap.dbtech.rte.comm.RTEException;public class  MaxDBJDBC3{ public MaxDBJDBC3() { } public static void main(String[] args)  {  DBM session;  // Establishing a connection to the server and database.  try  {   session = DBM.dbDBM(“localhost”,”KATHIR”);   System.out.println(“\nConnection Established Successfully\n”);  }        catch (RTEException RE1)   {            System.out.println (“\nConnection failed: ” + RE1.toString());            return;        }  // Executing a DBM command   try  {   String result = session.cmd (“db_enum”);   System.out.println(“\n The Result of the command Executed is :\n\n”);   System.out.println(result);  }        catch (RTEException RE2)   {            System.out.println (“\nConnection failed: ” + RE2.toString());            return;        }  catch(DBMException DE1)  {   System.out.println(“\nError executing command:” + DE1.toString());  }  // Closing the connection  try  {   session.release();   System.out.println(“\nConnection Terminated Successfully\n”);  }  catch(RTEException RE3)  {            System.out.println (“\nError while connection termination:\n” + RE3.toString());  } }}

Thus we can perform MaxDB administrative operations with ease using JDBC technique.