The following steps can be applied to application servers versioned from 6.0 and later. These instructions apply to applications that leverage the WebSphere Data Source database connectivity framework, which is the most common and recommend recommended method. However, if the application code bypasses the WebSphere framework and connects to a database directly (i.e.that is, it instantiates and manages the JDBC driver and connections on its own), use the instructions provided in JDBC Configuration for Standalone or Other Application Server Platforms.
...
- Creating a New JDBC Provider for the Parasoft JDBC Driver
- Modifying the Original Data Source Settings
- Creating a New JDBC Data Source with the Parasoft JDBC Driver or Alternative Method: Modifying Application Settings To to Use the Parasoft JDBC Driver With with a Different JNDI Name
Anchor | ||||
---|---|---|---|---|
|
...
- Log in to your WebSphere Application Server’s Integrated Solutions Console.
- Open Resources> Resources > JDBC and click JDBC Providers.
- Select Node> Choose Node > Server scope (the 3rd option) then and click New.
- Complete the Create New JDBC Driver screen , then click Next:and click Next.
- Database type: Choose User-defined.
- Implementation class name: Specify one of the values that are available (this depends on the database vendor JDBC driver currently in use). See JDBC Driver Implementation Classes for details.
- Name: Enter any name you want to assign this Parasoft JDBC Driver.
- In the Enter database class path information screen, enter the path to the location to where you placed the Parasoft JDBC Driver jar file.
- Complete the Summary screen by clicking Finish.
...
You will modify the JNDI name of the data source so that you can define a separate new Data Source with that same JNDI name. This will prevent naming conflicts with the existing data source. It also saves you from having to change the application itself (or its deployment configuration) within WebSphere. If more than one deployed application uses that same Data Source definition and you do not want to impact these other applications, see Alternative Method: Modifying Application Settings To to Use the Parasoft JDBC Driver With with a Different JNDI Name, which explains how to alter the application settings with a different/new Data Source configuration (instead of altering the existing Data Source configuration).
...
- Go to the Data Source that is currently being used by your application .Note and note the settings and configurations in the main configuration page. You will need the property names and values later when you are configuring a new Data Source for the Parasoft JDBC Driver.
- Click Custom Properties.
- Note any property names and values there. You will need them later when you are configuring a new Data Source for the Parasoft JDBC Driver.
- Note the JNDI name for the data source. The JNDI name is what the application uses in order to look up the JDBC data source to use. You will use that same value in the new Data Source for the Parasoft JDBC Driver.
To perform the adjustment (using the PlantsByWebSphere sample application [ provided with WebSphere ] as an example):
Change the JNDI name to a different value, then click Apply. For instance, if the original value was
jndi/PlantsByWebSphereDataSource
, it could be changed tojndi/PlantsByWebSphereDataSourceOriginal
.Tip JNDI Naming Tip
JNDI names often take a hierarchical, directory-like form to indicate subcontexts. For example, if your original Data Source JNDI name is
jdbc/zOS_DB2DataSource
, then you should avoid renaming it tojdbc/zOS_DB2DataSource/Original
(using a / divider) because that can cause JNDI binding conflicts in the application. Instead, use names such asjdbc/zOS_DB2DataSourceOriginal
and avoid your JNDI name being interpreted as a subcontext.- Take note of any special/custom properties the data source has defined. You will need these when you create a new data source for the Parasoft JDBC Driver.
...
Next, you will use WebSphere's New Data Source wizard to create a new Data Source configuration that uses the JDBC Provider you created.
- Open Resources> JDBC> Resources > JDBC > Data Sources.
- Complete the Enter basic data source information screen as follows:
- Data source name: Enter any name you want to assign to this data source.
- JNDI name: Enter the JNDI name you collected for the application's data source (see Modifying the Original Data Source Settings). For example, in the case of the PlantsByWebSphere sample application, you would use
jndi/PlantsByWebSphereDataSource
.
- Complete the Select JDBC provider screen as follows:
- Choose Select an existing JDBC provider.
- Select the provider that you created inCreating a New JDBC Provider for the Parasoft JDBC Driver.
- In the Enter database specific properties for the data source screen, leave the default Data store helper class name. If If the application which uses the data source uses CMP, then also select enable Use this data source in container managed persistence (CMP).
- In the Specify security aliases screen, leave the defaults , then and click Next.
- Click Finish.
- In the new Parasoft data source that was created, add the same properties you noted in the application's data source configuration (as described in Modifying the Original Data Source Settings), plus additional properties for the Parasoft JDBC Driver data source.
- The Parasoft JDBC Driver specific properties that need to be defined are:
- virtualizeServerUrl
- virtualizeGroupID
For example, for the PlantsByWebSphere sample application, you could use the following settings:
Info Related Resources
For information about properties specific to the database and JDBC driver that is being virtualized, see Troubleshooting JDBC Driver Issues.
Info If Properties are Generated Automatically...
Some WebSphere versions might automatically introspect the Parasoft JDBC Driver and generate the available properties. If this happens, delete the description, logWriter, loginTimeout and user properties if they show up.
- The Parasoft JDBC Driver specific properties that need to be defined are:
- Save the changes to the WebSphere master configuration.
- Restart WebSphere.
- Return to the Parasoft JDBC Data source and click Test connection.
If the configuration was performed properly, there should be no errors. 1 One or 2 two warnings are expected:
This warning is shown because GenericDataStoreHelper is used in the Parasoft JDBC data source.
Anchor | ||||
---|---|---|---|---|
|
...
to Use the Parasoft JDBC Driver
...
with a Different JNDI Name
These instructions can be applied in the cases where you do not want to modify the original data source-–perhaps , such as in the cases where the same data source is used by multiple applications and you want to virtualize the database connections for only a specific application. These instructions apply to enterprise applications that can have their data source JNDI bindings modified in the WebSphere through the administrative console.
Open Applications> Applications > Enterprise Applications (or Applications> Applications > Application Types> Types > Web-Sphere enterprise applications in other versions of WebSphere).
Click the desired application. This is the application that will be reconfigured to use the new Parasoft JDBC Driver data source.
Info For WebSphere 6.1 and earlier
If the application uses CMP persistence (which in the case with the PlantsByWebSphere example), click “Provide Provide default data source mapping for modules containing 2.x entity beans” and beans and modify the current target resource JNDI name with the JNDI name you provided in Creating a New JDBC Data Source with the Parasoft JDBC Driver (step 2), but prefix prepend it with
eis/
and postfix append it with_CMP
. For example, if you configured the Parasoft JDBC Driver data source withjdbc/ParasoftJDBCDataSource
, here you will provideeis/jdbc/ParasoftJDBCDataSource_CMP
After that, click Map data sources for all 2.x CMP beans and modify the current target resource JNDI name with the JNDI name you provided in Creating a New JDBC Data Source with the Parasoft JDBC Driver (step 2) in the previous section, but prefix and postfix prepend it with
eis/
and append with_CMP
accordingly.Tip JNDI Naming Tip
JNDI names often take a hierarchical, directory-like form to indicate subcontexts. For example, if your original Data Source JNDI name is
jdbc/zOS_DB2DataSource
, then you should avoid renaming it tojdbc/zOS_DB2DataSource/Original
(using a / divider) because that can cause JNDI binding conflicts in the application. Instead, use names such asjdbc/zOS_DB2DataSourceOriginal
and avoid your JNDI name being interpreted as a subcontext.