If someone can offer any insight, it would be most appreciated.
I am running C2.0b1 from the distribution on Win98 with a mySql db and
tomcat 3.2.1
I am trying to get the sample Simple SQL from the welcome page to run
correctly. I can access it, but the query results are not displaying. My
database is configured with the correct tables and I've confirmed the data
is there correctly. I have granted all access to the 'sa' user. I'm
including the snippet of my cocoon.xconf, as well as my web.xml that
contains my jdbc driver (which seems to be loading correctly), and the
tomcat log. Any thoughts on what might be causing this would be very
helpful, especially if it's a mySql config issue. I'm in the process of
setting up a different application that will use similiar mechanisms, but
want to confirm everything working correctly with the samples first. Thanks.
Sue
Cocoon.xconf snippet
----cut---
<datasources>
<jdbc name="personnel">
<pool-controller min="5" max="10"/>
<auto-commit>false</auto-commit>
<dburl>jdbc:mysql://localhost/test</dburl>
<user>sa</user>
<password></password>
</jdbc>
</datasources>
----cut----
web.xml snippet
<init-param>
<param-name>load-class</param-name>
<param-value>org.gjt.mm.mysql.Driver</param-value>
</init-param>
>From tomcat/log
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Making URL from
file:/C:/Java/tomcat/webapps/cocoon/docs/samples/sql/sql-page.xml
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
CONNECTION: personnel
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Making URL from
file:/C:/Java/tomcat/webapps/cocoon/stylesheets/simple-sql2html.xsl
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Using stylesheet:
'file:/C:/Java/tomcat/webapps/cocoon/stylesheets/simple-sql2html.xsl' in
org.apache.cocoon.transformation.TraxTransformer@b74ae1c6, last modified:
995571904000
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Caching content for further requests of 'sql/sql-page'.
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Retrieving a org.apache.cocoon.components.sax.XMLByteStreamCompiler from the
pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15657 [cocoon ] (Thread-9):
Creating new Templates in
org.apache.cocoon.transformation.TraxTransformer@b74ae1c6 for
file:/C:/Java/tomcat/webapps/cocoon/stylesheets/simple-sql2html.xsl
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
Holding object in memory. Key:
file:/C:/Java/tomcat/webapps/cocoon/stylesheets/simple-sql2html.xsl
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
processing file docs/samples/sql/sql-page.xml
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
file resolved to
file:/C:/Java/tomcat/webapps/cocoon/docs/samples/sql/sql-page.xml
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
ComponentFactory creating new instance of
org.apache.cocoon.components.parser.JaxpParser.
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
SAXParserFactory: null
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
DocumentBuilderFactory: null
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
SAXParser: null
2001-07-19 02:11:26 - path="/cocoon" :INFO 15659 [cocoon ] (Thread-9):
PUBLIC IDnull
2001-07-19 02:11:26 - path="/cocoon" :INFO 15659 [cocoon ] (Thread-9):
SYSTEM IDfile:/C:/Java/tomcat/webapps/cocoon/docs/samples/sql/sql-page.xml
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS: Hello
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS: This is my first Cocoon2 page filled with sql data!
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED START ELEMENT execute-query
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED START ELEMENT query
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
select id,name from department_table
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED END ELEMENT query(http://apache.org/cocoon/SQL/2.0)
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
QUERY IS "
select id,name from department_table
"
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED START ELEMENT execute-query
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED START ELEMENT query
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
select id,name from employee_table where department_id =
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED START ELEMENT ancestor-value
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
ANCESTOR VALUE 1 id
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
QUERY IS "
select id,name from employee_table where department_id = "
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED END ELEMENT ancestor-value(http://apache.org/cocoon/SQL/2.0)
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED END ELEMENT query(http://apache.org/cocoon/SQL/2.0)
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
QUERY IS "
"
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED END ELEMENT execute-query(http://apache.org/cocoon/SQL/2.0)
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
RECEIVED END ELEMENT execute-query(http://apache.org/cocoon/SQL/2.0)
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15659 [cocoon ] (Thread-9):
Retrieving a org.apache.avalon.excalibur.datasource.JdbcConnection from the
pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.avalon.excalibur.datasource.JdbcConnection to the
pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
RECEIVED CHARACTERS:
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
ComponentFactory decommissioning instance of
org.apache.cocoon.components.parser.JaxpParser.
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Holding object in memory. Key: PCK:CCK:1-file-4010331565316940796
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.components.sax.XMLByteStreamCompiler to the
pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Recycling of CachingEventPipeline
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.generation.FileGenerator to the pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.transformation.SQLTransformer to the pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.transformation.TraxTransformer to the pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.components.pipeline.CachingEventPipeline to
the pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Recycling of CachingStreamPipeline
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.serialization.HTMLSerializer to the pool
2001-07-19 02:11:26 - path="/cocoon" :DEBUG 15662 [cocoon ] (Thread-9):
Returning a org.apache.cocoon.components.pipeline.CachingStreamPipeline to
the pool
2001-07-19 02:11:26 - path="/cocoon" :INFO 15662 [cocoon ] (Thread-9):
'sql/sql-page' Processed by Apache Cocoon 2.0b1 in 440 milliseconds.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
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]>
