cognos8在win环境下 安装了oracle

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

没理解

数据库查询更新主题

后续补充吧