How do I secure the data source connection in JBoss?
dattu May 19, 2014 2:11 AMHi,
We have deployed our application in Jboss 7. In standalone.xml, we have configured a data source to connect to our oracle DB as shown below. We are planning to migrate from Plain JDBC to SSL version of JDBC to connect to oracle database. I could not able to locate any documentation to address this issue in Jboss. As per the oracle documentation (http://docs.oracle.com/cd/B19306_01/java.102/b14355/sslthin.htm) it can be achieved with the help of JSSE. There are number of documentations available to enable SSL over HTTP with JSSE. In order to configure SSL data source in Jboss, there are no proper guide or sample documentations. Kindly share your thoughts if anyone has more idea on this? Thanks in advance.
<datasource jta="false" jndi-name="java:jboss/APPDS" pool-name="DBConnectionPool" enabled="true" use-java-context="false" spy="true" use-ccm="true">
<connection-url>jdbc:oracle:thin:@[someip]:1565:[sid]</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<connection-property name="char.encoding">
UTF-8
</connection-property>
<connection-property name="autoCommit">
true
</connection-property>
<driver>oracle</driver>
<pool>
<min-pool-size>2</min-pool-size>
<max-pool-size>100</max-pool-size>
</pool>
<security>
<user-name>username</user-name>
<password>pwd</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.vendor.OracleStaleConnectionChecker"/>
</validation>
<timeout>
<blocking-timeout-millis>50000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
</timeout>
</datasource>
Thanks,
Shan