Xplanner installation (applicable to both liunx and Windows)

There is a sentence in readme.txt of xplanner.
"Xplanner has only been tested on MySQL 4.X, myslq 5.0, Tomcat 5.x, Java 1.4, Windows and Linux ."
However, my environment is: jdk1.5 + tomcat5.5 + mysql5

JDK, tomcat, and MySQL installation are omitted ......

# Mysqladmin-u Root Password centos
# Mysql-u root-P
Enter password:
Mysql> Create Database xplanner Character Set utf8;
Mysql> create user xplauser identified by 'xplanner ';
Mysql> grant all privileges on xplanner. *
Xplauser @ '%'

Identified by 'xplanner' with grant option;
Mysql> grant all privileges on xplanner. *
Xplauser @ 'localhost'

Identified by 'xplanner' with grant option;
Mysql> flush privileges;

Hibernate. dialect = com. javasetic. xplanner. DB. hibernate. xplannermysqldialect
Hibernate. Connection. driver_class = com. MySQL. JDBC. Driver
Hibernate. Connection. url = JDBC: mysql: // localhost/xplanner? Autoreconnect = true & useunicode = true & characterencoding = utf8
Hibernate. Connection. Username = xplauser
Hibernate. Connection. Password = xplanner

Steps:
1. xplanner-0.7b7b-war.zip of xianxiao
Can go to http://ftp.heanet.ie/disk1/sourceforge/x/xp/xplanner/
Download xplanner-0.7b7-war.zip. Download xplanner-0.7b7b-war.zip

2, xplanner/Web-INF/classes/xplanner. properties and xplanner-custom.properties into the corresponding database connection

3. The xplanner-0.7b7-war/ant create. DB. schema. script will generate a file under the installer directory

4. Run the information of hibernate_schema. SQL In the installer directory, and the required tables will be generated in the database.
Each statement in this script file is not wrapped with a semicolon and must be modified to the executable MySQL format.

5. xplanner-0.7b7-war/ant Bootstrap to build SysAdmin information into MySQL

6. Delete all resources under/WEB-INF/classes/patches

7. Copy xplanner to Tomcat

8. Replace content
Open/xplanner/WEB-INF/classes/spring-beans.xml
Find the bean id = "metarepository"
Replace it with the following

<Property name = "repositories">
<Bean class = "Java. util. hashmap">
<Constructor-Arg>
<Map>... </map>
</Constructor-Arg>
</Bean>
</Property>

<Map>... </map> is wrapped with two attributes.

9. When the foot. jsp page reports an error, the JSP page reports an error. In fact, it is quite simple to set a quotation mark in the quotation marks. It is OK to escape the quotation marks.

 

MySQL Chinese garbled problem:

1: Change xplanner-custom.properties
Hibernate. Connection. url = JDBC: mysql: // localhost/xplanner? Autoreconnect = true & useunicode = true & characterencoding = GBK

2: new database, encoded as GBK
Create Database 'xplanner' default Character Set GBK collate gbk_chinese_ci;

In fact, as long as the access encoding is consistent, it is no problem to set them to utf8!

Localization problem:

Overwrite the Chinese file http://runthu.javaeye.com/topics/download/942e7cab-b1f3-3376-bd00-8c804f602983 to the xplanner/WEB-INF/classes directory.