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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
