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

Managing JDBC resources

 `createdatabaseresource`
 Persistence Management → `createJdbcResource`
 `listdatabaseresources`
 Persistence Management → `getJdbcResources`
 `removedatabaseresource`
 Persistence Management → `removeJdbcResource`

Managing persistence instance references

 `addpersistenceinstanceref`
 Persistence Management → `setJdbcResourcePersistenceInstanceRef`
 `listpersistenceinstancerefs`
 Persistence Management → `getJdbcResourcePersistenceInstanceRef`
 `removepersistenceinstanceref`
 Persistence Management → `removePersistenceResourcePersistenceInstanceRef`

Managing database connections

 `createjdbcresourceconnectionpoolconfig`
 Persistence Management → `createJdbcResourceConnectionPoolConfig`
 `dumpjdbcresourceconnectionpoolconfig`
 Persistence Management → `getJdbcResourceConnectionPoolConfigMBean`
JDBC Resource Connection Pool Management → `get...`
 `setjdbcresourceconnectionpoolconfig`
 JDBC Resource Connection Pool Management → `set...`
 `removejdbcresourceconnectionpoolconfig`
 Persistence Management → `removeJdbcResourceConnectionPoolConfig`
Previous page Next page
Rhino Version 3.0.0