JNDI配置数据源

来源：互联网发布：java权限代码编辑：程序博客网时间：2024/05/16 19:26

一、WebRoot/META-INF/context.xml

<?xml version="1.0" encoding="UTF-8"?><Context>    <Resource name="jdbc/scsis"                 auth="Container"                 type="javax.sql.DataSource"                 driverClassName="oracle.jdbc.driver.OracleDriver"                url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521)) (LOAD_BALANCE = yes)(FAILOVER = on)) (CONNECT_DATA =(SERVICE_NAME = scsis)))"                 username="x"                 password="x"                 maxActive="20" maxIdle="10" maxWait="10000"                removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"                validationQuery="select 1 from dual" testOnBorrow="true" testWhileIdle="true"/>   </Context>

二、web.xml

   <resource-ref>      <description>JNDI DataSource</description>      <res-ref-name>jdbc/scsis</res-ref-name>      <res-type>javax.sql.DataSource</res-type>      <res-auth>Container</res-auth>   </resource-ref>

三、Constants.java

package com.x.util;import java.util.ResourceBundle;public final class Constants {/** Oracle数据源URL. */public static final String JDBC_DATASOURCE_URL;static {ResourceBundle bundle = ResourceBundle.getBundle("config");JDBC_DATASOURCE_URL = bundle.getString("jndi.jdbc.connector");}}

四、config.properties

jndi.jdbc.connector=java:/comp/env/jdbc/scsis

五、Utility.java

package com.x.util;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.regex.Matcher;import java.util.regex.Pattern;import javax.naming.InitialContext;import javax.sql.DataSource;import org.apache.log4j.Logger;public class Utility {private static final Logger log = Logger.getLogger(Utility.class);/** * 获取数据库连接 */public static Connection getConnection() {try {InitialContext initial = new InitialContext();// 使连接池初始化DataSource dataSource = (DataSource) initial.lookup(Constants.JDBC_DATASOURCE_URL);Connection con = dataSource.getConnection();return con;} catch (SQLException exp) {logDBError(exp);return null;} catch (Exception ex) {logError(ex);return null;}}/** * 记录异常 */public static synchronized void logError(Exception exp) {StackTraceElement ste[] = exp.getStackTrace();StringBuffer content = new StringBuffer();content.append("[" + exp.toString() + "]\n");for (int i = 0; i < ste.length; i++) {content.append("  " + ste[i].toString() + "\n");}log.error(content);}/** * 记录数据库异常 */public static synchronized void logDBError(Exception exp) {StackTraceElement ste[] = exp.getStackTrace();StringBuffer content = new StringBuffer();content.append(exp.toString());for (int i = 0; i < ste.length; i++) {content.append("  " + ste[i].toString() + "\n");}log.error(content);}}

0 0