Guest User

Untitled

a guest
Jan 19th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  1. public static String getJdbcName() {
  2. if (jdbcName == null) {
  3. ConfigLoader oConfigLoader = ConfigLoader.getInstance();
  4. setJdbcName(oConfigLoader.getProperty("general.jndi"));
  5. logger.info("jdbcName:"+jdbcName);
  6. }
  7. return jdbcName;
  8. }
  9.  
  10. java:comp/env/jdbc/settmdr
  11.  
  12. public DataSource getDataSource( ) throws Exception {
  13. if (ds == null) {
  14. try{
  15. Context iniCtx = new InitialContext();
  16. iniCtx.lookup("java:comp/env");
  17. getJdbcName();
  18. ds = ( DataSource )iniCtx.lookup(jdbcName);
  19. logger.info(" Se obtiene el dataSource ...");
  20. }catch( NamingException e ){
  21. e.printStackTrace();
  22. }
  23. }
  24. return ds;
  25. }
  26.  
  27. <GlobalNamingResources>
  28. <!-- Editable user database that can also be used by
  29. UserDatabaseRealm to authenticate users
  30. -->
  31. <Resource auth="Container" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" name="UserDatabase" pathname="conf/tomcat-users.xml" type="org.apache.catalina.UserDatabase"/>
  32.  
  33. <Resource
  34. global="jdbc/Tomcat"
  35. name="jdbc/Tomcat"
  36. auth="Container"
  37. type="javax.sql.DataSource"
  38. factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
  39. initialSize="10"
  40. minIdle="5"
  41. maxIdle="25"
  42. maxWait="15000"
  43. maxActive="350"
  44. testWhileIdle="true"
  45. testOnReturn="false"
  46. validationQuery="SELECT 1 FROM DUAL"
  47. validationInterval="30000"
  48. timeBetweenEvictionRunsMillis="30000"
  49. minEvictableIdleTimeMillis="30000"
  50. password="pgt_mex"
  51. username="pgt_mex"
  52. driverClassName="oracle.jdbc.driver.OracleDriver"
  53. url="jdbc:oracle:thin:@ 180.181.37.37:1651:mexmdrt
  54. "
  55. />
  56.  
  57.  
  58. </GlobalNamingResources>
  59.  
  60. <ResourceLink global="jdbc/Tomcat" name="jdbc/Tomcat" type="javax.sql.DataSource"/>
  61.  
  62. <context-param>
  63. <param-name>jdbcPool</param-name>
  64. <param-value>jdbc/Tomcat</param-value>
  65. </context-param>
  66.  
  67. <resource-ref>
  68. <description>Oracle Datasource eRiskMan</description>
  69. <res-ref-name>jdbc/Tomcat</res-ref-name>
  70. <res-type>javax.sql.DataSource</res-type>
  71. <res-auth>Container</res-auth>
  72. <res-sharing-scope>Shareable</res-sharing-scope>
  73. </resource-ref>
Add Comment
Please, Sign In to add comment