title: JDBC Ordeal: it shouldn't be that difficult (Partial Solved, New Errors)
body: <p>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.</p>
  
  <p>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 <code>ojdbc14.jdbc</code> and I am using <code>ojdbc14</code> as my connection name.</p>
  
  <p>I put the <code>ojdbc14.jdbc</code> file in the <code>WEB-Inf</code> folder in the package explorer.  I put the <code>ojdbc14.jar</code> file in the <code>Notes\jvm\lib\ext</code> folder of my client computer and put the <code>ojdbc.jar</code> file in the <code>Lotus/Domino/notedev/domino/workspace/applications/eclipse/plugins</code> folder of the server.</p>
  
  <p>Here's my jdbc file:</p>
  
  <pre><code>&lt;jdbc&gt;
      &lt;driver&gt;oracle.jdbc.Driver.OracleDriver&lt;/driver&gt;
      &lt;url&gt;jdbc:oracle:thin://irmsrv81:1600:pt40/CMIS&lt;/url&gt;
      &lt;user&gt;UserName&lt;/user&gt;
      &lt;password&gt;Password&lt;/password&gt;
  &lt;/jdbc&gt;
  </code></pre>
  
  <p>When I preview my simple view xpage I get:</p>
  
  <p>Error while reading the relational data
  comp/env/jdbc/ojdbc14</p>
  
  <p>and then in the Stack trace I get these errors:</p>
  
  <pre><code>com.ibm.xsp.FacesExceptionEx: Error while reading the relational data
  
  java.sql.SQLException
  
  javax.naming.NameNotFoundException: comp/env/jdbc/ojdbc14
  </code></pre>
  
  <p>Here is my sqlQuery property of my viewPanel1:</p>
  
  <p><code>select * from CMIS.VCOLLECTION</code></p>
  
  <p>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.</p>
  
  <p><code>UPDATE - New Errors:</code></p>
  
  <p>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:</p>
  
  <pre><code>Exception
  Error while reading the relational data
  Error while loading connection ojdbc14
  Error parsing XML stream
  InputStream cannot be null
  </code></pre>
  
  <p>Then from the Stack Trace:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Any idea what these mean?</p>