Tomcat5.0+mysql5.0.0-alpha配置xpetstore
来源:互联网 发布:双语歌词制作软件 编辑:程序博客网 时间:2024/06/13 10:17
1.启动WEB服务器:
假设Tomcat, mysql都安装在C盘根目录下;
在DOS下运行命令,C:/>cd Tomcat5.0/bin回车;C:/Tomcat5.0/bin> startup.bat;
2.选择项目运行的服务器,这里选择Tomcat:
编辑XPETSTORE_HOME/conf/as/appserver.properties文件,确定app.server=tomcat;
3.选择项目运行的数据库,这里选择mysql:
编辑XPETSTORE_HOME/conf/db/database.properties文件,确定database=mysql;并编辑mysql.properties文件,设置db.driver,db.url,db.user,db.password,db.classpath,这里只须设置db.user=root db.password=即可,不要修改hibernate属性;
打开MySQL Control Center0.9.4-beta软件,并建立数据库xpetstore;
4.建立xpetstore源代码:
命令行输入:cd XPETSTORE_HOME/xpetstore-servlet目录,并执行build.bat
5.测试xpetstore项目(仅对xpetstore-ejb有效):
命令行输入:cd
XPETSTORE_HOME/xpetstore-servlet目录,并执行build.bat test
6.配置xpetstore项目:
命令行输入:cd
XPETSTORE_HOME/xpetstore-servlet目录,并执行build.bat deploy
7.初始化数据库(两种方法):
(1) 先编辑XPETSTORE_HOME/conf/db/mysql.properties文件,确定db.classpath=${lib.dir}/main/com.mysql/mysql-connector-java-3.1.8-bin.jar,必须采用此驱动,否则执行
命令行输入:cd
XPETSTORE_HOME/xpetstore-servlet目录,并执行build.bat db会出错;错误提示内容为java.sql.SQLException: Can not connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to?<java.lang.NumberFormatException>执行build.bat db命令后,会出现一些找不到表之类的错误,不用理会,此时数据表已在MySQL Control Center中创建;再执行XPETSTORE_HOME/xpetstore-servlet/sql/data.sql导入数据;
(2) 打开MySQL Control Center0.9.4-beta软件,并在数据库xpetstore执行XPETSTORE_HOME/xpetstore-servlet/build/sql/schemas.sql创建表结构;再执行XPETSTORE_HOME/xpetstore-servlet/sql/data.sql导入数据;
8.根据mysql版本为其配置合适的JDBC驱动:
本文中必须采用mysql-connector-java-3.1.8-bin.jar驱动程序,将其分别拷贝到C:/Tomcat 5.0/common/lib和C:/Tomcat 5.0/webapps/xpetstore-servlet/WEB-INF/lib目录下面!
一般情况下采用XPETSTORE_HOME/lib/main/com.mysql/mysql-connector-java-bin.jar驱动!
9.编辑Tomcat5.0下conf目录中的server.xml:
在<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">与</Host>之间插入以下代码:
<!-- xPetstore -->
<Context path="/xpetstore-servlet" docBase="xpetstore-servlet"
debug="0" reloadable="true" crossContext="true">
<!-- xPetsore Logger -->
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs"
prefix="xpetstore-servlet_log."
suffix=".txt"
timestamp="true"
/>
<!-- xPetstore datasource -->
<Resource name="jdbc/xpetstoreDS" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xpetstoreDS">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/xpetstore</value>
</parameter>
</ResourceParams>
<!-- xPetstore mail session -->
<Resource name="mail/xpetstore/MailSession"
auth="Container" type="javax.mail.Session"/>
<ResourceParams name="mail/xpetstore/MailSession">
<parameter>
<name>mail.smtp.host</name>
<value>your-mail-host</value>
</parameter>
</ResourceParams>
</Context> 说明:上面语句中蓝色部分,必须采用org.gjt.mm.mysql.Driver类,如果采用com.gjt.mm.mysql.Driver则会出错,错误提示内容为:
type Status report
message Cannot load JDBC driver class 'com.gjt.mm.mysql.Driver'
description The server encountered an internal error (Cannot load JDBC driver class 'com.gjt.mm.mysql.Driver') that prevented it from fulfilling this request.
10.运行项目:
http://localhost:8080/xpetstore-servlet/
本文参考http://xpetstore.sourceforge.net/run.html及http://xpetstore.sourceforge.net/setup_tomcat-4.x.html,并结合实际配置!
- Tomcat5.0+mysql5.0.0-alpha配置xpetstore
- Jbuilder2006+MySQL5.0+Tomcat5.5.9数据源配置(原创)
- Tomcat5.5(以上)+mysql5.0数据库连接池配置
- Tomcat5.5 + Mysql5.0 JNDI
- Tomcat5.5.15连接MySql5.0.18相关配置
- MySQL5.0 Alpha & Create Procedure
- java1.6+tomcat5.5+mysql5.0+eclipse+myeclipse环境的配置
- 最新liux下tomcat5.5.25+mysql5.0.45+jdk1.0.5.13+eclipse3.3.1+myeclipse6.0配置
- linux下tomcat5.5.25+mysql5.0.45+jdk1.0.5.13+eclipse3.3.1+myeclipse6.0配置
- liux下tomcat5.5.25+mysql5.0.45+jdk1.0.5.13+eclipse3.3.1+myeclipse6.0配置
- Peeking in MySQL5.0 alpha Enterprise Functional
- JbuliderX+Tomcat5.0配置
- JbuliderX+Tomcat5.0配置
- Tomcat5.0的配置
- tomcat5.5.20中配置mysql5.0.22的方法
- MySQL5.02 alpha 安装
- tomcat5.0的数据源配置。
- Tomcat5.0数据库连接池配置
- 什么是xDSL?
- jsp页面不能正常显示,同时又不报错:
- IRM(InformationRightsManagement)即信息权限管理
- 写在每年开学的日子
- 第一次正式写Blog
- Tomcat5.0+mysql5.0.0-alpha配置xpetstore
- 鲁迅的遗言
- 大喜的日子
- 当innerHTML遇到flash壳
- 开闭原则(Open-Closed Principle)与Strategy模式
- 2006-9-1 中学网站首页色彩搭配
- readFile
- Csdn Blog模板CSS代码(6):笔记簿
- The Database Hacker's Handbook : Defending Database Servers