如何配置数据源?
我用的是tomcat5.0 Mysql4.0
我用的是tomcat5.0 Mysql4.0
解决方案 »
- 面试题 简述基于SSH1框架Web应用的工作流程
- js读取txt
- Struts2怎么配置
- 关于权限,你们是怎么设计的,我的是这样,但有问题
- 如何配置struts2+spring2.5.5+hibernate3.3.1+proxool+log4j+JPA?高手进
- 图片显示问题 请高手指点啊!!!
- 关于Bean初始化的问题
- 小问题
- 如何把数据库中取得的日期与现在日期比较?急!!
- 使用XMLSerializer XML转json发现一个问题,需要后台处理!!!请教大神
- 跪求,各位帮忙解决JSP出错问题,100分相送!提出解决大大给分!
- 请问request和session之间的区别,我有些糊涂了,谢谢
CATALINA_BASE d:\tomcat //你的tomcat的路径
CATALINA_HOME d:\tomcat //你的tomcat的路径
TOMCAT_HOME d:\tomcat //你的tomcat的路径
配置一下ODBC就可以了
配置文件是Tomcat 5.0\conf\Catalina\localhost\audio.xml
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/audio" docBase="${catalina.home}/webapps/audio"
reloadable="true" debug="0">
<Resource name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"/> <ResourceParams name="jdbc/mysql">
<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 -1 for no limit. See also the DBCP documentation on this
and the minEvictableIdleTimeMillis configuration parameter.
-->
<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>root</value>
</parameter>
<parameter>
<name>password</name>
<value>rackerock</value>
</parameter> <!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
if you want to use this driver - we recommend using Connector/J though
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
-->
<!-- Class name for the official MySQL Connector/J 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/audio</value>
</parameter>
</ResourceParams></Context>
如何用呢
java.lang.ClassCastException
不过还是有几个地方不明白
<Context path="/audio" docBase="${catalina.home}/webapps/audio" reloadable="true" debug="0">
这句话里几个参数都起什么作用呢?