Solved

Encrypt Oracle Datasource Password in JBoss 5

Posted on 2012-04-02
4
1,565 Views
Last Modified: 2013-12-29
HI

I am hosting my java based application on RHEL based server and Jboss 5 application server and using Oracle RAC as backend.  I am keeping my datasource information in deploy/oracle-ds.xml file and password is also stored in plain text formant.

Please suggest procedure to keep the datasource password in encrypted form.  Here below are extract of oracle-ds.xml file:

<datasources>
  <local-tx-datasource>
    <jndi-name>OracleDS</jndi-name>
                <connection-url>
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=ORACLE_SERVER_HOSTNAME)(port=1521))(connect_data=(server=dedicated)(service_name=DB_SERVICE_NAME)))
                </connection-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>ORACLE_USER</user-name>
    <password>ORACLE_PASSWORD</password>
    <min-pool-size>0</min-pool-size>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  </local-tx-datasource>
0
Comment
Question by:ashuji
4 Comments
 
LVL 19

Accepted Solution

by:
ramazanyich earned 500 total points
ID: 37826423
it is described quite good in the https://community.jboss.org/wiki/EncryptingDataSourcePasswords There is a section for jboss 5.x there
0
 

Author Closing Comment

by:ashuji
ID: 37827087
Exact solution pointed.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now