|
|
Recommended: Sing it, brah! 5 fabulous songs for developers
JW's Top 5
Featured White Papers
- Measuring Risk to Improve Java Software Quality
- 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
Sponsored Links
-
Graph databases are 1000x faster than relational.
Learn More!
-
Career opportunities at Harman- Careers That'll Rock Your Socks Off.
Learn More!
-
Developer-friendly Java PDF libraries by Qoppa Software
Live Demos
-
Stop blaming your app! Diagnose Java performance issues.
Free tool >
-
UrbanCode: Go From Continuous Integration to
Continuous DeliveryLearn More!
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.
About Us | Advertise | Contact Us | Terms of Service/Privacy | AdChoices
Copyright, 2006-2013 Infoworld, Inc. All rights reserved.