0 Replies Latest reply on Aug 1, 2014 6:13 AM by Robert Somebody

    deployable data sources in JBOSS 7.1.1 (deployment of driver and datasource)

    Robert Somebody Newbie

      Hi,

       

      I'm having problems deploying a datasource along with the jdbc driver in a war (OracleDriver). I'm running a standalone server.

       

      This posting suggests that this is possible:

       

      http://www.mastertheboss.com/jboss-datasource/jboss-as-7-deployable-datasources

       

      Is this correct?

       

      I've got the ojdb6.jar in the WEB-INF/lib folder and I've got a mysource-ds.xml file in WEB-INF.

       

      The deployment of the JDBC driver seems to fail with:

       

      1:42:10,497 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3) JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)

      11:42:10,497 DEBUG [org.jboss.as.security] (MSC service thread 1-3) Cannot create permissions with 'null' metaData for id=frigg.war

       

      This seems to be a JACC security issue? I havn't figured out how to supply the needed metaData.

       

      The deployment of the war fails with:

       

      "JBAS014771: Services with missing/unavailable dependencies" => ["jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jarMissing[jboss.data-source.jboss/datasources/jdbc/FriggDbjboss.jdbc-driver.ojdbc6_jar]"]}

       

      I'm not seeing that the -ds.xml file is being processed in the logs...if I add an invalid tag, I get a parse exception, so I guess it is being processed.

       

      here is my -ds.xml file:

       

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

      <datasources xmlns="http://www.jboss.org/ironjacamar/schema">

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

              <connection-url>jdbc:oracle:thin:@192.168.5.55:1521:xe</connection-url>

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

              <driver>ojdbc6.jar</driver>

              <pool>

                  <max-pool-size>30</max-pool-size>

              </pool>

              <security>

                  <user-name>foo</user-name>

                  <password>bar</password>

              </security>

          </datasource>

      </datasources>

       

      If the deployment succeeds what driver name is it given?

       

      Thanks!

       

      -Robert