Return-Path: <sconover@groundswell.net>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 62689 invoked from network); 11 Aug 2000 16:54:47 -0000
Received: from unknown (HELO ftp.groundswell.net) (209.247.197.100)
  by locus.apache.org with SMTP; 11 Aug 2000 16:54:47 -0000
Received: from pls-prod-04.behrman (smtp.groundswell.net [209.247.197.102])
	by ftp.groundswell.net (8.11.0/8.11.0) with ESMTP id e7BGrdK26582
	for <cocoon-users@xml.apache.org>; Fri, 11 Aug 2000 09:53:39 -0700 (PDT)
Received: by smtp.behrmanic.com with Internet Mail Service (5.5.2650.21)
	id <QS7FL9P0>; Fri, 11 Aug 2000 09:52:35 -0700
Message-ID: <55E3AD611343D411900F00D0B7848ACB029D0F@smtp.behrmanic.com>
From: Steve Conover <sconover@groundswell.net>
To: "'cocoon-users@xml.apache.org'" <cocoon-users@xml.apache.org>
Subject: RE: second try -- trying to make sql evaluate instead of just   p
	assingthru sql tags
Date: Fri, 11 Aug 2000 09:52:35 -0700
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

ok that worked.  I changed the order of the stylesheets...I have no =
idea why
that cured the weird error I was getting (and would like to understand =
why
if someone knows).

Then I put my query back in the taglib, adjusted the namespace order in =
the
taglib, but I'm getting the same error as before:

java.lang.Exception: XSP Java Compiler: Compilation failed for
_uploadform.java
66: Undefined variable, class, or package name: org

    org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary

    ^

1 error



here's my tablib now (the sql statement wraps because of the email =
format -
it's all one line in my file)

<?xml version=3D"1.0"?>

<xsl:stylesheet version=3D"1.0"
  xmlns:user=3D"http://www.groundswell.net/2000/XSP/User"
  xmlns:sql=3D"http://www.apache.org/1999/SQL"
  xmlns:xsl=3D"http://www.w3.org/1999/XSL/Transform"
  xmlns:xsp=3D"http://www.apache.org/1999/XSP/Core"
>


  <xsl:template match=3D"xsp:page">
   =20
    <xsl:processing-instruction
name=3D"cocoon-process">type=3D"xsp"</xsl:processing-instruction>
    <xsl:processing-instruction
name=3D"cocoon-process">type=3D"xslt"</xsl:processing-instruction>
    <xsl:processing-instruction =
name=3D"xml-stylesheet">href=3D"upload.xsl"
type=3D"text/xsl"</xsl:processing-instruction>

    <xsp:page language=3D"java"
xmlns:xsp=3D"http://www.apache.org/1999/XSP/Core"
xmlns:sql=3D"http://www.apache.org/1999/SQL">
        <test>
            <xsl:apply-templates/>
        </test>
    </xsp:page>
  </xsl:template>

  <xsl:template match=3D"user:basicprofile">
     <sql:execute-query>
	<sql:driver>oracle.jdbc.driver.OracleDriver</sql:driver>
	<sql:dburl>jdbc:oracle:thin:@pls-prod-01:1521:prod01</sql:dburl>
        <sql:username>portal</sql:username>
        <sql:password>portal</sql:password>
	<sql:doc-element>users</sql:doc-element>
	<sql:row-element>user</sql:row-element>
	<sql:tag-case>lower</sql:tag-case>
	<sql:null-indicator>yes</sql:null-indicator>
	<sql:id-attribute>empid</sql:id-attribute>
	<sql:id-attribute-column>empid</sql:id-attribute-column>
	<sql:query>select fname, lname from employee_t where
empid=3D<xsp:expr>request.getParameter("userid")</xsp:expr></sql:query>
        <sql:count-attribute>count</sql:count-attribute>
     </sql:execute-query>
  </xsl:template>

  <xsl:template match=3D"@*|node()" priority=3D"-1">
    <xsl:copy><xsl:apply-templates select=3D"@*|node()"/></xsl:copy>
  </xsl:template>

</xsl:stylesheet>



> -----Original Message-----
> From: Sebastien Koechlin [mailto:skoechlin@ivision.fr]
> Sent: Friday, August 11, 2000 10:46 AM
> To: cocoon-users@xml.apache.org
> Subject: Re: second try -- trying to make sql evaluate instead of =
just
> passingthru sql tags
>=20
>=20
> Steve Conover wrote:
>=20
> > I tried putting everything in the same document, and I get=20
> this error:
> >
> > Error found handling the request.
> > java.lang.Exception: XSP Java Compiler: Compilation failed for
> > _uploadform.java
>=20
> You have a problem with
>     xmlns:user=3D"http://www.groundswell.net/2000/XSP/User"
>=20
>=20
> > <?xml version=3D"1.0"?>
> >
> > <?cocoon-process type=3D"xsp"?>
> >
> > <xsp:page
> >     language=3D"java"
> >     xmlns:user=3D"http://www.groundswell.net/2000/XSP/User"
> >     xmlns:xsp=3D"http://www.apache.org/1999/XSP/Core"
> >       xmlns:sql=3D"http://www.apache.org/1999/SQL"
> > >
>=20
> Can you remove the 'user' namespace, you don't need it anymore.
> Also think about swapping xsp and sql as stylesheet are applied
> one by one in order.
>=20
>=20
> >         <sql:query>select fname, lname from employee_t where
> >=20
> =
empid=3D<xsp:expr>request.getParameter("userid")</xsp:expr></sql:query>
>=20
> Make sure you wrote your query on a single line as Java does
> not allow multi-line string.
>=20
> --
> S=E9bastien Koechlin
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>=20