最即時的Sybase ASE Server資料庫診斷工具

How to using M-Power Server 行 M-Power Report setup.exe M-Power Report Server MPRS 了 說 M-Power Report Server 料 行 料 料 M-Power Report Server J2SE Development Kit 5.0 連 port 料 MPRS Web-Application MPRS Page 1 of 18

J2SE Development Kit 5.0 行 M-Power Report Server 了 JDK 若 JDK Sun Sun J2SE http://java.sun.com/j2se/downloads/index.html 若 JDK 利 兩 令 JDK JRE 令 java -version javac version 行 令 令 1.5.xxx 了 列 行 java 令 JRE 0-1 0-1 JRE 行 javac 令 JDK 0-2 0-2 JDK Page 2 of 18

JDK 錄 錄 JDK 錄 0-3 0-3 JDK 連 port 了 Apache Tomcat Servlet Container 了 連 異 利 行 令 令 netstat a 來 MPRS 連 8080 8005 8009 5868 5869 連 來 MPRS 0-4 來 MPRS 令 行 Page 3 of 18

0-4 連 ( ) 0-5 MPRS netstat -a 令 行 連 Page 4 of 18

0-5 連 ( ) MPRS 連 行 行 J2SE Development Kit 5.0 連 來 更 行 1: setenv.bat A. <M-Power Report 錄 >\ReportServer\bin\setenv.bat B. J2SE Development Kit 錄 0-6 Page 5 of 18

0-6 setenv.bat C. 2: setenv.bat MPRS 立 錄 便 3 行 A. M-Power Report Report Server B. Tomcat conf\jk2.properties MPRS C. M-Power Report Report Server 3: setclasspath.bat 行 MPRS MPRS 狀 來 A. <M-Power Report 錄 >\ReportServer\bin\setclasspath.bat B. rem === set CLASSPATH for MPRS === 行 C. 行 令 rem Page 6 of 18

D. set mprsroot MPRS 錄 (<M-Power Report 錄 >\ReportServer) E. set CLASSPATH 錄 ( C:\Windows\Fonts 錄 Windows 異 ) 0-7 F. 0-7 setclasspath.bat Page 7 of 18

料 行 M-Power Report Server 了 料 料 了 料 M-Power Report Server 料 了 料 料 料 料 料 料 料 Table 0-1 Table Name Table Description System / User SYS_PROP 參數 SYSTEM CONN_PROFILE 連 SYSTEM REPORT SYSTEM REPORT_PARAMS 參數 SYSTEM REPORTGROUP SYSTEM REPORTGROUP_REPORT SYSTEM ROLE USER USERGROUP USER USER USER USERGROUP_ROLE USER USER_ROLE USER USERGROUP_PERMISSION SYSTEM / USER USER_PERMISSION SYSTEM / USER MODULE SYSTEM MODULE_ROLE SYSTEM / USER 0-1 Table 列 Page 8 of 18

料 料 料 Table 0-2 Table Name Table Name QRTZ_CALENDARS QRTZ_SCHEDULER_STATE QRTZ_FIRED_TRIGGERS QRTZ_TRIGGERS QRTZ_JOB_DETAILS QRTZ_SIMPLE_TRIGGERS QRTZ_JOB_LISTENERS QRTZ_TRIGGER_LISTENERS QRTZ_LOCKS QRTZ_CRON_TRIGGERS QRTZ_PAUSED_TRIGGER_GRPS QRTZ_BLOB_TRIGGERS 0-2 Table 列 Page 9 of 18

MPRS Web-Application 行 M-Power Report Server 了 Web-App 參數 MPRS Web Application 例 料 讀 料 Data Source JNDI Web-App 參數 MPRS web.xml 列 <web-app> <security-constraint> <web-resource-collection> <web-resource-name>mprs resource</web-resource-name> <url-pattern>*.jsp</url-pattern> <url-pattern>*.html</url-pattern> <url-pattern>*.htm</url-pattern> <url-pattern>*.do</url-pattern> <http-method>get</http-method> <http-method>post</http-method> </web-resource-collection> <auth-constraint> <role-name>mprsadmin</role-name> <role-name>mprsuser</role-name> </auth-constraint> </security-constraint> <security-role> <description>the M-Power Report powerful user</description> <role-name>mprsadmin</role-name> </security-role> <security-role> <description>the M-Power Report user</description> <role-name>mprsuser</role-name> </security-role> </web-app> Page 10 of 18

例 料 M-Power Report {M-Power Report 錄 }\MPowerReport\DemoDatabase 例 料 M-Power Report Designer 例 料來 例 料 參數 錄 server.properties 列 #HSQL Database Properties server.database=test/test server.silent=true server.trace=false server.port=5869 server.no_system_exit=false 若 M-Power Report Server 利 料 讀 料 Tomcat Admin Tool 立 Data Source JNDI 例 料 1: http://localhost:8080/admin admin 2: Tomcat Admin Tool Service(Tomcat-Standalone) Host(localhost) Conext(/mprs) Resources Data Sources 0-8 Page 11 of 18

0-8 Context(/mprs) Resources 列 3: JNDI Name jdbc/testdb 0-9 0-9 JNDI Name 4: JNDI 0-10 Page 12 of 18

0-10 JNDI Name-jdbc/TestDB- Page 13 of 18

了 Save Commit Changes Tomcat 料 0.4 料 說 了 M-Power Report Server 料 Table 列 列 料 料 M-Power Report 錄 \MPowerReport\ReportServer\bin server.properties 料 連 料 M-Power Report 錄 \MPowerReport\ReportServer\webapps\mprs\WEB-INF\classes connection.properties 連 料 M-Power Report 錄 \MPowerReport\ReportServer\webapps\mprs\WEB-INF\classes quartz.properties MPRS M-Power Report Server Web Application 讀 理 了 Report Server 邏 來 理 M-Power Report Server 說..\webapps\mprs htm, html, jsp, js, css..\webapps\mprs\web-inf\lib 錄 mrs.jar M-Power Report..\webapps\mprs\WEB-INF\lib 錄 reportapi.jar Page 14 of 18

..\webapps\mprs\web-inf\lib 錄 jar 料..\common\lib 錄 hsqldb.jar 連 料 Oracle Sybase... 料 JDBC Driver 錄 M-Power Report Server..\webapps\mprs\WEB-INF\classes 錄 ReportServer.license..\webapps\mprs\WEB-INF\classes 錄 MPowerChart.license 參數 I..\webapps\mprs\WEB-INF\classes 錄 參數 0-3 參數 說 log4j.properties log quartz.properties 更 0-3 參數 參數 II..\webapps\mprs\WEB-INF\conf 錄 參數 0-4 參數 說 connection.properties 料 更 mprs.properties M-Power Report Server 更 sqlmap.properties SQL command 更 0-4 參數 Page 15 of 18

例 料 說 了 M-Power Report Server 不 M-Power Report Server 來 連 料 例 M-Power Report 例 料 了 M-Power Report Designer Tutorial 料 料 省略 1: M-Power Report Demo Database Start Demo Database 2: Demo Database 3: Listening for connections... Demo Database 0-1 0-1 Demo Database 例 料 1: M-Power Report Demo Database Stop Demo Database 2: Demo Database Page 16 of 18

Report Server 說 M-Power Report Server Report Server M-Power Report Server 行兩 料 M-Power Report Server 料 料 料 來 M-Power Report Server 4: M-Power Report Report Server Start Report Server 料 料 了 了 料 5: Listening for connections... 料 0-1 0-1 料 M-Power Report Server 料 來 M-Power Report Server 6:..\conf\jk2.properties M-Power Report Server 0-2 Page 17 of 18

0-2 M-Power Report Server Report Server M-Power Report Server 行 兩 行 料 M-Power Report Report Server Stop Report Server Page 18 of 18