How to encrypt JMS password in SqlProperties?

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content