Guest User

Untitled

a guest
Dec 5th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.34 KB | None | 0 0
  1. $JBOSS_HOME/server/default/lib
  2.  
  3. $JBOSS_HOME/docs/examples/jca
  4.  
  5. <datasources>
  6. <local-tx-datasource>
  7. <jndi-name>PostgresDS</jndi-name>
  8. <connection-url>jdbc:postgresql://[servername]:[port]/[database name]</connection-url>
  9. <driver-class>org.postgresql.Driver</driver-class>
  10. <user-name>x</user-name>
  11. <password>y</password>
  12. <!-- sql to call when connection is created. Can be anything, select 1 is valid for PostgreSQL
  13. <new-connection-sql>select 1</new-connection-sql>
  14. -->
  15.  
  16. <!-- sql to call on an existing pooled connection when it is obtained from pool. Can be anything, select 1 is valid for PostgreSQL
  17. <check-valid-connection-sql>select 1</check-valid-connection-sql>
  18. -->
  19.  
  20. <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  21. <metadata>
  22. <type-mapping>PostgreSQL 7.2</type-mapping>
  23. </metadata>
  24. </local-tx-datasource>
  25.  
  26. </datasources>
  27.  
  28. Follow the following steps:
  29. taking mysql as database
  30.  
  31. 1. Add my sql connector jar in main folder.
  32. eg.(modulessystemlayersbasecommysqlmain).
  33. 2. Add module.xml to this folder consist of following config:
  34.  
  35. <?xml version="1.0" encoding="UTF-8"?>
  36.  
  37. <module xmlns="urn:jboss:module:1.0" name="com.mysql">
  38. <resources>
  39. <resource-root path="mysql-connector-java-5.1.17-bin.jar"/>
  40. </resources>
  41.  
  42. <dependencies>
  43. <module name="javax.api"/>
  44. <module name="javax.transaction.api"/>
  45. <module name="javax.servlet.api" optional="true"/>
  46. </dependencies>
  47. </module>
  48.  
  49. 3. Now in stanalone.xml file add mysql driver under drivers tag as following:
  50.  
  51.  
  52. <driver name="mysql" module="com.mysql">
  53. <driver-class>com.mysql.jdbc.Driver</driver-class>
  54. </driver>
  55.  
  56. 4. start the jboss server from command prompt
  57. In cmd go to location of jboss/bin folder and execute standalone.bat
  58.  
  59. 5. Now in browser open localhost:8080.
  60. click on administration console under create a datasource click datasource
  61. then click on add.
  62. Add following details:
  63. Name: MysqlDS5
  64. JNDI Name : java:/mysql
  65. click next
  66. under detected driver select mysql.
  67. click next
  68. Connection url : jdbc:mysql://localhost:3306/sampledb
  69. UserName:****
  70. Password:****
  71. click done.
  72. select the MysqlDS and click on enable.
  73. click on test connection it will successfully connected.
Add Comment
Please, Sign In to add comment