> 데이터 베이스 > MySQL 튜토리얼 > broadleaf commerce到mysql和tomcat的迁移_MySQL

broadleaf commerce到mysql和tomcat的迁移_MySQL

WBOY
풀어 주다: 2016-06-01 13:15:51
원래의
1254명이 탐색했습니다.

Tomcat

    最近刚刚接触broadleaf commerce, 一个电商网站的开源模版。具体的运行和配置可以参考链接:点击打开链接

而该模版是在jetty容器下运行的,数据库是HSQL。官方网站上给出了如何将数据库迁移到mysql以及把项目工程部署在tomcat中所需要的配置,但是过程不甚详细,网上这方面的资源也不是很多,所以楼主就打算写这篇博客作为一个总结。

1.数据库的迁移(HSQL到MYSQL)

(a)打开DemoSite工程的根目录下pom.xml文件,在<dependencymanagement>区域中添加:</dependencymanagement>

<dependency>	<groupid>mysql</groupid>	<artifactid>mysql-connector-java</artifactid>	<version>5.1.26</version>	<type>jar</type>	<scope>compile</scope></dependency>
로그인 후 복사
(b)分别在admin和site文件夹中找到pom.xml打开并在<dependencies></dependencies>区域中添加:
<dependency><groupid>mysql</groupid><artifactid>mysql-connector-java</artifactid></dependency>
로그인 후 복사
(c)在mysql数据库中添加database名为broadleaf(d)分别打开admin/src/main/webapp/META-INF和<code>admin/src/main/webapp/META-INF中的context.xml,将内容替换如下(数据库相关的配置信息如用户名和密码请根据自身的环境作相应的修改):
<?xml version="1.0" encoding="UTF-8"?><context><resource name="jdbc/web" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testwhileidle="true" testonborrow="true" testonreturn="false" validationquery="SELECT 1" timebetweenevictionrunsmillis="30000" maxactive="15" maxidle="10" minidle="5" removeabandonedtimeout="60" removeabandoned="false" logabandoned="true" minevictableidletimemillis="30000" jdbcinterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" username="root" password="123" driverclassname="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/broadleaf"></resource><resource name="jdbc/storage" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testwhileidle="true" testonborrow="true" testonreturn="false" validationquery="SELECT 1" timebetweenevictionrunsmillis="30000" maxactive="15" maxidle="10" minidle="5" removeabandonedtimeout="60" removeabandoned="false" logabandoned="true" minevictableidletimemillis="30000" jdbcinterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" username="root" password="123" driverclassname="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/broadleaf"></resource><resource name="jdbc/secure" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testwhileidle="true" testonborrow="true" testonreturn="false" validationquery="SELECT 1" timebetweenevictionrunsmillis="30000" maxactive="15" maxidle="10" minidle="5" removeabandonedtimeout="60" removeabandoned="false" logabandoned="true" minevictableidletimemillis="30000" jdbcinterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" username="root" password="123" driverclassname="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/broadleaf"></resource></context>
로그인 후 복사

(e)打开core/src/main/resources/runtime-properties/common-shared.properties文件,将以下的三条

blPU.hibernate.dialect=org.hibernate.dialect.HSQLDialectblCMSStorage.hibernate.dialect=org.hibernate.dialect.HSQLDialectblSecurePU.hibernate.dialect=org.hibernate.dialect.HSQLDialect
로그인 후 복사

分别替换为:

blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialectblSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialectblCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
로그인 후 복사

(f)打开DemoSite根目录下的build.properties,将如下内容

ant.hibernate.sql.ddl.dialect=org.hibernate.dialect.HSQLDialectant.blPU.url=jdbc:hsqldb:hsql://localhost/broadleafant.blPU.userName=saant.blPU.password=nullant.blPU.driverClassName=org.hsqldb.jdbcDriverant.blSecurePU.url=jdbc:hsqldb:hsql://localhost/broadleafant.blSecurePU.userName=saant.blSecurePU.password=nullant.blSecurePU.driverClassName=org.hsqldb.jdbcDriverant.blCMSStorage.url=jdbc:hsqldb:hsql://localhost/broadleafant.blCMSStorage.userName=saant.blCMSStorage.password=nullant.blCMSStorage.driverClassName=org.hsqldb.jdbcDriver
로그인 후 복사

