You can configure the AllDBConnector class
to use encrypted passwords that are stored in an Oracle Wallet to
authenticate a user to establish a database connection for WebSphere
Commerce utilities.
About this task
To complete the following steps, you must run the Oracle
mkstore utility. For more information about the Oracle Wallet and
running Oracle utilities, including any updated usage syntax, see Oracle Technology Network.
Procedure
- Create an Oracle Wallet with the Oracle mkstore utility.
In a command-line utility, run the following command from
Oracle
bin directory:
mkstore -wrl wallet_directory -create
Where
For example,
mkstore -wrl wallet.nonssl -create
- Add the database user credentials into the Oracle Wallet
for users that you do want to continue sending between the utility
client and database server tiers to authenticate the users.
In a command-line utility, run the following command from
Oracle
bin directory:
mkstore -wrl wallet_directory -createCredential tns-name user
Where
For example,
mkstore -wrl wallet.nonssl -createCredential orcl wcs
The Oracle Wallet is now enabled to support automatic
authentication of the
wcs
users to the
orcl
TNS
name.
- Update the AllDBConnector class configuration
for establishing a database connection for WebSphere Commerce utilities
to use the encrypted passwords in the Oracle Wallet.
- Go to the following directory and open the alldbconnector.xml configuration
file for editing.
- WC_installdir/WC/xml/config
- WC_installdir\WC\xml\config
- WCDE_installdir\WC\xml\config
- Update the alldbconnector.xml file
to include an override configuration for how to authenticate users.