title: XPages REST Service with JDBC data
body: <p>I am trying to get the REST Service Data Access control to work with some JDBC data.  Eventually, this will all go in  a Dojo Datagrid.  But somehow, I can't make it work and I can't figure out what is wrong.   </p>
  
  <p>Here is the code I have:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;xp:view xmlns:xp="http://www.ibm.com/xsp/core"
      xmlns:xe="http://www.ibm.com/xsp/coreex"&gt;
  
      &lt;xe:restService id="restService1" pathInfo="results"&gt;
          &lt;xe:this.service&gt;
              &lt;xe:jdbcQueryJsonService contentType="application/json"
                  connectionName="oracle"&gt;
                  &lt;xe:this.sqlQuery&gt;&lt;![CDATA[select postal_code, province cifadmin.postal_code_search_mv where postal_code='J6Y1R4'"]]&gt;&lt;/xe:this.sqlQuery&gt;
              &lt;/xe:jdbcQueryJsonService&gt;
          &lt;/xe:this.service&gt;
      &lt;/xe:restService&gt;
  
  &lt;/xp:view&gt;
  </code></pre>
  
  <p>All I get is an error 500 when I access the page with the /results, and I don't have access to the log.nsf, so no clue to what is going on.  Database table and columns names are valid.</p>
  
  <p>Can anyone shed a bit of light on this?</p>
  
  <p>As usual, thansk for your help.</p>