tomcat 全局 数据源 配置

在tomcat上配置全局数据源

1.找到
\apache-tomcat-7.0.37\conf\context.xml

2.在<Context>……</Context>标签中加入

     <!-- oracle  -->
     <Resource name="jdbc/db" 
		auth="Container" 
		type="javax.sql.DataSource"
		maxActive="100" maxIdle="30" maxWait="10000"
		username="iewss" password="iewss" 
		driverClassName="oracle.jdbc.driver.OracleDriver"
		url="jdbc:oracle:thin:@192.168.10.62:1521:orcl" />
	
      <!-- sqlserver  -->	
	<Resource name="jdbc/db" 
		auth="Container" 
		type="javax.sql.DataSource"
		maxActive="100" maxIdle="30" maxWait="10000"
		username="sa" password="@emcs"                                 driverClassName="net.sourceforge.jtds.jdbc.Driver"
		url="jdbc:jtds:sqlserver://192.168.10.61:1433;DatabaseName=cads" /> 
	
        <!-- mysql  -->
	<Resource name="jdbc/mysql" 
		auth="Container" 
		type="javax.sql.DataSource"
		maxActive="100" maxIdle="30" maxWait="10000"
		username="root" password="123456" driverClassName="com.mysql.jdbc.Driver"
		url="jdbc:mysql://192.168.10.207:3306/callcenter" /> 

3.在java代码中获取数据源，请注意数据源配置在tomcat和配置在resin或者jboss中的差别

  
   1>.tomcat

     Context initCtx = new InitialContext();
    //Context envContext  = (Context)initCtx.lookup("java:/comp/env");
    DataSource ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/db");

   2>.resin、jboss

    Context initCtx = new InitialContext();
    DataSource ds = (DataSource) initCtx.lookup("java:/jdbc/db");

    Connection con = ds.getConnection();