cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Guettler <guet...@interface-business.de>
Subject SQL Processor does nothing
Date Tue, 18 Apr 2000 13:57:12 GMT
I tried a simple sql example, 
but cocoon returns my nearly the
same file, without executing the
query.

I tried to activate all possible
logging info but all I got was:
[18/04/2000 15:51:08:518 CEST] [org.apache.cocoon.Engine@687609293]
Starting request
[18/04/2000 15:51:08:520 CEST] [org.apache.cocoon.Engine@687609293]
Creating page
[18/04/2000 15:51:08:534 CEST] [org.apache.cocoon.Engine@687609293]
Document produced
[18/04/2000 15:51:08:551 CEST] [org.apache.cocoon.Engine@687609293]
Document formatted
[18/04/2000 15:51:08:566 CEST] [org.apache.cocoon.Engine@687609293]
response sent to client

Cocoon sql-processor is enabled, and the path to jdbc-driver is set.
But when I remove the jdbc-driver I get the same result.

How can I get more logging-info to see what's wrong?

(I am using cocoon1.7.2 on linux)

--- xml-file ---
<?xml version="1.0"?>
<?cocoon-process type="sql"?>
<?cocoon-format type="text/xml"?>

<page>

 <connectiondefs>
  <connection name="address_con">
   <driver>org.gjt.mm.mysql.Driver</driver>
   <dburl>jdbc:mysql://localhost/xml</dburl>
   <username>guettli</username>
   <password>xxxxxx</password>
  </connection>
 </connectiondefs> 
 
 <query connection="address_con">
  select id, firstname, lastname from person
 </query>
 
</page>

--- xml-file returned

<?xml version="1.0" encoding="UTF-8"?>
<page>

 <connectiondefs>
  <connection name="address_con">
   <driver>org.gjt.mm.mysql.Driver</driver>
   <dburl>jdbc:mysql://localhost/xml</dburl>
   <username>guettli</username>
   <password>xxxxxx</password>
  </connection>
 </connectiondefs> 
 
 <query connection="address_con">
  select id, firstname, lastname from person
 </query>
 
</page>

<!-- This page was served in 182 milliseconds by Cocoon 1.7.2 -->

Mime
View raw message