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=


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

6.0

Operating system(s):

AIX, Linux, Solaris, Windows, i5/OS

Software edition:

All Editions

Reference #:

1320895

Modified date:

2013-09-12

Translate my page

Machine Translation

Content navigation