Return-Path: <knyasa@efavorites.com>
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 30131 invoked from network); 1 Aug 2000 22:15:21 -0000
Received: from bounce.harvard.net (140.239.141.158)
  by locus.apache.org with SMTP; 1 Aug 2000 22:15:21 -0000
Received: from q.harvard.net (q.harvard.net [140.239.141.140])
	by bounce.harvard.net (8.11.0/8.10.1) with ESMTP id e71MFId06893
	for <cocoon-dev@xml.apache.org>; Tue, 1 Aug 2000 18:15:18 -0400
Received: from knyasa (wks99.efavorites.com [64.55.78.99] (may be forged))
	by q.harvard.net (8.11.0/8.10.1) with SMTP id e71MEcB20950
	for <cocoon-dev@xml.apache.org>; Tue, 1 Aug 2000 18:14:38 -0400
Reply-To: <knyasa@efavorites.com>
From: "K N Yasa" <knyasa@efavorites.com>
To: <cocoon-dev@xml.apache.org>
Subject: Its Urgent! Please..
Date: Tue, 1 Aug 2000 18:14:07 -0500
Message-ID: <000401bffc0e$31d30d40$a000a8c0@corp.efavorites.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

Hi Folks,

Environment: Weblogic,cocoon, java 1.2,Oracle8i,NT

1.  if I use SQLprocessor in writing in XSP,  does it causes to any
traffic??? how does it handle the http request.
2.  I want to avoid calling ejbs(basically fetching data from database) in
to XSP, what do you suggest????
3.  I am plannig to implement cocoon stuff in Weblogic 5.1, any suggestions
please??


we plannng to take a decision on implementing cocoon at our site, please
mail me back if anybody knows above..


here I have enclosed an example xsp which we are expecting to write:

<?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"?>

<xsp:page
  language="java"
  xmlns:sql="http://www.apache.org/1999/SQL"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core">

  <page title="SQL Search Results">
  <sql:execute-query>
  <sql:driver>weblogic.jdbc.oci.Driver</sql:driver>
  <sql:dburl>jdbc:weblogic:oracle:xxxxl:dburl>
     <sql:username> scott</sql:username>
     <sql:password>password</sql:password>
  <sql:tag-case>lower</sql:tag-case>
  <sql:null-indicator>yes</sql:null-indicator>
  <sql:doc-element>ROWSET</sql:doc-element>
  <sql:id-attribute-column>none</sql:id-attribute-column>
  <sql:query>select member_first_name from member where member_first_name
like '<xsp:expr>request.getParameter("search")</xsp:expr>%'</sql:query>
  <sql:count-attribute>nome</sql:count-attribute>
  </sql:execute-query>
  </page>
</xsp:page>


thanks
KN YASA