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. |