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
