Rhino 2.7.0 :: 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

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

Previous page Next page

JDBC Resources