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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
