MaxDB Database Administration using JDBC – Part 2

MaxDB Database Administration using JDBC – Part 2

In this weblog we can see how to use the DBMCLI commands to create, display, and delete user entries for MaxDB using JDBC. The necessary java programs for the same is given below along with the screen shots for the output.

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

To create a new user first we must login as the DBM user with proper authorization for the same. The command that is used for the same is USER_LOGON. After logging into the DBMCLI we can execute the USER_CREATE command to create a new DBM user. The next task to get the details of a particular DBM user. In this weblog the properties of the newly created user ig being displayed using the command USER_GET

/******************************************************************//*   Programmed by Kathirvel Balakrishnan                         *//*   Project Engineer – SAP Practice – Wipro Technologies         *//******************************************************************/import com.sap.dbtech.powertoys.*;import com.sap.dbtech.rte.comm.RTEException;public class  MaxDBJDBC4{ public MaxDBJDBC4() { } 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  {   // Logon to the DBMCLI as the DBM user   session.cmd (“user_logon dbm,maxdb”);   System.out.println(“\nLogin successful”);      // Executing a command to create a new user NEWDBA   session.cmd (“user_create newdba,maxdb dba”);   System.out.println(“\nThe user NEWDBA has been created”);   // Displaying the properties of the NEWDBA user created    System.out.println(“\nDisplaying the properties of the user NEWDBA\n”);   String result = session.cmd(“user_get newdba”);   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());  } }}

Verification Using the DBMCLI.

To display all the users avaliable we can use the USER_GETALL. Then the command to delete a particular user is USER_DELETE. The program given below illustrates how we can display all the available users and also to delete a particular user.

/******************************************************************//*   Programmed by Kathirvel Balakrishnan                         *//*   Project Engineer – SAP Practice – Wipro Technologies         *//******************************************************************/import com.sap.dbtech.powertoys.*;import com.sap.dbtech.rte.comm.RTEException;public class  MaxDBJDBC5{ public MaxDBJDBC5() { } 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  {   // Logon to the DBMCLI as the DBM user   session.cmd (“user_logon dbm,maxdb”);   System.out.println(“\nLogin successful”);   // Displaying all the users available    System.out.println(“\nDisplaying all the user available for DBMCLI”);   String result = session.cmd (“user_getall”);   System.out.println(result);   // Deleting the user NEWDBA   System.out.println(“\nDeleting the user NEWDBA\n”);   session.cmd(“user_delete newdba”);   // Displaying all the users available    System.out.println(“\nDisplaying all the user available for DBMCLI after deleting newdba”);   result = session.cmd (“user_getall”);   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());  } }}

Verification Using the DBMCLI.