code_junkie

using DBMS_APPLICATION_INFO with Jboss

Nov 10th, 2011
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. <local-tx-datasource>
  2. <jndi-name>jdbc/myDS</jndi-name>
  3. <connection-url>jdbc:oracle:thin:@10.10.1.15:1521:SID</connection-url>
  4. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  5. <security-domain>MyEncryptDBPassword</security-domain>
  6. <valid-connection-checker-class-name>test.MyValidConn</valid-connection-checker-class-name>
  7. <metadata>
  8. <type-mapping>Oracle9i</type-mapping>
  9. </metadata>
  10. </local-tx-datasource>
  11.  
  12. <local-tx-datasource>
  13. <jndi-name>jdbc/myDS</jndi-name>
  14. <connection-url>jdbc:oracle:thin:@10.10.1.15:1521:SID</connection-url>
  15. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  16. <security-domain>MyEncryptDBPassword</security-domain>
  17. <valid-connection-checker-class-name>test.MyValidConn</valid-connection-checker-class-name>
  18. <metadata>
  19. <type-mapping>Oracle9i</type-mapping>
  20. </metadata>
  21. </local-tx-datasource>
  22.  
  23. <local-tx-datasource>
  24. <jndi-name>jdbc/myDS</jndi-name>
  25. <connection-url>jdbc:oracle:thin:@10.10.1.15:1521:SID</connection-url>
  26. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  27. <security-domain>MyEncryptDBPassword</security-domain>
  28. <valid-connection-checker-class-name>test.MyValidConn</valid-connection-checker-class-name>
  29. <metadata>
  30. <type-mapping>Oracle9i</type-mapping>
  31. </metadata>
  32. </local-tx-datasource>
  33.  
  34. <local-tx-datasource>
  35. <jndi-name>jdbc/myDS</jndi-name>
  36. <connection-url>jdbc:oracle:thin:@10.10.1.15:1521:SID</connection-url>
  37. <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  38. <security-domain>MyEncryptDBPassword</security-domain>
  39. <valid-connection-checker-class-name>test.MyValidConn</valid-connection-checker-class-name>
  40. <metadata>
  41. <type-mapping>Oracle9i</type-mapping>
  42. </metadata>
  43. </local-tx-datasource>
  44.  
  45. <dependency>
  46. <groupId>jboss</groupId>
  47. <artifactId>jboss-common-jdbc-wrapper</artifactId>
  48. <version>3.2.3</version>
  49. <scope>provided</scope>
  50. </dependency>
  51.  
  52. public SQLException isValidConnection(Connection arg0) {
  53. CallableStatement statement;
  54. try {
  55. statement = arg0.prepareCall("call dbms_application_info.set_client_info('"+getInfos()+"')");
  56. statement.execute();
  57. } catch (SQLException e) {
  58. // TODO Auto-generated catch block
  59. e.printStackTrace();
  60. }
  61. return null;
  62. }
Add Comment
Please, Sign In to add comment