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"/>