配置连接池连接oracle,数据库连接池配置-Oracle实测

TomCat 6.0 实测配置连接，其它数据库同理配置(WebLogic 后续实测)

Tomcat /conf/Context.xml 下配置连接信息。

maxActive="100" maxIdle="30" maxWait="10000" username="jgbs" password="jgbs"

driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@81.17.1.17:1521:ljjgbs"/>

lib 目录下加入 oracle 驱动 jar包

web 项目中web.xml 配置

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

version="2.5">

jdbc/oracle

javax.sql.DataSource

Container

TomcatServlet

com.lw.Servlet

TomcatServlet

/TomcatServlet

Hello.jsp

启动 tomcat  ，在测试的servlet 中执行下列代码

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp)throws IOException{

String connMessage = "";

try {

Context context = new InitialContext();

DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/oracleds"); //jdbc/oracleds was defined in context.xml, must be same

Connection conn = ds.getConnection();

connMessage=conn.toString();

conn.close();

} catch (NamingException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

resp.getWriter().write(connMessage);

}

页面 返回

jdbc:oracle:thin:@81.17.1.17:1521:ljjgbs, UserName=JGBS, Oracle JDBC driver