Configuration
After completing the Setup, you need to configure how the JDBC Proxy Driver connects to your database. The configuration process depends on:
- Your web server type (WebSphere, Tomcat, or JBoss)
- Your connection approach (Direct Connection or DataSource Connection)
Choosing Your Connection Approach
The Delinea JDBC Proxy Driver supports two connection approaches. You only need to configure ONE approach based on how your application currently connects to the database:
Option 1: Direct Connection
Choose this if:
- Your application reads database configuration (username, password, driver URL) directly from its configuration file
- You create connections using
DriverManager.getConnection()or similar methods - Database credentials are specified in application properties files.
Option 2: DataSource Connection
Choose this if:
- Your application uses JNDI lookup to obtain database connections
- Your web server manages connection pooling.
- DataSource configuration is in server configuration files (context.xml, server.xml, standalone.xml)
Within DataSource Connection, choose the appropriate transaction type:
- Non-XA DataSource - For single database transactions (most common use case).
- XA DataSource - For distributed transactions across multiple databases, JMS, or other resources requiring two-phase commit.
Configuration by Web Server
Follow these steps to complete the configuration:
Step 1: Configure Delinea
Ensure that Delinea Platform or Secret Server is properly configured:
- Service accounts or application accounts must be created.
- Database credentials must be stored as secrets.
- Appropriate permissions must be granted to access these secrets.
Step 2: Configure JDBC Logging
Configure logging to help with troubleshooting and monitoring:
Step 3: Choose Your Web Server Based on Your Connection Approach
Once you've determined your connection approach, follow the configuration instructions for your specific web server:
