读书人

tomcat 连接池的有关问题

发布时间: 2012-01-19 00:22:28 作者: rapoo

tomcat 连接池的问题
tomcat5.0.28 连接池配置如下:
<?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 name= "jdbc/wyl " 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/wyl ">
<parameter>
<name> validationQuery </name>
<value> select * from orgmodel_userinfo </value>
</parameter>
<parameter>
<name> url </name>
<value> jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=wyl </value>
</parameter>
<parameter>
<name> password </name>
<value> </value>
</parameter>
<parameter>
<name> maxActive </name>
<value> 4 </value>
</parameter>
<parameter>
<name> maxWait </name>
<value> 5000 </value>
</parameter>


<parameter>
<name> driverClassName </name>
<value> com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</parameter>
<parameter>
<name> username </name>
<value> sa </value>
</parameter>
<parameter>
<name> maxIdle </name>
<value> 2 </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 ">
<DefaultContext className= "org.apache.catalina.core.StandardDefaultContext ">
<ResourceLink global= "jdbc/wyl " name= "jdbc/wyl " type= "javax.sql.DataSource "/>
</DefaultContext>
<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>
在程序中调用出现如下异常:Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
在jsp中调用出现如下异常:Name java:comp is not bound in this Context


已经困惑好多天了,请各位高手指教。在线等待!


[解决办法]
帮顶下
[解决办法]
<Resource name= "jdbc/wyl " type= "javax.sql.DataSource "/>
可能和在Java中调用的不一致
[解决办法]
Tomcat 5.0好像需要另外建一个XML文件,放在Tomcat 5.0\conf\Catalina\localhost目录之下,
文件名为你发布的webapps下的目录名字.内容为
<Context path= "/manager " docBase= "你的目录名 ">
<ResourceLink name= "jdbc/wyl " global= "jdbc/wyl "
type= "javax.sql.DataSource "/>

</Context>

读书人网 >Java Web开发

热点推荐