|
|
Featured White Papers
- Why choose an Open Source BPM?
- 10 FAQs on Business Process Management
- Best Practices for Getting Started with BPM
- Free Your Devs From The Pain Of Java Redeploys
- Increase Velocity 40% by Using JRebel
- What Developers Want: The End of Application Redeploys
- Developer Productivity Report: Java Tools, Tech, Devs, and Data
- Coding with JRebel: Java Forever Changed
- Utilizing Fast Testing to Transform Java Development
- Do You Really Get Classloaders?
- Pragmatic Continuous Delivery with Jenkins, Nexus, and LiveRebel
- Your Next Java Web App: Less XML, No Long Restarts, Fewer Hassles
- Coding with JRebel, Java Forever Changed
- 2012 Developer Productivity Report: Java Tools, Tech, Devs, and Data
Setting Oracle Datasource in JBoss AS 7
Submitted by srikanth.s.nair on Thu, 10/20/2011 - 04:06.
Add the following snippet to the newly created module.xml file
Copy the ojdbc6.jar to $JBOSS_HOME/modules/com/oracle/ojdbc6/main [make sure your jar META-INF folder is having a Services dir with a file called java.sql.Driver]
Look for
this is where the datasource and driver configuration will go. Within this subsystem, look for the section and add the following:
Then create the datasource configuration, also in the standalone configuration file. The following block will go just below the
Restart JBoss and look for the following lines in your log file to determine if the deployment succeeded.
Here are step by step directions on how to configure JBoss AS 7 to communicate with Oracle XE.
1. Create directory for the oracle driver deployment
$ cd $JBOSS_HOME/modules
$ mkdir -p com/oracle/ojdbc6/main
$ vi module.xmlAdd the following snippet to the newly created module.xml file
<module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6">
<resources>
<resource-root path="ojdbc6.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>Copy the ojdbc6.jar to $JBOSS_HOME/modules/com/oracle/ojdbc6/main [make sure your jar META-INF folder is having a Services dir with a file called java.sql.Driver]
Next, create the driver definition in the standalone configuration file
$ vi $JBOSS_HOME/standalone/configuration/standalone.xmlLook for
<subsystem xmlns="urn:jboss:domain:datasources:1.0"> this is where the datasource and driver configuration will go. Within this subsystem, look for the section and add the following:
<driver name="oracle" module="com.oracle.ojdbc6">
<xa-datasource-class>
oracle.jdbc.OracleDriver
</xa-datasource-class>
</driver>Then create the datasource configuration, also in the standalone configuration file. The following block will go just below the
<datasources> element.<datasource jndi-name="WorkCenterDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:oradb1</connection-url>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<prefill>true</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>user1</user-name>
<password>1234</password>
</security>
</datasource>Restart JBoss and look for the following lines in your log file to determine if the deployment succeeded.