Rhino 3.1 :: Rhino Administration and Deployment Guide

JDBC resources are used by application components such as service building blocks (SBBs) to execute SQL statements against an external database. A systems administrator can configure new external database resources for applications to use.

As well as an overview on how SBBs can use JDBC to execute SQL and an overview on managing physical database connections, this section includes instructions for performing the following Rhino SLEE procedures with explanations, examples and links to related javadocs:

Procedure rhino-console command(s) MBean(s) → Operation

Procedure	rhino-console command(s)	MBean(s) → Operation
Managing JDBC resources
Creating a JDBC resource	createdatabaseresource	Persistence Management → `createJdbcResource`
Displaying JDBC resources	listdatabaseresources	Persistence Management → `getJdbcResources`
Removing a JDBC resource	removedatabaseresource	Persistence Management → `removeJdbcResource`
Managing persistence instance references
Adding a persistence instance to a JDBC resource	addpersistenceinstanceref	Persistence Management → `setJdbcResourcePersistenceInstanceRef`
Displaying a JDBC resource’s persistence instance reference	listpersistenceinstancerefs	Persistence Management → `getJdbcResourcePersistenceInstanceRef`
Removing a persistence instance from a JDBC resource	removepersistenceinstanceref	Persistence Management → `removePersistenceResourcePersistenceInstanceRef`
Managing database connections
Adding a connection pool configuration to a JDBC resource	createjdbcresourceconnectionpoolconfig	Persistence Management → `createJdbcResourceConnectionPoolConfig`
Displaying a JDBC resource’s connection pool configuration	dumpjdbcresourceconnectionpoolconfig	Persistence Management → `getJdbcResourceConnectionPoolConfigMBean` JDBC Resource Connection Pool Management → `get…`
Updating a JDBC resource’s connection pool configuration	setjdbcresourceconnectionpoolconfig	JDBC Resource Connection Pool Management → `set…`
Removing the connection pool configuration from a JDBC resource	removejdbcresourceconnectionpoolconfig	Persistence Management → `removeJdbcResourceConnectionPoolConfig`

Managing JDBC resources

Creating a JDBC resource