eclipse myeclipse mysql服务器tomcat

Eclipse myeclipse MySQL
服务器
TOMCAT
1.配置数据源（Tomcat 5.0\conf\server.XML）在</Host>添加

<Context path="/tt" docBase="tt"
debug="5" reloadable="true" crossContext="true">
<!--tt为部署工程的名称，在C:\Tomcat 5.0\Webapps下-->
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_tt_log." suffix=".txt"
timestamp="true"/>

<Resource name="JDBC/mysql"
auth="Container"
type="Javax.sql.DataSource"/>
<!--jdbc/mysql isjndi name-->
<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>root</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>com.mysql.jdbc.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/mydb?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
<!--mydb数据库名-->
2. 修改web.xml

打开%TOMCAT_HOME%\conf\web.xml,在</web-app>的前面添加以下内容：

<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

3. JDBC驱动程序mysql-connector-java-3.0.15-ga-bin.jar放置在%TOMCAT_HOME%\common\lib和应用的WEB-INF\lib下

在启动服务器前，把你的tt部署到C:\Tomcat 5.0\webapps
一切OK，启动你的猫猫

上一篇： 关于flecho (flash echo) 的设想，欢迎讨论
下一篇： 通过JDBC创建Oracle的存储过程

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有