日期:2014-05-16  浏览次数:20524 次

resin jndi数据库连接池配置
web.xml文件

<database jndi-name='jdbc/qmangopmsdb'>
  <driver type="com.microsoft.sqlserver.jdbc.SQLServerDriver">
    <url>jdbc:sqlserver://localhost:1433;database=pms;</url>
    <user>pmsuser1</user>
    <password>123456</password>
  </driver>
           <prepared-statement-cache-size>8</prepared-statement-cache-size> 
           <max-connections>10</max-connections> 
           <max-idle-time>20s</max-idle-time> 
</database>



conf.properties
driver.sqlserver=net.sourceforge.jtds.jdbc.Driver
dbjndi.read.default=java:comp/env/jdbc/pmsdb
dbjndi.write.default=java:comp/env/jdbc/pmsdb

包:sqljdbc.jar
部分代码
public int openConn(String dbName) {
        try {
            String jndiName = appconf.get(dbName);
            DataSource ds = (DataSource) cachtable.get(jndiName);
            if (ds == null) {
                Context ctx = new InitialContext();
                ds = (DataSource) ctx.lookup(jndiName);
                cachtable.put(jndiName, ds);
            }
            conc = ds.getConnection();
            return 0;
        } catch (Exception e) {
            e.printStackTrace();
            return -1;
        }
    }


resin3.0和resin4.0都测试成功