tomcat5配置连接池的问题
谁能给我讲下应该注意的问题.
在把配置成功过的 server.xml 文件代码给我帖出来.
小弟太笨了,多谢各位了.
[解决办法]
如果是5.0的话你可以到控制台去配置,如果是5.5的话那中有上网找找了，我用的是5.0所以不知道5.5的怎么配
server.xml
<?xml version= '1.0 ' encoding= 'utf-8 '?>
<Server>
<Listener className= "org.apache.catalina.mbeans.ServerLifecycleListener "/>
<Listener className= "org.apache.catalina.mbeans.GlobalResourcesLifecycleListener "/>
<GlobalNamingResources>
<Environment name= "simpleValue " type= "java.lang.Integer " value= "30 "/>
<Resource auth= "Container " description= "User database that can be updated and saved " name= "UserDatabase " type= "org.apache.catalina.UserDatabase "/>
<Resource auth= "Container " name= "jdbc/liuxue " type= "javax.sql.DataSource "/>
<ResourceParams name= "UserDatabase ">
<parameter>
<name> factory </name>
<value> org.apache.catalina.users.MemoryUserDatabaseFactory </value>
</parameter>
<parameter>
<name> pathname </name>
<value> conf/tomcat-users.xml </value>
</parameter>
</ResourceParams>
<ResourceParams name= "jdbc/liuxue ">
<parameter>
<name> factory </name>
<value> org.apache.commons.dbcp.BasicDataSourceFactory </value>
</parameter>
<parameter>
<name> url </name>
<value> jdbc:mysql://localhost:3306/liuxue?useUnicode=true&characterEncoding=gb2312 </value>
</parameter>
<parameter>
<name> password </name>
<value> a </value>
</parameter>
<parameter>
<name> maxActive </name>
<value> 30 </value>
</parameter>
<parameter>
<name> maxWait </name>
<value> 10000 </value>
</parameter>
<parameter>
<name> driverClassName </name>
<value> com.mysql.jdbc.Driver </value>
</parameter>
<parameter>
<name> username </name>
<value> root </value>
</parameter>
<parameter>
<name> maxIdle </name>
<value> 10 </value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name= "Catalina ">
<Connector acceptCount= "100 " connectionTimeout= "20000 " disableUploadTimeout= "true " port= "8080 " redirectPort= "8443 " maxSpareThreads= "75 " maxThreads= "150 " minSpareThreads= "25 ">
</Connector>
<Connector port= "8009 " protocol= "AJP/1.3 " protocolHandlerClassName= "org.apache.jk.server.JkCoyoteHandler " redirectPort= "8443 ">
</Connector>
<Engine defaultHost= "localhost " name= "Catalina ">
<Host appBase= "webapps " name= "localhost ">
<Logger className= "org.apache.catalina.logger.FileLogger " prefix= "localhost_log. " suffix= ".txt " timestamp= "true "/>
</Host>
<Logger className= "org.apache.catalina.logger.FileLogger " prefix= "catalina_log. " suffix= ".txt " timestamp= "true "/>
<Realm className= "org.apache.catalina.realm.UserDatabaseRealm "/>
</Engine>
</Service>
</Server>
[解决办法]
进http://localhost:9090/admin下配，界面都很清晰的
[解决办法]
</Context>
<Context path= "/Project " reloadable= "true " docBase= "/Project ">
<Resource name= "jdbc/Project " auth= "Container " type= "javax.sql.DataSource "/>
<ResourceParams name= "jdbc/Project ">
<parameter>
<name> factory </name>
<value> org.apache.commons.dbcp.BasicDataSourceFactory </value>
</parameter>
<parameter>
<name> maxActive </name>
<value> 100 </value>
</parameter>
<parameter>
<name> maxIdle </name>
<value> 30 </value>
</parameter>
<parameter>
<name> maxWait </name>
<value> 10000 </value>
</parameter>
<parameter>
<name> username </name>
<value> sa </value>
</parameter>
<parameter>
<name> password </name>
<value> sa </value>
</parameter>
<parameter>
<name> driverClassName </name>
<value> com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</parameter>
<parameter>
<name> url </name>
<value> jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Project;user=sa;password=sa; </value>
</parameter>
</ResourceParams>
</Context>
