JDBC Ordeal:应该不那么困难(部分已解决，新错误) [英] JDBC Ordeal: it shouldn't be that difficult (Partial Solved, New Errors)

问题描述

大约2个月以来，我一直在尝试使扩展库的JDBC部分与我们的Oracle数据库一起使用.我已经解决了各种问题和误解.

I have been trying to get the JDBC portion of the Extension library to work with our Oracle databases now for about 2 months. I've worked through various issues and misunderstandings.

当前，我可以运行扩展库附带的示例数据库，而没有明显的问题.但是，它不喜欢我的Oracle设置.我的jdbc文件是ojdbc14.jdbc，我使用ojdbc14作为连接名.

Currently, I can run the sample database that comes with the Extension Library with no apparent issues. But, it doesn't like something about my Oracle setup. My jdbc file is ojdbc14.jdbc and I am using ojdbc14 as my connection name.

我将ojdbc14.jdbc文件放在包资源管理器的WEB-Inf文件夹中.我将ojdbc14.jar文件放入客户端计算机的Notes\jvm\lib\ext文件夹中，并将ojdbc.jar文件放入服务器的Lotus/Domino/notedev/domino/workspace/applications/eclipse/plugins文件夹中.

I put the ojdbc14.jdbc file in the WEB-Inf folder in the package explorer. I put the ojdbc14.jar file in the Notes\jvm\lib\ext folder of my client computer and put the ojdbc.jar file in the Lotus/Domino/notedev/domino/workspace/applications/eclipse/plugins folder of the server.

这是我的jdbc文件:

Here's my jdbc file:

<jdbc>
    <driver>oracle.jdbc.Driver.OracleDriver</driver>
    <url>jdbc:oracle:thin://irmsrv81:1600:pt40/CMIS</url>
    <user>UserName</user>
    <password>Password</password>
</jdbc>

当我预览我的简单视图xpage时，我得到:

When I preview my simple view xpage I get:

读取相关数据时出错 comp/env/jdbc/ojdbc14

Error while reading the relational data comp/env/jdbc/ojdbc14

，然后在堆栈跟踪中出现以下错误:

and then in the Stack trace I get these errors:

com.ibm.xsp.FacesExceptionEx: Error while reading the relational data

java.sql.SQLException

javax.naming.NameNotFoundException: comp/env/jdbc/ojdbc14

这是我的viewPanel1的sqlQuery属性:

Here is my sqlQuery property of my viewPanel1:

select * from CMIS.VCOLLECTION

我是组织中的一员，他一直在努力捍卫XPages作为我们Web开发的未来，并于4月进行了一次大型演示. JDBC是该演示文稿的重要组成部分，也是我们公司XPages未来的关键问题.如果有人可以提供帮助，我将永远很棒.

I am the person in our organization that is trying to champion XPages as the future of our web development and have a huge demostration presentation in April. JDBC is a significant piece of that presentation and a pivotal issue with the future of XPages at our company. If anyone can help, I would be eternally greatful.

UPDATE - New Errors:

我让管理员将上述路径添加到服务器的默认路径，现在我相信它正在查看我的jar文件.但是，我遇到了一系列新的错误:

I had my admin add the path above to the default path of the server and now I believe it is seeing my jar file. However, I'm getting a new set of errors:

Exception
Error while reading the relational data
Error while loading connection ojdbc14
Error parsing XML stream
InputStream cannot be null

然后从堆栈跟踪中查找

com.ibm.xsp.FacesExceptionEx: Error while reading the relational data
java.sql.SQLException
com.ibm.designer.runtime.resources.ResourceFactoriesException: Error while loading connection ojdbc14
com.ibm.commons.xml.XMLException: Error parsing XML stream

知道这些是什么意思吗?

Any idea what these mean?

推荐答案

根据此处的问题和其他相关问题(

Based on your question here and your other related question ( JDBC installed, but getting error trying to connect to Oracle ) it sounds like you need to add the ojdbc14.jar file to the jvm\lib\ext folder on the server (or somewhere else where the server can see it).

这篇关于JDBC Ordeal:应该不那么困难(部分已解决，新错误)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！