JBoss Configuration with oracle step by step

JBoss configuration with Oracle Step by step

Here we using  jboss-eap-6.2.To Configure jboss with oracle please follow the following steps

1.   At first we need to download jboss-eap-6.2 from www.jboss.org/products/jbossas/downloads

2. You need to oracle jdbc driver to connect with oracle.We used ojdbc6.jar as jdbc driver.you can download its from internet.

     Put this jar into jboss-eap-6.2\modules\system\layers\base\com\oracle\main directory.

      3.  Create  a module.xml file in this directory and write following code

XML

 

1

        <resources>

2

            <resource-root path="ojdbc6.jar">

3

            </resource-root>

4

        </resources>

5

        <dependencies>

6

          <module name="javax.api"></module>

7

          <module name="javax.transaction.api"></module>

8

          <module name="javax.servlet.api" optional="true"></module>

9

        </dependencies>

  4.   Now we need to configure datasources for our project. We can find our datasources configuration in jboss-eap-6.2\standalone\configuration\standalone.xml. Now we need to define datasources in this  file.You need to find-out datasources tag and inside this you can put your datasource. 

XML

 

1

    <datasource enabled="true" jndi-name="java:jboss/datasources/KBankDSOracle"          jta="false" pool-name="KBankDSOracle" use-ccm="false">

2

      <connection-url>jdbc:oracle:thin:@192.162.11.90:1521:orcl</connection-url>

3

               <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

4

               <driver>com.oracle</driver>

5

                 <security>

6

                  <user-name>kbank</user-name>

7

                  <password>password</password>

8

                 </security>

9

                 <validation>

10

                   <validate-on-match>false</validate-on-match>

11

                   <background-validation>false</background-validation>

12

                 </validation>

13

                 <statement>

14

                   <share-prepared-statements>false</share-prepared-statements>

15

                 </statement>

16

    </datasource>

     5. Now you can change your configuration based on your database property.And then you need to define drivers for this datasource. We put our jar file in proper directory that I defined earlier.Now you need to findout Drivers tag inside of datasources tag.you need to write following XML code to your standalone.xml file.

XML

 

1

       <driver module="com.oracle" name="com.oracle">

2

       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

     6. Now you need to configure your Project according to this setup.Thanks