cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sue Spielman" <sue_spiel...@hotmail.com>
Subject SQL Sample query results problem
Date Thu, 19 Jul 2001 20:45:43 GMT

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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message