Configuring Tomcat Server

To configure Tomcat Server for the integration with Secret Server or with the Delinea Platform, perform the following tasks:

Configuring the Class Name of the JDBC Proxy Driver

To support the Delinea JDBC Proxy driver for your application, modify the application configuration file according to the following connection string and driver class.

Connection String

Database Connection String Delinea Driver Connection String
MYSQL Jdbc:mysql://localhost:port/databaseName jdbc:delinea:SSID:mysql://localhost:port/databaseName
SQLSERVER Jdbc:sqlserver://localhost: port;databaseName= databaseName jdbc:delinea:SSID:sqlserver://localhost: port;databaseName= databaseName
Oracle jdbc:oracle:thin:@localhost: port:databaseName jdbc:delinea:SSID:oracle:thin:@localhost: port:databaseName
Apache Derby :derby://localhost:port/database jdbc:delinea:SSID:derby://localhost:port/database

Driver Class:

Database Native Driver Class Proxy Driver Class
ANY com.mysql.jdbc.Driver com.delinea.jdbc.DelineaDriver

Note: In this case, use the example of MySQL (for example, SQL Server, Oracle, Apache Derby). The class name for the Delinea driver will be the same.

Configuring the Application for a Direct Connection

Go to the folder where the application is deployed, C:\Program Files\Apache Software Foundation\Tomcat 10.1\webapps and edit the Configuration file.

In your case, the application configuration file can vary, for example, * .txt, *.xml, *.properties, *.config. The following is an example of a Java JPA application with multiple DataSources.

Update only the following parameters of the database connection as follows:

  • Connection URL: URL property needs to be updated with the Delinea connection string as described below: jdbc:delinea:SSID:mysql://localhost:3306/databaseName.
  • Driver Class: Driver property needs to be updated with the class name of the driver: com.delinea.jdbc.DelineaDriver.

The parameters can vary per application and the configuration file appears as follows:

alt

The modified file looks like the following:

alt

  • The file has connection details for two databases, and the current configuration file contains a username, password, URL, and driver class name. The configuration file URL parameter will modify with the Delinea connection string add suffix delinea:SSID and driver parameter with Delinea driver class name com.delinea.jdbc.DelineaDriver. The username and password parameter are not needed.
  • Save and refresh the application.

Configuring the Application for a DataSource Connection

Go to your Web Server folder where the application is deployed, C:\Program Files\Apache Software Foundation\Tomcat 10.1\webapps, and edit the configuration file.

The application configuration file can vary, for example, (*.txt, *.xml, *.properties, *.config). The following is an example of a Java JPA application with multiple DataSources. The configuration should look like the following:

alt

There are two DataSources, java:comp/env/ jdbc/book and java:comp/env/jdbc /student, to connect with the application.

  • Data-Source: JNDI name of the Database Driver.

  • Add the proper prefix before the DataSource name. For the DataSource, add the prefix java:comp/env/.

  • The key names may vary as per your application.

  • Go to the Apache Tomcat folder and edit the Conf file (for example, C:\\Program Files\\Apache Software Foundation\\Tomcat10.0\\conf\\context.xml).

    alt

  • The DataSource name will follow connection details with the proxy driver and is present in the context.xml file.

The Tomcat Server configuration file will appear as follows:

alt

The modified configuration file looks like the following:

alt

  • The configuration file contains the driver class name and connection string of the native driver. Now the configuration should modify with the Delinea

    connection string by adding the suffix delinea:SSID after jdbc: and the driver class modify as com.delinea.jdbc.DelineaDriver.

  • driverClassName: com.delinea.jdbc.DelineaDriver
  • URL: jdbc:**delinea:SSID:**mysql://localhost:3306/databaseName
  • maxTotal & maxIdle: The values of these parameters are dependent on application requirement.
  • Save and refresh your application.