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