WebSphere Application Server Integration Verification

This topic provides information to verify that your application can make a data source or direct connection to the database by using the Delinea JDBC Proxy Driver in WebSphere Application Server.

Verifying a Non XA Data Source Connection

To verify that your application can successfully make a Non XA data source connection to the database by using the Delinea JDBC Proxy Driver, use the logs in WebSphere Application Server. In WebSphere Application Server, these logs are typically written to C:\Program Files\IBM\WebSphere\AppServer1\profiles\AppSrv01\logs\server1\SystemOut.log.

Open the SystemOut.log file by using any text editor (for example, Notepad++) and search for the following log lines:

  • DelineaConnectionPoolDataSource: getPooledConnection()
  • DelineaDriverHelper: Inside DelineaDriverHelperinit
  • DelineaDriverHelper: Driver configuration read successfully
  • DelineaDriverHelper: Inside getSSCredential
  • CommonDelineaDataSource: DB credential fetched successfully from Server

These log entries confirm that:

  • The data source logic is being executed.
  • The JDBC Proxy Driver is initializing correctly.
  • The driver is able to read its configuration.
  • Database credentials are being successfully fetched from Secret Server.

Verifying a XA Data Source Connection

To verify that your application can successfully make a XA data source connection to the database by using the Delinea JDBC Proxy Driver, use the logs in WebSphere Application Server. In WebSphere Application Server, these logs are typically written to C:\Program Files\IBM\WebSphere\AppServer1\profiles\AppSrv01\logs\server1\SystemOut.log.

Open the SystemOut.log file by using any text editor (for example, Notepad++) and search for the following log lines:

  • DelineaXADataSource: getXAConnection()
  • DelineaDriverHelper: Inside DelineaDriverHelperinit
  • DelineaDriverHelper: Driver configuration read successfully
  • DelineaDriverHelper: Inside getSSCredential
  • CommonDelineaDataSource: DB credential fetched successfully from Server

These log entries confirm that:

  • The data source logic is being executed.
  • The JDBC Proxy Driver is initializing correctly.
  • The driver is able to read its configuration.
  • Database credentials are being successfully fetched from Secret Server.

Verifying a Direct Connection

To verify that your application can successfully make a direct connection to the database by using the Delinea JDBC Proxy Driver, use the logs in WebSphere Application Server. In WebSphere Application Server, these logs are typically written to C:\Program Files\IBM\WebSphere\AppServer1\profiles\AppSrv01\logs\server1\SystemOut.log.

Open the SystemOut.log file by using any text editor (for example, Notepad++) and search for the following log lines:

  • DelineaDriver: Driver register successfully
  • DelineaDriver: Loading the property file of DelineaDriver
  • DelineaDriverHelper: Driver configuration read successfully
  • DelineaDriver: Database credential fetched successfully from Secret Server

These log entries confirm that:

  • The JDBC Proxy Driver was loaded successfully.
  • The JDBC Proxy Driver is reading its configuration from the DelineaDriver.properties file.
  • The driver is able to read its configuration.
  • Database credentials are being successfully fetched from Secret Server.