esql database error

[davide semprini <se...@hotmail.com>]

hi,
I have a problem,
when I connect with my database using sql processor and
sql connection pool is ok I can do query and receive results,
but when I use esql and error occurs, why?

My thin driver oracle is installed correctly,
my cocoon properties file is:



# Set the libraries associated with the given namespace.
# Use the syntax:
#   processor.xsp.logicsheet.<namespace-tag>.<language> = URL to file
# where "URL to file" is usually starting with file:// if you locate
# your custom library in your file system.
processor.xsp.logicsheet.context.java  = 
resource://org/apache/cocoon/processor/xsp/library/java/context.xsl
processor.xsp.logicsheet.cookie.java   = 
resource://org/apache/cocoon/processor/xsp/library/java/cookie.xsl
processor.xsp.logicsheet.global.java   = 
resource://org/apache/cocoon/processor/xsp/library/java/global.xsl
processor.xsp.logicsheet.request.java  = 
resource://org/apache/cocoon/processor/xsp/library/java/request.xsl
processor.xsp.logicsheet.response.java = 
resource://org/apache/cocoon/processor/xsp/library/java/response.xsl
processor.xsp.logicsheet.session.java  = 
resource://org/apache/cocoon/processor/xsp/library/java/session.xsl
processor.xsp.logicsheet.util.java     = 
resource://org/apache/cocoon/processor/xsp/library/java/util.xsl
processor.xsp.logicsheet.sql.java      = 
resource://org/apache/cocoon/processor/xsp/library/sql/sql.xsl
processor.xsp.logicsheet.esql.java     = 
resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl
processor.xsp.logicsheet.fp.java       = 
resource://org/apache/cocoon/processor/xsp/library/fp/fp.xsl


and my file:

<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core">
  <page>
    <esql:connection>
      <esql:dburl>jdbc:oracle:thin:@*******:1521:***</esql:dburl>
      <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
      <esql:username>******</esql:username>
      <esql:password>******</esql:password>
      <esql:execute-query>
     <esql:query>select * from dati</esql:query>

     <esql:results>
       <esql:row-results>
       <nome><esql:get-string column="profile"/></nome>
       </esql:row-results>
      </esql:results>

       <esql:no-results>
       <blanco>No results returned</blanco>
       </esql:no-results>
       <esql:error-results>
       <error>there was a database error</error>
       </esql:error-results>

     </esql:execute-query>
</esql:connection>
</page>
</xsp:page>

an error occurs:


there was a database error

anybody can help me!!!

tanks a lot

_____________________________________________________________________________________
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com