MySQL5与Tomcat
MySQL5与Tomcat-5.5的常用配置文件自己看的,我比较健忘,配置多次了,还是不能默写,保存在这里以后查看复制方便。。。。。。
一、MySQL5 配置相关
my.ini
-------------------------------------------------------
#
#Server=D:/mysql-5.0.37-win32/bin/mysqld.exe
# set basedir to your installation path
#basedir=D:/mysql-5.0.37-win32
# set datadir to the location of your data directory
port = 3306
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
datadir=data
default-character-set=gbk
init_connect='SET AUTOCOMMIT=0'
default-table-type=InnoDB
init_connect='set completion_type=1'
default-character-set=gbk
-------------------------------------------------------
二、Tomcat-5.5配置相关
tomcat-users.xml
-------------------------------------------------------
-------------------------------------------------------
server.xml
-------------------------------------------------------
......
......
-------------------------------------------------------
catalina.bat
-------------------------------------------------------
......
set JAVA_HOME=D:\j2sdk15
set CALSSPATH=.;D:\j2sdk15\tools.jar;D:\j2sdk15\dt.jar
set JAVA_OPTS=-Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=9999,suspend=n,server=y
......
-------------------------------------------------------
context.xml
-------------------------------------------------------
-------------------------------------------------------
自动部署脚本、数据源访问代码
-------------------------------------------------------
###下面的批处理脚本放到webapp下面运行
rd /s /q zvfims
rd /s /q ..\work\Catalina\localhost\zvfims
del /q zvfims.war
..\bin\catalina start
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/zfvimsds");
con = ds.getConnection();
-------------------------------------------------------
附件:http://down.运维网.com/data/2348034
页:
[1]