cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "cib" <cib...@caramail.com>
Subject Esql can't get it starting.
Date Wed, 08 Aug 2001 07:39:56 GMT
Sorry, I'm a true beginner.
Working on Cocoon2, with Tomcat4 on win95.
I'd like to work on an ms-Access97 database (at least to see if everything
works, before going on mysql), but system is just waiting for hours, sending
exception in log files.

  I've put in  c:/Tomcat/Webapps/Cocoon/web-Inf/web.xml
the line :sun.jdbc.odbc.JdbcOdbcDriver

<init-param>
      <param-name>load-class</param-name>
      <param-value>
        <!-- For IBM WebSphere: -->
        com.ibm.servlet.classloader.Handler
        <!-- For Database Driver: -->
        org.hsqldb.jdbcDriver
 <!-- For Odbc Access Driver: -->
 sun.jdbc.odbc.JdbcOdbcDriver
      </param-value>
    </init-param>

I've created a database and put it in c:/Tomcat/Webapps/Cocoon/Tries/try.mdb
and created an odbc Data Source DSNsystem
called "try" and pointing to try.mdb
No username, no password.

My try.xsp looks

<?xml version="1.0" encoding="ISO-8859-1"?>
<page>
 <title>Hello World!</title>
 <content>
  <paragraph>This is my first Cocoon page!</paragraph>
 </content>


<query>
<esql:connection>


   <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
   <esql:dburl>jdbc:odbc:try</esql:dburl>
<esql:execute-query>
   <esql:query>SELECT * FROM Notions WHERE Langue='en';</esql:query>

<esql:results>

    <notions><esql:get-string column="Notion"/></notions>
    <lg><esql:get-string column="Langue"/></lg>

   </esql:results>

   <esql:no-results><error>no results were found</error></esql:no-results>

   <esql:error-results>
     <message><esql:get-message/></message>
     <stacktrace><esql:get-stacktrace/></stacktrace>
   </esql:error-results>

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

</page>

</xsp:page>

The corresponding sitemap.xmap is:

<map:match pattern="try.html">
   <map:generate type="serverpages" src="try.xsp"/>
    <map:transform src="try.xsl"/>
    <map:serialize type="html"/>
      </map:match>

 Where the try.xsl simply gives the html tags and a general apply-templates.

What did I do wrong? I've put a copy of the c:\jdk1.3.1\jre\bin\JdbcOdbc.dll
in my windows/system directory in case.

But I only get lines like

Holding object in memory
Creating new instance

PLease,
if someone can tell me what's going wrong.

Cib

France, Bordeaux, xml and gay pride.


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message