tomcat server.xml 连接池设置

<Context path="/test" docBase="E:/WorkDir/WorkSpace/TestWeb" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>500</value>
</parameter>
<parameter>
<name>username</name>
<value>inet_pm</value>
</parameter>
<parameter>
<name>password</name>
<value>inet_pm</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
<!--<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>-->
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:UNMS</value>
<!--<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=KB_Rate</value>-->
</parameter>
</ResourceParams>
  </Context>

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

代码测试：

Context ctx=new InitialContext();
            DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
            Connection conn=ds.getConnection();
            dMsg.info("###have got a connection:"+conn);
            //SimpleDateFormat format1 = new SimpleDateFormat(formatPatterndb);
            SimpleDateFormat format2 = new SimpleDateFormat(formatPattern);
            String sql="select * from wgsmr_pm_file";
            PreparedStatement ps=conn.prepareStatement(sql);
            ResultSet rs=ps.executeQuery();
            dMsg.info("###task-"+id+" have executed a db operation");
//            ResultSetMetaData rsmd = ps.getMetaData();
//            int clmnCount = rsmd.getColumnCount();
//            String[] dataType = new String[clmnCount];
//            String[] clmnName=new String[clmnCount];
//            for (int i = 0; i < clmnCount; i++)
//            {
//                dataType[i] = rsmd.getColumnTypeName(i + 1);
//                clmnName[i]=rsmd.getColumnName(i+1);
//            }   
//            while(rs.next()){
//                StringBuffer rcd=new StringBuffer();
//                for (int i = 0; i < clmnCount; i++)
//                {
//                    if (dataType[i].equals("VARCHAR2"))
//                    {
//                        rcd.append(rs.getString(i + 1));
//                        continue;
//                    }
//                    if (dataType[i].equals("DATE"))
//                    {
//                        String dd = rs.getString(i + 1);
//                        rcd.append( dd/*format2.format(format2.parse(dd))*/);
                        try
                        {
                            rcd.append( dd/*format2.format(format2.parse(dd))*/);
                        }
                        catch (ParseException e)
                        {
                            dMsg.error(e);
                            break;
                        }
//                        continue;
//                    }
//                    rcd.append( rs.getString(i + 1));
//                }
//                dMsg.info(rcd);
//            }
            rs.close();
            ps.close();
            conn.close();