3 Replies Latest reply on Dec 18, 2013 3:27 PM by John Parks

    Upgrade to JBoss 7 Datasource is Not Working

    John Parks Newbie

      I am trying to upgrade to JBoss 7; however, my datasource is not creating a connection. I did not deploy any WAR files. I am testing the connection by using the admin console. In standalone.xml, I configured the datasource as follows:

       

       

        <subsystem xmlns="urn:jboss:domain:datasources:1.0">

        <datasources>

        <datasource jta="false" jndi-name="java:jboss/projectDS" pool-name="projectDS" enabled="true">

        <connection-url>jdbc:oracle:thin:@mcc-67-150.usae.ABC.com:1521:test</connection-url>

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

        <driver>ojdbc6</driver>

        <security>

        <user-name>ABC</user-name>

        <password>ABC</password>

        </security>

        </datasource>

        <drivers>

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

        </drivers>

        </datasources>

        </subsystem>

       

       

      The ojdbc6.jar driver is in the following folder %JBOSS_HOME%\modules\com\oracle\main. The entry in my module.xml reads as follows:

       

       

          <?xml version="1.0" encoding="UTF-8"?>

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

              <resources>

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

              </resources>

              <dependencies>

                   <module name="javax.api"/>

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

              </dependencies>

          </module>

       

       

      The error that I receive in my server log when I test the connection from the admin console is:

       

       

          07:47:11,863 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]

          (HttpManagementService-threads - 4) IJ000604: Throwable while attempting to get

          a new connection: null: javax.resource.ResourceException: Could not create conne

          ction

                  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLo

          calManagedConnection(LocalManagedConnectionFactory.java:277) [ironjacamar-jdbc-1

          .0.9.Final.jar:1.0.9.Final]

       

       

      Thanks in advance!