根据自己数据库的配置修改为:

ant.hibernate.sql.ddl.dialect=org.hibernate.dialect.MySQL5InnoDBDialectant.blPU.url=jdbc:mysql://localhost:3306/broadleafant.blPU.userName=rootant.blPU.password=123ant.blPU.driverClassName=com.mysql.jdbc.Driverant.blSecurePU.url=jdbc:mysql://localhost:3306/broadleafant.blSecurePU.userName=rootant.blSecurePU.password=123ant.blSecurePU.driverClassName=com.mysql.jdbc.Driverant.blCMSStorage.url=jdbc:mysql://localhost:3306/broadleafant.blCMSStorage.userName=rootant.blCMSStorage.password=123ant.blCMSStorage.driverClassName=com.mysql.jdbc.Driver
로그인 후 복사
sudo /etc/init.d/tomcat7 restart
로그인 후 복사
로그인 후 복사
로그인 후 복사

这样数据库的迁移就完成了。

2.服务器的迁移(从jetty到tomcat7)(a)在site和admin目录下的pom.xml文件的中<plugins>区域中分别添加:</plugins>
<plugin>				<groupid>org.apache.tomcat.maven</groupid>				<artifactid>tomcat7-maven-plugin</artifactid>				<version>2.0</version>				<configuration>					<warsourcedirectory>${webappDirectory}</warsourcedirectory>					<path>/</path>					<port>${httpPort}</port>					<httpsport>${httpsPort}</httpsport>					<keystorefile>${webappDirectory}/WEB-INF/blc-example.keystore</keystorefile>					<keystorepass>broadleaf</keystorepass>					<password>broadleaf</password>				</configuration>			</plugin>
로그인 후 복사
<code>(b)在eclipse中右键DemoSite工程,先后运行Run As里面的Maven clean和Maven install,成功后就会在DemoSite中的admin和site的target文件夹中有相应的war包生成,楼主生成的两个war包名为admin.war和zk.war。

(c)楼主的环境是ubuntu,tomcat服务器中webapps的路径为/var/lib/tomcat7/webapps,将admin和zk.war拷贝到该目录下,然后重启tomcat服务器

sudo /etc/init.d/tomcat7 restart
로그인 후 복사
로그인 후 복사
로그인 후 복사

观察/var/log/tomcat7/catalina.out文件报错如下:

Caused by: java.lang.OutOfMemoryError: Java heap space	at org.apache.tomcat.util.bcel.classfile.ClassParser.readMethods(ClassParser.java:268)	at org.apache.tomcat.util.bcel.classfile.ClassParser.parse(ClassParser.java:128)	at org.apache.catalina.startup.ContextConfig.processAnnotationsStream(ContextConfig.java:2105)	at org.apache.catalina.startup.ContextConfig.processAnnotationsJar(ContextConfig.java:1981)	at org.apache.catalina.startup.ContextConfig.processAnnotationsUrl(ContextConfig.java:1947)	at org.apache.catalina.startup.ContextConfig.processAnnotations(ContextConfig.java:1932)	at org.apache.catalina.startup.ContextConfig.webConfig(ContextConfig.java:1326)	at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:878)	at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:369)	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5179)	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1114)	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1673)	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)	... 4 more
로그인 후 복사

百度了以后得知是内存溢出的问题,具体的解决方案如下:

ubuntu中修改catalina.sh文件(楼主该文件的路径是/usr/share/tomcat7/bin/catalina.sh),在文件首行添加如下内容:

JAVA_OPTS='-server -Xms256m -Xmx512m -XX:PermSize=128M -XX:MaxPermSize=256M' #注意:单引号不能省略
로그인 후 복사
windows中修改catalina.bat文件,在第一行添加如下内容:
set JAVA_OPTS=-server -Xms256m -Xmx512m -XX:PermSize=128M -XX:MaxPermSize=256M #注意:无单引号
로그인 후 복사
(d)按照(c)中修改完成后再重启tomcat服务器:
sudo /etc/init.d/tomcat7 restart
로그인 후 복사
로그인 후 복사
로그인 후 복사
就可以在浏览器中正常打开电商页面:localhost:8080/zk和后台管理页面:localhost:8080/admin了,往tomcat服务器的迁移也大功告成啦。
원천:php.cn
본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
최신 이슈
인기 튜토리얼
더>
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