Create a JNDI-based Database operations in IBM WebSphere
This section provides the steps to enable IBM WebSphere for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
aa813test
This section provides the steps to enable IBM WebSphere for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
Follow these steps
:- Log in to WebSphere Administration Console.
- ClickResourcesand expand theJDBCnode.
- ClickJDBC Providers.The JDBC Providers page appears.
- In thePreferencessection, clickNew.The Create a new JDBC Provider page appears.
- Perform the following steps to create a JDBC provider:See for more information about JDBC providers.
- Set the CLASSPATH for the JDBC provider that you created in Step 5.
- ClickResourcesand expand theJDBCnode.
- ClickJDBC Providers.The JDBC Providers page appears.
- Click the JDBC provider that you created in Step 5.
- Set theClass Pathfor the JDBC JAR.
- ClickApplyto save the changes.
- Create a Data Source, as follows:
- Go toResources, and then clickJDBC.
- UnderJDBC, openData Sourcesand clickNew. Perform the following steps to create a data source:
- Specify theData source name.
- Specify theJNDI name. This name must match with the AppServerConnectionPoolName.Nin arcotcommon.ini.
- ClickNext.
- Select the JDBC provider that you created in Step 3.
- ClickNext.The Enter database specific properties for the data source screen appears.
- Depending on the database, enter the following information:
- For Oracle:Specify theValuefor JDBC URL. This URL would be of the following type:
jdbc:oracle:thin:@<server>:<oracle_port>:<sid>jdbc:sqlserver://<server>:<sql_port>;databaseName=<databasename>;selectMethod=cursorSelect theData store helper class name. - For Microsoft SQL Server:
- ClickNext.The Setup Security aliases screen appears.
- ClickNextto view the Summary screen, and then clickFinish.
- Click the data source that you created in Step 7.
- In theRelated Itemssection, clickJAAS - J2C authentication data.
- ClickNewto create a credential.
- Enter login credentials that are used to connect to the database and save the credential.
- ClickApply, and then clickOKto save the changes.
- ClickData Sourcesand select the data source that you created in Step 7.
- UnderSecurity Settings->Component-managed authentication alias, select the JAAS credential that you created in Step 11 and clickApply, and thenOK.
- ClickData Sourcesand select the check box for the data source you created in Step 7.
- ClickTest connectionto verify that you have specified the connection correctly.
This test only checks the connection to the database server, not necessarily the correct definition of the data source.