Guest User

Untitled

a guest
Jul 3rd, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. Vinaya,
  2.  
  3. In order to install that version of the Oracle Database Driver you will have to do a few things first:
  4.  
  5. Stop Jboss and remove the jar file that you placed in JBOSS_HOME/standalone/deployments
  6.  
  7. Next,
  8.  
  9. In JBOSS_HOME/modules
  10. Run: mkdir –p com/oracle/ojbc14/main
  11. In that location edit this new file
  12. vi module.xml
  13. In there will be the information for the driver deployment
  14.  
  15. <module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc14">
  16. <resources>
  17. <resource-root path="ojdbc14.jar"/>
  18. </resources>
  19. <dependencies>
  20. <module name="javax.api"/>
  21. </dependencies>
  22. </module>
  23.  
  24. Add this next section to to “drivers section” of standalone.xml as this driver in not jdbc4 compliant.
  25.  
  26. <driver name="oracleDriver" module="com.oracle.ojdbc14">
  27. <driver-class>oracle.jdbc.OracleDriver</driver-class>
  28. <xa-datasource-class>
  29. oracle.jdbc.xa.client.OracleXADataSource
  30. </xa-datasource-class>
  31. </driver>
  32.  
  33. Copy your driver ojdbc14.jar to $JBOSS_HOME/modules/com/oracle/ojdbc6/main
  34.  
  35. Now create your driver definition in the standalone.xml file
  36. vi $JBOSS_HOME/standalone/configuration/standalone.xml
  37.  
  38. Look for the following text:
  39.  
  40. subsystem xmlns="urn:jboss:domain:datasources:1.0">
  41.  
  42. In that subsystem add this snippet:
  43.  
  44. <driver name="oracle" module="com.oracle.ojdbc14">
  45. <xa-datasource-class>
  46. oracle.jdbc.OracleDriver
  47. </xa-datasource-class>
  48. </driver>
  49.  
  50. And last, create your data source configuration. Put this next snippet below the <datasources> element. Modify this data as necessary for your configuration
  51.  
  52. <datasource jndi-name="WorkCenterDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
  53. <connection-url>jdbc:oracle:thin:@localhost:1521:oradb1</connection-url>
  54. <driver>oracle</driver>
  55. <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
  56. <pool>
  57. <prefill>true</prefill>
  58. <use-strict-min>false</use-strict-min>
  59. <flush-strategy>FailingConnectionOnly</flush-strategy>
  60. </pool>
  61. <security>
  62. <user-name>user1</user-name>
  63. <password>1234</password>
  64. </security>
  65. </datasource>
Add Comment
Please, Sign In to add comment