Sharing data sources
To configure objects to use the same data sources, you
specify the same database connection for each object store or isolated
region. To configure for dedicated (nonshared) databases, you set
a different database connection for each object store or isolated
region.
Creating a database connection
You can create a database connection when several object stores or isolated regions share a database with the same database connection.
Database connections
A database connection identifies the XA and non-XA data source pair that provides the Java™ Database Connectivity (JDBC) connection to the database. Object stores and isolated regions can share a database by using a single database connection.
Guidelines for sharing database connections
Database connection sharing enables multiple object stores or isolated regions that reside in a single database to share a single data source. The ability to share a database is achieved by the use of a schema name. At object store creation time, you can specify a schema name and all the tables and indexes are created within that schema.