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

来源：互联网发布：软件功能说明书编辑：程序博客网时间：2024/05/18 00:50

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

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

   <Resource name="jdbc/oracleds" auth="Container" type="javax.sql.DataSource"        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 配置

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://java.sun.com/xml/ns/javaee"         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">    <resource-ref>        <res-ref-name>jdbc/oracle</res-ref-name>        <res-type>javax.sql.DataSource</res-type>        <res-auth>Container</res-auth>    </resource-ref>    <servlet>        <servlet-name>TomcatServlet</servlet-name>        <servlet-class>com.lw.Servlet</servlet-class>    </servlet>    <servlet-mapping>        <servlet-name>TomcatServlet</servlet-name>        <url-pattern>/TomcatServlet</url-pattern>    </servlet-mapping>        <welcome-file-list>        <welcome-file>Hello.jsp</welcome-file>    </welcome-file-list></web-app>

启动 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

0 0