Obtaining a List of Database Connections

The sample code below illustrates how to obtain a simple list of database connections. No maximum is set and no sort order is specified.

// create a WebObjectsFactory instance

WebObjectsFactory factory = WebObjectsFactory.getInstance();

// Get the DB connection source object

DBConnectionSource source = (DBConnectionSource) factory.getMonitorSource(EnumWebMonitorType.WebMonitorTypeDBConnection);

// Set up the flag to obtain browsing information

source.setLevel(EnumDSSXMLLevelFlags.DssXmlBrowsingLevel);

try {

// Sends the request to Intelligence Server to retrieve DB connection information

DBConnectionResults results = source.getDBConnections();

// Loop through the results to print out DB connection information, such as

// DB connection number, DB connection instance name, user name.

for (int i=0; i < results.getCount(); i++) {

DBConnection singleConn = results.get(i);

System.out.print("DBConn number: " + singleConn.getDBConnectionNumber());

System.out.print(", instance name: " + singleConn.getInstanceName());

System.out.print(", db login name: " + singleConn.getLoginName());

System.out.println();

}

} catch (WebObjectsAdminException woae) {

woae.printStackTrace();

}

There is no particular order in the collection, because a sort criterion was not specified.

Sample output

The output would look something like the following:

DBConn number: 2, instance name: myInstance, db login name: sa

DBConn number: 3, instance name: specialInst, db login name: sa

DBConn number: 1, instance name: dbinst2, db login name: admin