你的datasource配置如何呢?
包括配置的Context 下面是jakarta提供的例子。用mm driver也没问题,试过n遍了<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/> <Resource name="jdbc/TestDB"
auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter> <!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter> <!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter> <!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter> <!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>javauser</value>
</parameter>
<parameter>
<name>password</name>
<value>javadude</value>
</parameter> <!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter> <!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
包括配置的Context 下面是jakarta提供的例子。用mm driver也没问题,试过n遍了<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/> <Resource name="jdbc/TestDB"
auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter> <!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter> <!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter> <!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter> <!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>javauser</value>
</parameter>
<parameter>
<name>password</name>
<value>javadude</value>
</parameter> <!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter> <!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
解决方案 »
- 网站似乎被黑
- dom4j解析xml时,出现的问题
- 请教一个数据库查询问题,路过的请看看
- 大家能不能解释下面这段程序的功能呀,谢谢!
- jsp下的:java.lang.NullPointerException问题!
- java 怎么能够得到英文字符串和汉字串中首写字符或汉字的拼音码 例如汉字“陈”拼音码是"c" 字符“c”或“C”的拼音码都是小写"c"
- 恢复被tomcat Undeploy 的项目,在线等,急!急!急!
- 我在java里面调用存储过程成功啊!但是我不知道怎么在存储过程里面写抛出例外
- 用JSP开发WEB应用时,如何开发一个网站的搜索引擎?是用代码实现还是用WEB服务器上index服务来实现(如Microsoft Index Server)?
- 关于tomcat7、tomcat8的一个jsp乱码问题,难道是bug?求释疑
- 运行JSP时不显示JSP中间<%%>里的结果
- 关于<jsp:include>的问题!
Data Source URL: jdbc:mysql://localhost:3306/file
JDBC Driver Class: org.gjt.mm.mysql.Driver
User Name: root
Password:
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
上面这个是我在admin管理页里面配置Data Sources的my\WEB-INF\web.xml中
<resource-ref>
<res-ref-name>
jdbc/MysqlDB
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>