IBM Support What's New?

Re-encrypting credit card data in custom tables using CCInfoReencoderfo

Technote (troubleshooting)


Problem(Abstract)

Attempting to re-encrypt encrypted data in a custom table using the com.ibm.commerce.dbupdatetool.CCInfoReencoder class does not work.

Symptom

No errors are logged when using the com.ibm.commerce.dbupdatetool.CCInfoReencoder class.


Cause

The com.ibm.commerce.dbupdatetool.CCInfoReencoder class can only handle these database columns:

ORDPAYINFO.VALUE
ORDPAYMTHD.PAYDEVICE
PATTRVALUE.STRINGVALUE


Resolving the problem

To re-encrypt encrypted data in custom tables, you must use MigrateEncryptedInfo, using the com.ibm.commerce.dbupdatetool.DataReEncrypter plug-in class.


Add a new ActionItem to the following configuration file to use the com.ibm.commerce.dbupdatetool.DataReEncrypter class:

i5/OSWC_userdir/schema/DBTYPE/migration/DBUpdate.txt
AIXWC_installdir/schema/DBTYPE/migration/DBUpdate.txt
LinuxWC_installdir/schema/DBTYPE/migration/DBUpdate.txt
SolarisWC_installdir/schema/DBTYPE/migration/DBUpdate.txt
WindowsWC_installdir\schema\DBTYPE\migration\DBUpdate.txt

Here is a sample ActionItem section to add to DBUpdate.txt:

[ActionItem]
ID=ReEncryptCustomData
DisplayID=Re encrypt custom data
UpdateClassName=com.ibm.commerce.dbupdatetool.DataReEncrypter
[DBAccess]
DriverClassName=COM.ibm.db2.jdbc.app.DB2Driver
HostName=
HostJDBCPort=
ConnectionPrefix=jdbc:db2
DatabaseName=
DatabaseUserName=
DatabaseUserPassword=
[DBTable]
TableName=TableXXX
TableColumns=Column1, Column2
UniqueColumns=TableXXXPrimaryKey
[Parameter]
ID=OldEncryptionKey
DisplayID=OldEncryptionKey
Value=
[Parameter]
ID=NewEncryptionKey
DisplayID=NewEncryptionKey
Value=

Document information

More support for: WebSphere Commerce Enterprise

Software version: 6.0

Operating system(s): AIX, IBM i, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1320895

Modified date: 2015-02-18