Xplanner installation (Liunx, Windows Fit)

There's a word in Xplanner's readme.txt.
"Xplanner has only been tested on MySQL 4.x, MYSLQ 5.0, Tomcat 5.x, Java 1.4, Windows and Linux."
But the environment I use is, jdk1.5+tomcat5.5+mysql5.

Install JDK, tomcat, MySQL 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 in xplanner.* to xplauser@ '% ' identified by ' Xplanner ' with GRANT option;
Mysql>grant all privileges in xplanner.* to xplauser@ ' localhost ' identified by ' Xplanner ' with GRANT option;
mysql> flush Privileges;

Hibernate.dialect=com.technoetic.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, download the Xplanner-0.7b7b-war.zip
can go to http://ftp.heanet.ie/disk1/sourceforge/x/xp/xplanner/to download, Do not download xplanner-0.7b7-war.zip, to download Xplanner-0.7b7b-war.zip

2, Xplanner/web-inf/classes/xplanner.properties and xplanner-custom.properties into the corresponding database connection

3. xplanner-0.7b7-war/ant Create.db.schema.script will generate files in installer directory

4, the installer directory to run the Hibernate_schema.sql data, will produce the necessary tables in the database
This script file does not have a semicolon wrapped in each statement, but also modifies itself to the MySQL executable format

5, Xplanner-0.7b7-war/ant Bootstrap to build sysadmin's information into MySQL

6, delete all the information under the/web-inf/classes/patches

7, Xplanner Copy to Tomcat

8, replace the content
Open/xplanner/web-inf/classes/spring-beans.xml
Find Bean id= "Metarepository"
Replace it with the following

<property name= "Repositories" >
<bean class= "Java.util.HashMap" >
<constructor-arg>
<map>.....</map>
</constructor-arg>
</bean>
</property>

is to wrap <map>...</map> with two properties outside.

9, foot.jsp page error, JSP page error is very simple, that is, quotes inside a set of quotes, the inside of the quotes escaped OK.

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 code is consistent, it is not a problem to set the UTF8.


Chinese problem:

http://runthu.javaeye.com/topics/download/file in Chinese The 942e7cab-b1f3-3376-bd00-8c804f602983 is covered in the Xplanner/web-inf/classes directory.