MySQL5與Tomcat-5.5的常用配置文件 自己看的，我比較健忘，配置多次了，還是不能默寫，保存在這里以后查看復制方便。。。。。。 一、MySQL5 配置相關 my.ini ------------------------------------------------------- #[WinMySQLAdmin] #Server=D:/mysql-5.0.37-win32/bin/mysqld.exe [mysqld] # 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' [client] default-character-set=gbk ------------------------------------------------------- 二、Tomcat-5.5配置相關 tomcat-users.xml ------------------------------------------------------- <?xml version='1.0' encoding='utf-8'?> <tomcat-users> <role rolename="manager"/> <role rolename="admin"/> <user username="root" password="leizhimin" roles="manager,admin"/> <user username="manager" password="leizhimin" roles="manager"/> <user username="admin" password="leizhimin" roles="admin"/> </tomcat-users> ------------------------------------------------------- server.xml ------------------------------------------------------- ...... <Connector port="8080" maxHttpHeaderSize="8192" URIEncoding="GBK" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" redirectPort="8443" acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" /> ...... ------------------------------------------------------- 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 ------------------------------------------------------- <!-- The contents of this file will be loaded for each web application --> <Context privileged='true'> <Resource name="jdbc/zfvimsds" auth="Container" type="javax.sql.DataSource" driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://192.168.3.8:50000/zfvims" username="zfvims" password="leizhimin" maxIdle="30" maxWait="10000" maxActive="100" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/> </Context> ------------------------------------------------------- 自動部署腳本、數據源訪問代碼 ------------------------------------------------------- ###下面的批處理腳本放到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(); -------------------------------------------------------

總結

以上是生活随笔為你收集整理的MySQL5与Tomcat-5.5的常用配置文件的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。