Advertisement
Guest User

Untitled

a guest
Jan 19th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.51 KB | None | 0 0
  1. Testing with 5.1.38 ( mysql-connector-java-5.1.38-bin.jar 5.1.38 )
  2.  
  3. ~log in to admin~
  4. $./bin/jboss-cli.sh --connect
  5.  
  6. ~before you start, take a snapshot of the configuration :~
  7. ~snapshot is saved in -> /wildfly/standalone/configuration/standalone_xml_history/snapshot~
  8.  
  9. [domain@localhost:9999 /] :take-snapshot()
  10.  
  11. ~mysql-connector-java-5.1.38 ~
  12. [domain@localhost:9999 /] )
  13. deploy ~/<location-directory>/mysql-connector-java-5.1.38-bin.jar
  14.  
  15. ~remove your old connection, ex NaturDS ~
  16. [domain@localhost:9999 /] data-source --name=NaturDS disable
  17. [domain@localhost:9999 /] /:reload
  18. [domain@localhost:9999 /] data-source --name=NaturDS remove
  19.  
  20. ~Add the new connection, ex NaturDS ~
  21. [domain@localhost:9999 /] data-source add --name=NaturDS --jndi-name=java:/NaturDS --driver-name=mysql-connector-java-5.1.38-bin.jar_com.mysql.jdbc.Driver_5_1 --connection-url=jdbc:mysql://localhost:3306/taxonpages_v2 \
  22. --user-name=root --password=boho \
  23. --check-valid-connection-sql="SELECT 1" \
  24. --background-validation=true \
  25. --background-validation-millis=60000 \
  26. --flush-strategy=IdleConnections \
  27. --min-pool-size=10 --max-pool-size=50 --pool-prefill=false
  28.  
  29. The out put is in standalone.xml ( cat standalone.xml)
  30. <datasource jndi-name="java:/NaturDS" pool-name="NaturDS" enabled="true">
  31. <connection-url>jdbc:mysql://localhost:3306/taxonpages_v2</connection-url>
  32. <driver>mysql-connector-java-5.1.38-bin.jar_com.mysql.jdbc.Driver_5_1</driver>
  33. <pool>
  34. <min-pool-size>10</min-pool-size>
  35. <max-pool-size>50</max-pool-size>
  36. <prefill>false</prefill>
  37. <flush-strategy>IdleConnections</flush-strategy>
  38. </pool>
  39. <security>
  40. <user-name>root</user-name>
  41. <password>boho</password>
  42. </security>
  43. <validation>
  44. <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
  45. <background-validation>true</background-validation>
  46. <background-validation-millis>60000</background-validation-millis>
  47. </validation>
  48. </datasource>
  49.  
  50.  
  51. check Information:
  52. 5) /subsystem=datasources/data-source=NaturDS:read-resource(include-runtime=true,recursive=true)
  53.  
  54. ping your data-source
  55. 6) /subsystem=datasources/data-source=NaturDS:test-connection-in-pool
  56.  
  57. 7) data-source flush-all-connection-in-pool --name=NaturDS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement