1、第一个图解courseID: nullsqlSelectUserSCO= select * from scostulessoninfo WHERE student_id =null ANDcourse_id =null AND sco_id = nullsqlUpdateUserSCO= UPDATE scostulessoninfo SET lesson_status = incomplete, Exit =, Entry =,Time=00:02:13.76,mastery_score=,lesson_mode=Normal WHEREstudent_id =null AND course
2、_id =null AND sco_id = nullsqlInsertUserSCO= insert into scostulessoninfo (student_id,course_id,sco_id,lesson_status,Exit,Entry,Time,mastery_Score,lesson_mode) values (null,null,null,incomplete,00:02:13.76,Normal)java.io.FileNotFoundException: X:resourcecoursescofilenullnulltrainCourse.xml (系统找不到指定的
3、文件。)at java.io.FileInputStream.open(Native Method)at java.io.FileInputStream.(FileInputStream.java:106)at java.io.FileInputStream.(FileInputStream.java:66)at .www.protocol.file.FileURLConnection.connect(FileURLConnection.java:70)at .www.protocol.file.FileURLConnection.getInputStream(FileURLConnectio
4、n.java:161)at .URL.openStream(URL.java:1007)at org.apache.xerces.readers.DefaultReaderFactory.createReader(DefaultReaderFactory.java:149)at org.apache.xerces.readers.DefaultEntityHandler.startReadingFromDocument(DefaultEntityHandler.java:493)at org.apache.xerces.framework.XMLParser.parseSomeSetup(XM
5、LParser.java:314)at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1097)at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1139)at com.bupticet.util.trainCourse.modifiyXMLFile(trainCourse.java:141)at org.adl.samplerte.server.LMSCMIServlet.HandleData(LMSCMIServlet.java:433)at o
6、rg.adl.samplerte.server.LMSCMIServlet.service(LMSCMIServlet.java:170)at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubS
7、ecurityHelper.java:125)at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)at com.buptol.filter.SignOnFilter.doFilter(SignOnFilt
8、er.java:99)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)at com.buptol.filter.EncodingFilter.doFilter(EncodingFilter.java:59)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)at weblogic.servlet.internal.WebAppServletContext$ServletInvocati
9、onAction.run(WebAppServletContext.java:3242)at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java
10、:2010)at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916)at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)requ
11、ested session: sGmvNv2NjhkQDTGTR8jF5sTmkJcF6BYZTyh14vhDzlTrDH6vxXpL!993852123!1299133997890requested session id from cookiequery string: nullheader string:cookie header: JSESSIONID=sGmvNv2NjhkQDTGTR8jF5sTmkJcF6BYZTyh14vhDzlTrDH6vxXpL!993852123HostContent-TypeCache-ControlPragmaUser-AgentAcceptConten
12、t-LengthCookieViaPOST received by LMSCMIServletsession id is: sGmvNv2NjhkQDTGTR8jF5sTmkJcF6BYZTyh14vhDzlTrDH6vxXpL!993852123!1299133997890about to check attributessession scoID: S_pku16_304_2_0_0_0_0_0Created REQUEST object INPUT stream successfullyCreated RESPONSE object OUTPUT stream successfullyC
13、ommand to LMSCMIServlet is: cmigetcatCreated LMSSCODataFile FILE input stream successfullyscoFile=X:/resource/course/scofile/null/null/S_pku16_304_2_0_0_0_0_0Created OBJECT input stream successfullyLMSCMIServlet processed get for SCO Data- count1 =1- count1 =1- count1 =1- count1 =1用户 ID:66121有效学时数:9
14、.0用户:66121完成单元数:3所有单元数:10UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.7,period=0.9000001 where staticsid=387918- count1 =1- count1 =1- *sendJms() 向 ims系统发送数据*- *系统厂商名称(SCENE)：=中电飞华- *系统服务平均响应时长(BusinessSystemResponseTime)：=346- * 系统健康运行时长(BusinessSystemRunningTime):=97267-
15、 * 会话连接数(BusinessSystemSessionNum):1491- * 在线用户数(BusinessSystemOnlineNum):=1- =操作数据库 策略执行开始=- * 累计访问人次(BusinessVisitCount):=9573617- * 当日登录人数(BusinessDayLoginNum):=40- * 平均数据库访问时间(BusinessSystemDBTime):=711- Connecting to URL: tcp:/10.122.1.146:61616- =weblogic 策略执行开始=- 服务名称：YCPX_1- domian：YCPX_doma
16、in- 系统健康运行时长（秒）:=97867 秒- =获得 webApp信息=connection session messageCount count: 0 unit: count startTime: 1299134100015 lastSampleTime:1299134100015 description: Number of messages exchanged messageRateTime count: 0 maxTime: 0 minTime: 0 totalTime: 0 averageTime: 0.0 averageTimeExMinMax: 0.0 averagePer
17、Second: 0.0 averagePerSecondExMinMax: 0.0 unit: millis startTime: 1299134100015 lastSampleTime: 1299134100015 description:Time taken to process a message (thoughtput rate) pendingMessageCount count: 0 unit: count startTime: 1299134100015 lastSampleTime: 1299134100015 description: Number of pending m
18、essages expiredMessageCount count: 0 unit: count startTime: 1299134100015 lastSampleTime: 1299134100015 description: Number of expired messages messageWaitTime count: 0 maxTime: 0 minTime: 0 totalTime: 0 averageTime: 0.0 averageTimeExMinMax: 0.0 averagePerSecond: 0.0 averagePerSecondExMinMax: 0.0 un
19、it: millis startTime: 1299134100015 lastSampleTime: 1299134100015 description:Time spent by a message before being delivered durableSubscriptionCount count: 0 unit: count startTime: 1299134100015 lastSampleTime: 1299134100015 description: The number of durable subscriptions producers producer queue:
20、/IMS.RawPerf messageCount count: 0 unit: count startTime: 1299134100015 lastSampleTime: 1299134100015 description: Number of messages processed messageRateTime count: 0 maxTime: 0 minTime: 0 totalTime: 0 averageTime: 0.0 averageTimeExMinMax: 0.0 averagePerSecond: 0.0 averagePerSecondExMinMax: 0.0 un
21、it: millis startTime: 1299134100015 lastSampleTime: 1299134100015 description: Time taken to process a message (thoughtput rate) pendingMessageCount count: 0 unit: count startTime: 1299134100015 lastSampleTime: 1299134100015 description: Number of pending messages messageRateTime count: 0 maxTime: 0
22、 minTime: 0 totalTime: 0 averageTime: 0.0 averageTimeExMinMax: 0.0 averagePerSecond: 0.0 averagePerSecondExMinMax: 0.0 unit: millis startTime: 1299134100015 lastSampleTime: 1299134100015 description: Time taken to process a message (thoughtput rate) expiredMessageCount count: 0 unit: count startTime
23、: 1299134100015 lastSampleTime: 1299134100015 description: Number of expired messages messageWaitTime count: 0 maxTime: 0 minTime: 0 totalTime: 0 averageTime: 0.0 averageTimeExMinMax: 0.0 averagePerSecond: 0.0 averagePerSecondExMinMax: 0.0 unit: millis startTime: 1299134100015 lastSampleTime: 129913
24、4100015 description: Time spent by a message before being delivered consumers - *结束 sendJms() 向 ims系统发送数据*- producer,session,connection colose()- =weblogic 策略执行结束=- count1 =1- =操作结果为：jmsPub.getMonitorMap():=YCPXJoinStudyPersonPerMonth=0, BusinessUserRegNum=19145, YCPXHotCourseWarePerMonth=, YCPXStud
25、yCompleteCountRankingRoll=, BusinessSystemDBTime=352, YCPXJoinStudyPersonPerYear=0, YCPXStudyCountRankingRoll=, BusinessDayLoginNum=40, YCPXStudyCompleteCountPerYear=, YCPXWelcomeCourseWarePerHistory=, BusinessSystemResponseTime=346, YCPXStudyTimeRankingRoll=, BusinessSystemRunningTime=97567, YCPXWe
26、lcomeCourseWarePerMonth=, BusinessDataTableSpace=169, YCPXHotCourseWarePerHistory=, BusinessSystemLoginRoll=, YCPXLearnTime=422281, YCPXCourseWareCount=0, BusinessVisitCount=9573746, YCPXStudyCountPerYear=, BusinessSystemOnlineNum=1, BusinessSystemSessionNum=1491, YCPXStudyTimePerYear=, YCPXNewCours
27、eWarePerMonth=0, YCPXLearnTimeLong=354986=- =操作数据库 策略执行结束=用户 ID:0有效学时数:3.0用户:0完成单元数:0所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=0.0,period=0.0 where staticsid=388059- count1 =1用户 ID:37573有效学时数:2.0用户:37573完成单元数:3所有单元数:3UpdateStudyRecordsqlstr:update studentstandardst
28、atics set totalperiod=2.0,period=1.333 where staticsid=388006- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1用户 ID:66121有效学时数:9.0用户:66121完成单元数:3所有单元数:10UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.7,period=0.9000001 where staticsid=3
29、87918- count1 =1- count1 =1- count1 =1用户 ID:0有效学时数:3.0用户:0完成单元数:0所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=0.0,period=0.0 where staticsid=388059- count1 =1用户 ID:37573有效学时数:2.0用户:37573完成单元数:3所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperio
30、d=2.0,period=1.333 where staticsid=388006- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1用户 ID:66121有效学时数:9.0用户:66121完成单元数:3所有单元数:10UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.7,period=0.9000001 where staticsid=387918- count1 =1- co
31、unt1 =1- count1 =1用户 ID:0有效学时数:3.0用户:0完成单元数:0所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=0.0,period=0.0 where staticsid=388059- count1 =1用户 ID:37573有效学时数:2.0用户:37573完成单元数:3所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.0,period=1.333 w
32、here staticsid=388006- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1用户 ID:66121有效学时数:9.0用户:66121完成单元数:3所有单元数:10UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.7,period=0.9000001 where staticsid=387918- count1 =1- count1 =1- count1 =1用户
33、 ID:0有效学时数:3.0用户:0完成单元数:0所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=0.0,period=0.0 where staticsid=388059- count1 =1用户 ID:37573有效学时数:2.0用户:37573完成单元数:3所有单元数:3UpdateStudyRecordsqlstr:update studentstandardstatics set totalperiod=2.0,period=1.333 where staticsid=388006- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1- count1 =1
