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 start on C2
Date Wed, 08 Aug 2001 17:19:14 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.


Mime
View raw message