cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wong Shin Neng" <>
Subject Re: SQLProcessor error
Date Fri, 11 Aug 2000 07:01:44 GMT

I basically modified the example file database-page.xml accordingly to connect to a postgresql
database.  The JDBC driver is in place because it works with the XSP SQL taglib example.

Namespace?  I'm not too sure.  The documentation of the SQL Processor did not mention any
specific namespace.  The xml document produced is shows the SQL select statement instead.
 But the <connectiondefs> seems to be processed.   What's happening?

  ----- Original Message ----- 
  From: KN Yasa 
  To: '' 
  Sent: Friday, August 11, 2000 5:44 AM
  Subject: RE: SQLProcessor error

  Hi Shin,

  I guess it might help you, if you could go through how to create and implementation of tag
libraries and name spaces. 
  kn yasa

    -----Original Message-----
    From: Wong Shin Neng []
    Sent: Thursday, August 10, 2000 5:37 AM
    Subject: Re: SQLProcessor error


    I'm also experiencing the same problem as Nadine when using the SQL processor.  However,
when using the XSP SQL Taglib, it works.  Why is this so?  Anybody got answers?

    Thanks in advance

    Shin Neng
      ----- Original Message ----- 
      From: KN Yasa 
      To: '' 
      Sent: Friday, August 04, 2000 9:36 PM
      Subject: RE: SQLProcessor error

      Hi Nadine--
      I guess this code might help you:
      <?xml version="1.0"?>
      <?cocoon-process type="xsp"?>
      <?cocoon-process type="sql"?>
      <?cocoon-process type="xslt"?>
      <?xml-stylesheet href="xsl/favsearch.xsl" type="text/xsl"?>


        <page title="SQL Search Results">
        <sql:query>select member_first_name from member where member_first_name like
      If you have any specific questions, I will be very happy to answer you..
      K N Yasa
        -----Original Message-----
        From: Nadine Carlton []
        Sent: Thursday, August 03, 2000 7:10 PM
        Subject: SQLProcessor error


          I've just installed Cocoon.  I have the Cocoon.xml status page coming back
        and the hello-page.xml works as well.  Unfortunately, I'm having trouble getting
        the database-page.xml working.  I have updated the connection information
        and the query for my NT 8.1.5 Oracle database to access the demo emp table, but 
        the returned page in the browser displays "select * from emp".
        The xml looks like:
        <?xml version="1.0"?>

        <?cocoon-process type="sql"?>


        <connection name="evue_customer_connection">







        <sqlerror message="The database connection failed."/>

        <query connection="evue_customer_connection">

        select * from emp



        I turned on debug in the file, but there are no 

        errors there.  The jdbc and cocoon libraries are in my wrapper.classpath also. What

        else can I do to debug this?

        Nadine Carlton 

View raw message