Using CA Application Test › Using the Workstation and Console with CA Application Test › Reports › Changing Reporting Databases

Changing Reporting Databases

You can set the way that you configure DevTest to connect to alternate databases in lisa.properties or site.properties. Set DevTest database components by assigning each component to a defined pool configuration like:

lisadb.reporting.poolName=common
lisadb.vse.poolName=common
lisadb.legacy.poolName=common
lisadb.acl.poolName=common

By default all of the DevTest databases share a common Derby database connection pool as defined here.

lisadb.pool.common.driverClass=org.apache.derby.jdbc.ClientDriver
lisadb.pool.common.url=jdbc:derby://localhost:1528/database/lisa.db;create=true
lisadb.pool.common.user=rpt
lisadb.pool.common.password=rpt

For example, to change the reporting database to connect to Oracle, first define a new database pool configuration.

lisadb.pool.mypool.driverClass=oracle.jdbc.OracleDriver
lisadb.pool.mypool.url=jdbc:oracle:thin:@//myhost:1521/orcl
lisadb.pool.mypool.user=rpt
lisadb.pool.mypool.password=rpt

Then set the reporting component to use that pool.

lisadb.reporting.poolName=mypool

When you enter the Reporting Portal, you can mouse over the database icon on the upper-right corner of the window to get the details about the database you are using.