1.
F:\win7_vm1_cognos10
2.测试环境
3.java部分代码验证数据库连接
附录代码
package com.hx;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class OracleConnectionTest {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
// 加载Oracle驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
// 建立连接
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:ORCL", "cognos", "mima");
// 创建Statement对象
stmt = conn.createStatement();
// 执行查询语句
rs = stmt.executeQuery("SELECT * FROM emp_test");
// 遍历查询结果
while (rs.next()) {
System.out.println(rs.getString("empno") + "\t");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
// 关闭ResultSet
if (rs != null) {
rs.close();
}
// 关闭Statement
if (stmt != null) {
stmt.close();
}
// 关闭Connection
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
http://127.0.0.1:9300/p2pd/pat/rsapp.htm
启动日记
[正在使用“最大内存(以 MB 计)”启动 JVM]
已成功使用内存设置 “768”启动了测试 JVM。请注意,这并不能保证 IBM Cognos 服务会成功启动和运行。
要查看哪一个 JVM 选项基于此设置,请查看 ibmcognos_location/bin/bootstrap_<OS>.xml 并查看您的 JVM 文档以获取这些选项的说明。
[档案库本地文件系统根目录]
由于值为空,因此功能被禁用。没有要测试的项目。
[验证邮件服务器属性。]
[错误] 无法到达邮件服务器。
[停止服务]
02:19:23, 'Dispatcher', 'Stop', 'Success'.
02:19:23, 'CPS Producer Registration Service', 'StopService', 'Success'.
02:19:25, 'MetadataService', 'StopService', 'Success'.
02:19:25, 'IndexDataService', 'StopService', 'Success'.
02:19:25, 'AgentService', 'StopService', 'Success'.
02:19:25, 'AnnotationService', 'StopService', 'Success'.
02:19:25, 'IndexUpdateService', 'StopService', 'Success'.
02:19:25, 'HumanTaskService', 'StopService', 'Success'.
02:19:25, 'JobService', 'StopService', 'Success'.
02:19:25, 'DeliveryService', 'StopService', 'Success'.
02:19:25, 'DimensionManagementService', 'StopService', 'Success'.
02:19:25, 'IndexSearchService', 'StopService', 'Success'.
02:19:25, 'EventService', 'StopService', 'Success'.
02:19:25, 'ReportService', 'StopService', 'Success'.
02:19:25, 'ContentManagerCacheService', 'StopService', 'Success'.
02:19:25, 'relationalMetadataService', 'StopService', 'Success'.
02:19:25, 'idVizService', 'StopService', 'Success'.
02:19:25, 'CacheService', 'StopService', 'Success'.
02:19:25, 'camAsyncAA', 'StopService', 'Success'.
02:19:25, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
02:19:25, 'ReportDataService', 'StopService', 'Success'.
02:19:25, 'PresentationService', 'StopService', 'Success'.
02:19:25, 'GraphicsService', 'StopService', 'Success'.
02:19:25, 'MonitorService', 'StopService', 'Success'.
02:19:25, 'BUX Service', 'StopService', 'Success'.
02:19:26, 'SystemService', 'StopService', 'Success'.
02:19:26, 'QueryService', 'StopService', 'Success'.
02:19:26, 'BatchReportService', 'StopService', 'Success'.
02:19:26, 'com.cognos.pogo.reportservice.ProcessFacade', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
Failed to send HTTP request or read HTTP response
02:19:26, 'Fragment Server Service', 'StopService', 'Success'.
02:19:26, 'ContentManagerService', 'StopService', 'Success'.
02:19:25, 'RepositoryService', 'StopService', 'Success'.
02:19:26, 'LogService', 'StopService', 'Success'.
[启动服务]
02:20:36, 'LogService', 'StartService', 'Success'.
02:20:36, CAF input validation enabled.
02:20:36, CAF Third Party XSS checking disabled.
02:20:42, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.
02:20:42, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.
02:20:42, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.
02:20:42, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.
02:20:42, CM-SYS-2215 A Content Manager internal CMUPGRADESCRIPT task started.
02:20:43, 'ContentManagerService', 'StartService', 'Success'.
02:20:43, CM-SYS-5159 Content Manager is running in active mode.
02:20:43, DPR-DPR-1002 Successfully registered the dispatcher http://xb-20210802vxnm:9300/p2pd in Content Manager.
02:20:47, 'camAsyncService', 'StartService', 'Success'.
02:21:01, 'Fragment Server Service', 'StartService', 'Success'.
02:21:01, 'BatchReportService', 'StartService', 'Success'.
02:21:01, Start a External Process because the start count 1 is larger than 0.
02:21:12, 'QueryService', 'StartService', 'Success'.
02:21:12, 'QueryService', 'StartService', 'Success'.
02:21:12, 'SystemService', 'StartService', 'Success'.
02:21:13, 'RepositoryService', 'StartService', 'Success'.
02:21:13, 'com.cognos.pogo.reportservice.ProcessManager', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
Process cgsLauncher failed to start properly.
02:21:13, 'GraphicsService', 'StartService', 'Success'.
02:21:13, 'ReportDataService', 'StartService', 'Success'.
02:21:13, 'BUX Service', 'StartService', 'Success'.
02:21:15, 'IBM Cognos Enhanced Search Service', 'StartService', 'Success'.
02:21:15, 'camAsyncAA', 'StartService', 'Success'.
02:21:15, 'CacheService', 'StartService', 'Success'.
02:21:15, 'idVizService', 'StartService', 'Success'.
02:21:15, 'relationalMetadataService', 'StartService', 'Success'.
02:21:15, 'ContentManagerCacheService', 'StartService', 'Success'.
02:21:15, 'ReportService', 'StartService', 'Success'.
02:21:15, 'MonitorService', 'StartService', 'Success'.
02:21:15, 'IndexSearchService', 'StartService', 'Success'.
02:21:15, 'DimensionManagementService', 'StartService', 'Success'.
02:21:15, 'DeliveryService', 'StartService', 'Success'.
02:21:15, 'JobService', 'StartService', 'Success'.
02:21:15, 'HumanTaskService', 'StartService', 'Success'.
02:21:15, 'IndexUpdateService', 'StartService', 'Success'.
02:21:15, 'AnnotationService', 'StartService', 'Success'.
02:21:15, 'AgentService', 'StartService', 'Success'.
02:21:15, 'IndexDataService', 'StartService', 'Success'.
02:21:15, 'PresentationService', 'StartService', 'Success'.
02:21:15, 'MetadataService', 'StartService', 'Success'.
02:21:15, 'EventService', 'StartService', 'Success'.
02:21:16, 'CPS Producer Registration Service', 'StartService', 'Success'.
02:21:17, 'Dispatcher', 'Start', 'Success'.
启动日记ok的 Success
没理解
数据库查询更新主题
后续补充吧