1 2 Previous Next 18 Replies Latest reply on Sep 28, 2012 9:52 AM by bpmm Go to original post
      • 15. Re: Oracle datasource - missing/unsatisfied dependencies
        tc7

        Replace the <xa-datasource-class> element with one along the lines of the informix example above, eg:

         

                             <!-- oracle driver referenced above -->

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

                                <driver-class>

                                    oracle.jdbc.OracleDriver

                                </driver-class>

                            </driver>

        • 16. Re: Oracle datasource - missing/unsatisfied dependencies
          salecha.rohit

          Lets say i am not configuring the module.xml  , i am simply deploying my oracle driver into the deployment folder. then what shud i mention in standalone.xml in the

          <datasource>

               <driver>

               ??????

               </driver>

          </datasource>

          • 17. Re: Oracle datasource - missing/unsatisfied dependencies
            tc7

            I was in the same boat as you and found repackaging the jdbc jar to be jdbc4 compliant (i.e. with appropriate META-INF) was tedious and the jdbc driver deployment might fail on startup.

             

            I found it much simpler and cleaner to define a module containing the driver. Creating a module is straight-foward.

             

            Follow the instructions above for "Creating an Informix JDBC module for JBoss AS 7.0.1" but substitute oracle for informix and you should be away.

             

             

            Step by step:

             

            1) standalone.xml

            <datasource jndi-name="myAppDS" pool-name="MyAppDS" enabled="true" jta="true" use-java-context="false" use-ccm="true">

                <connection-url><JDBC CONNECTION URL HERE></connection-url>

                <driver>oracle</driver>

                <pool>

                    <min-pool-size>3</min-pool-size>

                    <max-pool-size>20</max-pool-size>

                    <prefill>true</prefill>

                    <use-strict-min>false</use-strict-min>

                    <flush-strategy>FailingConnectionOnly</flush-strategy>

                </pool>

                <security>

                    <user-name>someuser</user-name>

                    <password>somepasswd</password>

                </security>

            </datasource>

             

            <!-- oracle driver referenced above -->

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

              <driver-class>

                oracle.jdbc.OracleDriver

              </driver-class>

            </driver>

             

             

            2) create a new module for your jdbc driver

            create path: <jboss-home>/modules/com/oracle/jdbc/1_4/main/

            module.xml (new file)

            ojdbc14.jar

             

            paste the following into the above module.xml:

             

            <module xmlns="urn:jboss:module:1.0" name="com.oracle.jdbc.1_4">

              <resources>

                <resource-root path="ojdbc14.jar"/>

              </resources>

              <dependencies>

                <module name="javax.api"/>

              </dependencies>

            </module>

             

            3) reference the above module from your app (META-INF/MANIFEST.MF), eg:

            "Dependencies: com.oracle.jdbc.1_4"


            good luck!

            • 18. Re: Oracle datasource - missing/unsatisfied dependencies
              bpmm

              Hello,

               

              I have the same defect when I have started my server in order to deploy EJB.jar

               

              You can see the content at this link: https://community.jboss.org/thread/205936

               

              Thanks for your help.

               

              Best regards,

              Brice

              1 2 Previous Next