jbuilder2005 与 tomcat5 连接池的问题,
zzzpt 2005-01-27 09:03:35
1、通过Http://localhost:8080/admin进入,修改DataSource项,
2、修改Tomcat 5.0\conf\Catalina\localhost\myapp.xml文件加入ResourceLink,
问题是,我每次运行我的myapp项目的时候,上面第2步中的ResourceLink都自动没有了,结果出现错误如下:Name jdbc is not bound in this Context
或者修改myapp的web.xml文件加入如下
<resource-ref>
<description>Oracle DataSource example</description>
<res-ref-name>jdbc/oracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
则显示这样的错误:
Cannot create JDBC driver of class '' for connect URL 'null',我想这应该是没有找到对jdbc/oracle的驱动的声明,可不知这样做要怎么样声明呢?
附件
****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 value="30" type="java.lang.Integer" name="simpleValue"/>
<Resource type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved" auth="Container" name="UserDatabase"/>
<Resource type="javax.sql.DataSource" name="jdbc/oracle"/>
<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/oracle">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>pmiswh</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@10.161.160.10:1521:lydyj</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>pmis</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name="Catalina">
<Connector connectionTimeout="20000" port="8080" redirectPort="8443" disableUploadTimeout="true" acceptCount="100" maxThreads="150" minSpareThreads="25" maxSpareThreads="75">
</Connector>
<Connector port="8009" redirectPort="8443" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" protocol="AJP/1.3">
</Connector>
<Engine defaultHost="localhost" name="Catalina">
<Host appBase="webapps" name="localhost">
<Logger className="org.apache.catalina.logger.FileLogger" suffix=".txt" prefix="localhost_log." timestamp="true"/>
</Host>
<Logger className="org.apache.catalina.logger.FileLogger" suffix=".txt" prefix="catalina_log." timestamp="true"/>
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
</Engine>
</Service>
</Server>
****myapp.xml
<?xml version='1.0' encoding='utf-8'?>
<Context workDir="D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\work\WebModule1" path="/WebModule1" docBase="D:\Documents and Settings\zpt\jbproject\untitled3\WebModule1" reloadable="true">
<ResourceLink global="jdbc/oracle" name="jdbc/oracle" type="javax.sql.DataSource"/>
</Context>