-
15. Re: Oracle datasource - missing/unsatisfied dependencies
tc7 Nov 8, 2011 5:58 PM (in response to salecha.rohit)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 Nov 8, 2011 11:34 PM (in response to iapazmino)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 Nov 8, 2011 11:56 PM (in response to salecha.rohit)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
.jarpaste 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 Sep 28, 2012 9:52 AM (in response to iapazmino)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