Xplanner0.7b7 安装说明 (java birt 报表图形乱码 )


<<ResourceBundle_zh_CN.properties>>

<<mysql-connector-java-5.1.37.jar>>

JDK:java version "1.6.0_25"
ANT:Apache Ant(TM) version 1.8.2
xplanner:xplanner-0.7b7-standalone.tar.gz
安装 JDK:
/usr/jdk-6u25-linux-i586.bin
安装后目录 :/usr/jdk1.6.0_25
安装 ant:
tar -zxvf apache-ant-1.8.2-bin.tar.gz  
apache-ant-1.8.2 /usr/local/ant
修改 /etc/profile
export JAVA_HOME=/usr/jdk1.6.0_25
export JRE_HOME=/usr/jdk1.6.0_25/jre
export ANT_HOME=/usr/local/ant
export PATH=/usr/jdk1.6.0_25/bin:$PATH:$ANT_HOME/bin
export CLASSPATH=./:/usr/jdk1.6.0_25/lib:/usr/jdk1.6.0_25/jre/lib

解压 xplanner
tar -zxvf xplanner-0.7b7-standalone.tar.gz
mv xplanner-0.7b7-standalone /opt/xplanner
JDK1.6 的问题解决 :
修改 :/opt/xplanner/webapps/ROOT/WEB-INF/classes/spring-beans.xml
把 <property name=”repositories”><map>……</map></property> 
修改为 
<property name="repositories"> 
<bean class="java.util.HashMap"> 
<constructor-arg> 
<map>…..</map> 
</constructor-arg> 
</bean> 
</property> 
mysql 数据库创建库 :
create database xplanner character set utf8;
修改 xplanner 数据库配置 :
/opt/xplanner/webapps/ROOT/WEB-INF/classes/xplanner.properties
hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.dbname=xplanner
hibernate.connection.url=jdbc:mysql://127.0.0.1/xplanner?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
hibernate.connection.username=root
hibernate.connection.password=
xplanner.migration.databasetype=mysql
xplanner.migration.patchpath=patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install

/opt/xplanner/webapps/ROOT/WEB-INF/classes/xplanner-custom.properties
hibernate.show_sql=false
hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
hibernate.connection.url=jdbc:mysql://127.0.0.1/xplanner?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.dbname=xplanner
hibernate.connection.username=root
hibernate.connection.password=
xplanner.migration.databasetype=mysql
xplanner.migration.patchpath=patches/hsqldb:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install
安装 xplanner
cd /opt/xplanner
#ant create.db.schema.script
将 /opt/xplanner/installer 下的 hibernate_schema.sql 每句后面加上 ";"
到数据库的 xplanner 库中运行该 sql. 创建表和数据库 .
cd /opt/xplanner
# ant bootstrap     将建立sysadmin,密码:admin
#######################
vi /opt/xplanner/webapps/ROOT /WEB-INF/classes/patches/patch0002_bootstrap_users_and_permissions.sql
有关于 permission 的插入改成 :
INSERT INTO permission VALUES(6,5,'%','%',0, 1);
INSERT INTO permission VALUES(7,3,'-create.project','system.project',0, 1);
INSERT INTO permission VALUES(8,3,'-create.person','system.person',0, 1);
INSERT INTO permission VALUES(9,4,'-create.project','system.project',0, 1);
INSERT INTO permission VALUES(10,4,'admin%','%',0, 1);
INSERT INTO permission VALUES(11,3,'create%','%',0, 1);
INSERT INTO permission VALUES(12,3,'edit%','%',0, 1);
INSERT INTO permission VALUES(13,3,'integrate%','%',0, 1);
INSERT INTO permission VALUES(14,3,'delete%','%',0, 1);
INSERT INTO permission VALUES(15,2,'read%','%',0, 1);

1.JSP 页面错误
WEB-INF/jsp/view/notes.jsp

 原来的:  <xplanner:link page="/do/delete/note" onclick='<%="return confirm('Do you want to delete note  ////' " + StringUtilities.replaceQuotationMarks(StringEscapeUtils.escapeJavaScript(note.getSubject())) + " ////'?')"%>' >

替换成: <xplanner:link page="/do/delete/note" onclick='<%="return confirm(/'Do you want to delete note  /////' " + StringUtilities.replaceQuotationMarks(StringEscapeUtils.escapeJavaScript(note.getSubject())) + " /////'?/')"%>' >
WEB-INF/jsp/common/footer.jsp

原来的: <bean:message key="footer.message" arg0="<%=productionSupportEmail%>" arg1="<%=issueLink%>" arg2="<%=appUrl+"/do/systemInfo"%>"/>

替换成: <bean:message key="footer.message" arg0="<%=productionSupportEmail%>" arg1="<%=issueLink%>" arg2="<%=appUrl+/"/do/systemInfo/"%>"/>
#######################################

删除 /opt/xplanner/webapps/ROOT/WEB-INF/classes/patches 下所有文件 .
启动
./startup_xplanner.sh   
############################################
汉化 :
http://www.rayfile.com/zh-cn/files/af26d5f3-71ba-11de-bac7-0019d11a795f/   ( 下载地址 )
增加文件 ResourceBundle_zh_CN.properties 到以下目录 .
/opt/xplanner/webapps/ROOT/WEB-INF/classes/ResourceBundle_zh_CN.properties
图表中文问题 :
使用 windwos 的中文中文字体 simsun.ttf   ( 必须是ttf文件 )
复制到一下目录 :
/usr/jdk1.6.0_25/jre/lib/fonts/fallback/simsun.ttf
重启应用 .