server.xml里面是加
<Context path="/quickstart" docBase="quickstart">
<Resource name="jdbc/quickstart" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/quickstart">
<parameter>
<name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>SYSMAN</value>
</parameter>
<parameter>
<name>password</name>
<value>pass</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
</ResourceParams>
</Context>
吧,加在</host>的上面就可以了,你需要把上面的配置该成你自己的
<Context path="/quickstart" docBase="quickstart">
<Resource name="jdbc/quickstart" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/quickstart">
<parameter>
<name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>SYSMAN</value>
</parameter>
<parameter>
<name>password</name>
<value>pass</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
</ResourceParams>
</Context>
吧,加在</host>的上面就可以了,你需要把上面的配置该成你自己的
解决方案 »
- 怎么根据条件输出一个表格显示在页面上
- 问个“小白问题”,请大虾指教???
- 关于Hibernate ehcache二级缓存的问题(有点难度), 请帮忙, 谢谢!
- 表设计时的困惑,高手请进
- 要做一个关联下拉框
- 在下载一些软件时,经常看到GPL,GPL是什么意思?
- 请教,关于jdom的问题
- 高手来拿分,关于session监听,并插入数据库的问题
- tomcat下,客户端ie6升级到sp1出现session过期的错误……
- 请教:Servlet参数传递时老出错是怎么回事?
- struts的基础配置问题,急,调了两天了......
- ****eclipse3.0+tomcat 5.0的配置问题,谢谢^_^****
我用tomcat5.0.24,已经正常使用了,但是昨天我换成tomcat5.5.7以后,也是出现和
楼主一样的错误提示!郁闷
楼主搞好了,别忘了通知我一声!谢谢。
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
debug="0"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
debug="0"/><!-- Global JNDI resources -->
<GlobalNamingResources>
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<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></GlobalNamingResources><Service name="Catalina">
<Connector
port="8080" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
debug="0" connectionTimeout="20000"
disableUploadTimeout="true" />
<Connector port="8009"
enableLookups="false" redirectPort="8443" debug="0"
protocol="AJP/1.3" /><Engine name="Catalina" defaultHost="localhost" debug="0">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
debug="0" resourceName="UserDatabase"/>
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log." suffix=".txt"
timestamp="true"/><!-- Define properties for each web application. This is only needed
if you want to set non-default properties, or have web application
document roots in places other than the virtual host's appBase
directory. --><!-- Tomcat Root Context -->
<!--
<Context path="" docBase="ROOT" debug="0">
--><Context path="/SISSECWeb" docBase="SISSECWeb"
debug="5" reloadable="true" crossContext="true"><Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/SISSECDS" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SISSECDS">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>SISSEC</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:SISSEC/[email protected]:1521:ORALINUX</valu e>
</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>SISSEC</value>
</parameter>
</ResourceParams>
</Context>
</Host></Engine></Service></Server>Best regards
<ResourceLink name="jdbc/MyappDB" global="jdbc/MyappDB" type="javax.sql.DataSource"/>
</Context>
具体说说。
在context.xml的<context>下加
<Resource name="jdbc/connectDB"
auth="Container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"
factory="com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory"
scope="Shareable"
user="sa"
password="sa"
serverName="127.0.0.1"
driverClassName="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"
url="jdbc:microsoft:sqlserver//127.0.0.1:1433;DatabaseName=Northwind;user=sa;password=sa;selectMethod=cursor"/>
maxActive="15"
maxIdle="3"
maxWait="-1"
removeAbandoned="true"
logAbandoned="true"
removeAbandonedTimeout="300" />
但是还报错:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]对象名 'orders' 无效
Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'jdbc:microsoft:sqlserver//OEM-MICRO:1433;DatabaseName=pubs;user=sa;password=sa'
仔细将文章中的几个步骤做全,一般就不会有什么问题了。