How to encrypt JMS password in SqlProperties?
Issue
- How to encrypt PASSWD string in SqlProperties specified in *-persistence-service.xml ?
<attribute name="SqlProperties"><![CDATA[
CREATE_USER_TABLE=CREATE TABLE JBM_USER (USER_ID VARCHAR2(32) NOT NULL, PASSWD VARCHAR2(32) NOT NULL, CLIENTID VARCHAR2(128), PRIMARY KEY(USER_ID))
CREATE_ROLE_TABLE=CREATE TABLE JBM_ROLE (ROLE_ID VARCHAR2(32) NOT NULL, USER_ID VARCHAR2(32) NOT NULL, PRIMARY KEY(USER_ID, ROLE_ID))
SELECT_PRECONF_CLIENTID=SELECT CLIENTID FROM JBM_USER WHERE USER_ID=?
POPULATE.TABLES.1 = INSERT INTO JBM_USER (USER_ID, PASSWD) VALUES ('echjms', 'xxx')
POPULATE.TABLES.2 = UPDATE JBM_USER SET PASSWD='${jmsps}' WHERE USER_ID='echjms'
POPULATE.TABLES.3 = INSERT INTO JBM_ROLE (ROLE_ID, USER_ID) VALUES ('echjms','echjms')
POPULATE.TABLES.4 = DELETE FROM JBM_ROLE WHERE ROLE_ID='guest'
POPULATE.TABLES.5 = DELETE FROM JBM_USER WHERE USER_ID='guest'
]]></attribute>
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.