how to add oracle datasource in JBossEAP6.1
sri.is03 Oct 23, 2013 3:15 AMHi All,
I tried to add a datasource for oracle db in Jboss EAP6.1. But I am getting below error and seeing error while 'Testing a db connection in server'.
Pls let me know if I have missed something.
Step 1-> Added below datasource in standalone.xml file
Step 2-> Created a module.xml file and placed under \modules folder as com\oracle
Here is my module.xml file
<module xmlns="urn:jboss:module:1.1" name="com.oracle">
<resources>
<resource-root path="ojdbc14.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Step 3-> Copied a ojdbc14.jar file in the com\oracle location.
Step 4-> Started the server by standalone.bat file
---------------------------------------
<datasource jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:abc</connection-url>
<driver>oracle</driver>
<security>
<user-name>username</user-name>
<password>password</password>
</security>
</datasource>
<drivers>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.driver.OracleDriver</xa-datasource-class>
</driver>
</drivers>
</datasources>
---------------------------------------
Error on console:
-----------------------------------
JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.oracle (missing) dependents: [service jboss.driver-demander.java:jboss/datasources/OracleDS, service jboss.data-source.java:jboss/datasources/Oracle
DS]
---------------------------------
Below the error seen when we click on 'Test the DB Connection' in server under 'DataSource' link.
Internal Server Error
{
"outcome" => "failed",
"failure-description" => "JBAS010440: failed to invoke operation: JBAS010442: failed to match pool. Check JndiName: java:jboss/datasources/OracleDS",
"rolled-back" => true
}
Thanks in advance.