4 Replies Latest reply on Oct 25, 2013 11:17 AM by wdfink

    Installing Oracle9i JDBC JAR on AS 6.1

    puneetmathur
    puneetmathur Oct 23, 2013 11:58 PM

      Hi there

       

      Apologies if this has been asked before. I am very new to JBoss, transitioning from IBM WebSphere.

       

      I need to add Oracle9i  to the available list of drivers on the application server.  Looked at a couple of forums & they see to indicate that I need to copy the jdbc JAR into <server_path>/standalone/lib/ directory & then restart the server. Didn't work for me.

       

      Appreciate if you cn point me in the right direction.

       

      Thanks, Puneet

       


      • 391 Views
      • Tags:
        • 1. Re: Installing Oracle9i JDBC JAR on AS 6.1
          wdfink
          wdfink Oct 24, 2013 1:53 PM (in response to puneetmathur)

          Hi Puneet,

          welcome to the forum.

           

          From you r post I suppose you use not AS6.1 but AS7 or even EAP6.1 which is a big difference! (I know the numbers might be confusing)

          Check your version (i.e. if you have a standalone and domain folder it will be AS7/EAP6).

          In that case you need to install the driver and Datasource different.

          See this DataSource configuration and Data Source Configuration in AS 7

            • Actions
          • 2. Re: Installing Oracle9i JDBC JAR on AS 6.1
            puneetmathur
            puneetmathur Oct 24, 2013 10:03 PM (in response to wdfink)


            Hi Wolf-Dieter

             

            Thanks for the quick response.

             

            You are correct - I am using EAP 6.1.0 GA (as a part of Developer Studio).  On my 'L-plates'!

             

            I will have look at the links you have provided.

             

            Thanks again.

             

            Puneet

              • Actions
            • 3. Re: Installing Oracle9i JDBC JAR on AS 6.1
              puneetmathur
              puneetmathur Oct 25, 2013 12:04 AM (in response to puneetmathur)

              This is what I have done:

               

              1. Created a new directory tree - <server_path>/modules/system/layers/base/com/oracledatabase/oracle9i/main

                   (I have followed the path of how H2 is configured).

               

              2. Copied oracle9i.jar into the main directory

               

              3. Created module.xml in main, with the following content

              <module xmlns="urn:jboss:module:1.0" name="com.oracledatabase.oracle9i">
              <resources>
              <resource-root path="oracle9i.jar"/>
              </resources>
              <dependencies>
              <module name="javax.api"/>

              </dependencies>
              </module>

               

              4. Restarted the server.

               

              In the list of drivers when creating a new datasource, I still only see h2.   Not sure what I am doing wrong.

               


              Thanks, Puneet

                • Actions
              • 4. Re: Installing Oracle9i JDBC JAR on AS 6.1
                wdfink
                wdfink Oct 25, 2013 11:17 AM (in response to puneetmathur)

                Not sure whether oracle9i is the correct driver, I use ojdbc6.jar for all different DB versions.

                Anyway, after adding the module you need to add the <driver> element for the oracle driver in the datasources element first.

                After that you should see the driver.

                  • Actions