java代码获取数据源_tomcat中获取不同的数据源java代码

tomcat中获取不同的数据源java代码

2014/5/5 18:46:20  haoyuan2012  程序员俱乐部  我要评论(0)

摘要：LOG.debug("数据文件存入IC_CARD_POOL过程开始.................");StringproductNo=(String)ctx.getAttribute("product_no");longmillis0=System.currentTimeMillis();IntegerbatchNo=Integer.valueOf(Integer.parseInt(ctx.getJobNo()));StringjobDate=(String)ctx

LOG.debug("数据文件存入IC_CARD_POOL过程开始.................");

String productNo = (String)ctx.getAttribute("product_no");

long millis0 = System.currentTimeMillis();

Integer batchNo = Integer.valueOf(Integer.parseInt(ctx.getJobNo()));

String jobDate = (String)ctx.getAttribute("job_date");

String companyNo = (String)ctx.getAttribute("companyNo");

Connection connections = null;

DataSource datasource = null;

try

{

InitialContext namingContexts = new InitialContext();

datasource = (DataSource)namingContexts.lookup("IC_DATASOURCE");

} catch (NamingException e1) {

e1.printStackTrace();

}

try {

connections = datasource.getConnection();

DateFormat f = new SimpleDateFormat("yyyyMMdd");

其中IC_DATASOURCE在tomcat/conf中的context.xml中配置

如下所示：

name="IC_DATASOURCE"

type="javax.sql.DataSource"

impl="org.apache.commons.dbcp.BasicDataSource"

driverClassName="oracle.jdbc.driver.OracleDriver"

url="jdbc:oracle:thin:@10.225.8.142:1521:iccard"

username="tsmbat"

password="tsmbat"

maxIdle="200"

maxWait="5000"

maxActive="50"

testOnReturn="true"

testWhileIdle="true"

testOnBorrow="true"

validationQuery="SELECT COUNT(*) FROM DUAL"/>