8:35 PM

Jabung Jabung Admin Manual

posted under by Milinda Lakmal Pathirage | Edit This
This tutorial is intended to get you up to speed with Jabung Jabung Admin in several minutes. The tutorial is divided into n sections which you may follow in the given order. If in case you want to understand a particualr part, feel free to skip sections.
  • Getting Started
  • Configuring Driver Manager
  • Making Database Connections
  • Navigating Through The Database
  • Viewing Database Information
  • Issueing SQL Queries
  • Visually Editing Tables
Getting Started

Jabung Jabung Admin is a database administration tool which helps you in accomplishing your day-to-day database administrative requirements. Jabung Jabung is not restricted to a particular DBMS (Database Management System), it can work with a variety of Database Management Systems (Precisely, any DBMS with JDBC support). Using Jabung Jabung Admin, you can log on to any DBMS that you have access to - navigate through the Database shema and view Database tables and so forth. Also, you can visually edit Database tables using the tools provided by Jabung Jabung Admin. If that is not enough, Jabung Jabung Admin comes with a sophisticated SQL editor through which you can issue various SQL queries.

Configuring Driver Manager

You can use the Driver Manager to load new drivers for a Database Management System of your choice. Some of the more popular commercially available Database Management Systems are already listed. You can add or remove any other drivers of your choice to or from this list.

Drivers Tab
Figure 1

Adding a New Driver

You can either use the "Add New Driver" option from the Drivers menu or click on the Add Driver button from the tool box. This will add a new connection to the Drivers List in the Driver Manager. Enter the Driver Name, Class Path and URL Format in the appropriate fields. For a commercial driver, these details are supplied with the driver.

Click on the Load Driver" button to select the driver file. This file should be in .jar format. You can also use the Drivers > Load Driver menu option to do this.

The Driver Manager will load the driver from the file and display a message to notify you of success.

Removing a Driver

Selecting the driver from the driver list in the Driver Manager and selecting Driver > Remove Driver
or clikcing on the Remove Driver button from the toolbox will remove the driver.

Connections Tab

Figure 2

The Connections Tab displays a lift of the databases you are currently connected to.

Settings Tab
Figure 3

This tab contains a number of self explanatory fields which you can check or uncheck to set options.

Making Database Connections

Figure 4
To make a new database connection, you can use either the Connections > Add New Connection menu or click on the Add Connection button on the toolbox. This will display the New Connection window.

Enter a name for your connection in the Connection Identifier field. This name will be used throughout the session to identify the connection. Select the driver for the database you want to connect. A list of field for the parameters required by the selected driver will be displayed. Click on the Connect button the connect to the database.

Once the connection is made, the New Connection Window will close and you can start working with the database using the navigation tree and the SQL editor.

Navigating Through the Database

You can use the tree on the panel to the left to navigate through the schema. This panel displays the database structure of all the databases that you are connected to in a tree format. Under the "Connections"
heading of the tree you will see the connections you have made by the Connection Identifier you entered. Expanding a connection will reveal the database structure.

Figure 5

Under a connection, you will see the catalogs in the database. These catalogs can be considered as databases in the Database Management System that you have connected to. Under each catalog, the schemas of the catalog will be displayed. Under each schema in the tree, the tables and procedures will be displayed, grouped by their respective types.

Viewing Database Information

You can click on any part of the tree to view information about the database. Clicking on the tree will display the relevant information in the "Information" tab on the right-hand panel.

Figure 6

Clickinng on a connection will display a sub-panel will a number of tabs which display various ifnormation about the database:

Catalogs - Displays the catalogs in the database.
Database Info - Displays information about the database, such as the the name and version information.
Functions - Displays funtions supported by the database. They are grouped as Time Date functions, String functions, System functions and Numeric functions.
Type Info - Displays information about the data types available in the database.
Extra Info - Additional information about the database.

Selecting a schema from the tree will display the tables and procedures in the schema in the information panel. By expanding the tree further, you can select the table or procedure you wish to see information about.

When a table is selected, the information panel will display the data on the table, information about the table, column information, indexes, and primary key information if available.

Note :

Exceptions may be generated during the session due to various reasons such as connection faliure, functions unsupported by the database, etc. These messages will be displayed in the Exception panel at the botton right-hand corner.

Issuing SQL Queries

The SQL Editor tab can be used to issue SQL queries to the database that you are connected to.

Figure 7

The SQL editor has many useful features to make your task of querying the database easier. If you have many connections, you can select the connection you want from the combo box to the right. The willl behave intelligently which will make your qurey building easier.

8:22 PM

Jabung Jabung Admin - The Database Administration Tool

posted under by Milinda Lakmal Pathirage | Edit This