Hello Everybody .... I am having problems with integrating my application using Cocoon 2.1.2 and MySQL 3.23.58. I read a lot of questionaries realted to this topic but could not find anything reletaing to the problem I am having . lets start with the environment in which I am working.
System Specification: ------------------------- 1) Cocoon 2.1.2 -> downloaded the latest source version and installed using 1) Building cocoon using "build" 2) Running cocoon using "./cocoon.sh cli" 3) http://ip-add:8888 points to the welcome page of cocoon 2) MySQL 3.23.58 3) JDK 1.4.0 4) Apache 2.0.43 5) Tomcat 4.0.4b1 Following is the step by step procedure I followed trying to build an application to access database: Steps: -------- 1) copy the driver jar ( mm.mysql-2.0.13-bin.jar) file in cocoon-context:/build/webapp/WEB-INF/lib 2) Defined a MySQL datasource in web.xml <init-param> <param-name>load-class</param-name> <param-value> <!-- For parent ComponentManager sample: --> org.apache.cocoon.samples.parentcm.Configurator <!-- For IBM WebSphere: --> com.ibm.servlet.classloader.Handler <!-- For HSQLDB Database Driver: --> org.hsqldb.jdbcDriver <!-- For MYSQL Database Driver (included by me) --> org.gjt.mm.mysql.Driver </param-value> </init-param> 3) Add a connection to MySQL in cocoon.xconf <jdbc logger="core.datasources.adhportal" name="adhportal"> <pool-controller max="10" min="5"/> <dburl>jdbc:mysql://portal.cis.umassd.edu/adh</dburl> <user>adh</user> <password>password</password> </jdbc> 4) Include pipeline in sitemap.xmap <map:match pattern="sqldocument"> <map:generate src="sql/sqlexample.xml"/> <map:transform type="sql"> <map:parameter name="use-connection" value="adhportal"/> </map:transform> <map:transform type="log"> <map:parameter name="logfile" value="logfile.log"/> <map:parameter name="append" value="no"/> </map:transform> <map:transform src="sql/sqlexample.xsl"/> <map:serialize type="xml"/> </map:match> 5) XML file looks like this: <?xml version="1.0"?> <document> <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <sql:use-connection>adhportal</sql:use-connection> <sql:query> select * from emp </sql:query> </sql:execute-query> </document> 6) XSL looks something like this: <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <xsl:template match="document"> <html><body><table> <xsl:apply-templates select="sql:rowset/sql:row"/> </table></body></html> </xsl:template> <xsl:template match="sql:row"> <tr> <xsl:apply-templates/> </tr> </xsl:template> <xsl:template match="sql:empNo"> <td> <xsl:value-of select="."/> </td> </xsl:template> <xsl:template match="sql:empName"> <td> <xsl:value-of select="."/> </td> </xsl:template> <xsl:template match="sql:empSal"> <td> <xsl:value-of select="."/> </td> </xsl:template> </xsl:stylesheet> But insted of the expected outout in the form of Rows fetched from the table , I get a blank page, and following is the message I get in the logfile.log file : ================================================================================================ [[setup] ---------------------------- [Fri May 07 12:32:09 EDT 2004] ---------------------------- [setDocumentLocator] systemid=file:/home/g_snanda/cocoon-2.1.2/build/webapp/sql/sqlexample.xml,publicid=null [startDocument] [startElement] uri=,local=document,raw=document [characters] [startPrefixMapping] prefix=sql,uri=http://apache.org/cocoon/SQL/2.0 [characters] [characters] [characters] [startPrefixMapping] prefix=,uri=http://apache.org/cocoon/SQL/2.0 [startElement] uri=http://apache.org/cocoon/SQL/2.0,local=rowset,raw=rowset [startElement] uri=http://apache.org/cocoon/SQL/2.0,local=error,raw=error [characters] Failed to obtain connection. Made 5 attempts with 5000ms interval [endElement] uri=http://apache.org/cocoon/SQL/2.0,local=error,qname=error [endElement] uri=http://apache.org/cocoon/SQL/2.0,local=rowset,qname=rowset [endPrefixMapping] prefix= [endPrefixMapping] prefix=sql [characters] [endElement] uri=,local=document,qname=document [endDocument] ================================================================ Can anyone figure it out whats wrong ??? Thanks in advance and let me know if you need anything else. Looking forward for your help With Regards Sam
