java - 无法使用 ODI sdk 从远程系统连接到 ODI

Question

我正在尝试使用 java 中的 ODI SDK 连接到 ODI。以下是获取 ODI 实例的代码:

MasterRepositoryDbInfo masterInfo = new MasterRepositoryDbInfo("jdbc:oracle:thin:@ipaddress:1521:xe", "oracle.jdbc.OracleDriver", username, password, new PoolingAttributes());
WorkRepositoryDbInfo workInfo = new WorkRepositoryDbInfo("WORKREP1", new PoolingAttributes());

final OdiInstance odiInstance = OdiInstance.createInstance(new OdiInstanceConfig(masterInfo, workInfo));

我收到以下错误:

Exception in thread "main" oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.  
Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: The Network Adapter could not establish the connection
    at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:195)
    at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:531)
    at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:678)
    at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:609)
    at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:548)
    at com.fe.FT2FT.main(FT2FT.java:66)

我通过创建到同一台计算机的 jdbc 连接来单独检查，并且能够连接。

如果我遗漏了什么，请告诉我。如有任何帮助，我们将不胜感激。

Answer 1

您与主存储库的连接工作正常，问题在于连接到工作存储库。请检查是否

• 您的 WORKREP1 连接已在主存储库中正确定义
• 您可以手动连接到工作存储库

还尝试仅连接到主存储库以查看其是否有效

final OdiInstance odiInstance = OdiInstance.createInstance(new OdiInstanceConfig(masterInfo, null));