Return-Path: 
 <users-return-65979-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 41556 invoked from network); 15 Apr 2004 18:15:31 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 15 Apr 2004 18:15:31 -0000
Received: (qmail 40540 invoked by uid 500); 15 Apr 2004 18:15:10 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 40503 invoked by uid 500); 15 Apr 2004 18:15:10 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 40479 invoked from network); 15 Apr 2004 18:15:10 -0000
Received: from unknown (HELO pluto.isd-holland.nl) (62.221.254.24)
  by daedalus.apache.org with SMTP; 15 Apr 2004 18:15:10 -0000
Received: from localhost (localhost [127.0.0.1])
	by pluto.isd-holland.nl (Postfix) with ESMTP id 33B602F0309
	for <users@cocoon.apache.org>; Thu, 15 Apr 2004 20:15:14 +0200 (CEST)
Received: from pluto.isd-holland.nl ([127.0.0.1])
 by localhost (pluto [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
 id 11904-04 for <users@cocoon.apache.org>;
 Thu, 15 Apr 2004 20:15:13 +0200 (CEST)
Received: from dds.nl (62-221-202-17.dsl.uwadslprovider.nl [62.221.202.17])
	by pluto.isd-holland.nl (Postfix) with ESMTP id 8130B2F02F2
	for <users@cocoon.apache.org>; Thu, 15 Apr 2004 20:15:13 +0200 (CEST)
Message-ID: <407ED119.3080609@dds.nl>
Date: Thu, 15 Apr 2004 20:14:49 +0200
From: Leon Widdershoven <qaz@dds.nl>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: users@cocoon.apache.org
Subject: Re: ESQl and Stored Procedures
References: <034301c42315$2f9006f0$db40700a@sophia>
In-Reply-To: <034301c42315$2f9006f0$db40700a@sophia>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at isd-holland.nl
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Could it be that the <xsp:expr> embedded in the <xsp:logic> block is the
culprit? I read somwhere that that is not a wise combination. (which is
logical as in an xsp:logic you don't need an xsp:expr).

Please note: I did not try this, and have never used the esql:call. But 
it seems
that all tags are closed - so this might just be it.

You could in stead prepare all your calls in advance in a logic block 
and call on
those strings when needed - outside of the logic block with <xsp:expr>.

Just my 0.02c (and that's not much).

Leon

arlos Dias wrote:

> Hi,
> I'm trying to use a stored procedure for making an update in an Oracle 
> database.
> Here is the xsp+esql code:
> <?xml version="1.0" encoding="iso-8859-1"?>
>  
> <xsp:page
>  language="java"
>  xmlns:xsp="http://apache.org/xsp"
>  xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>  xmlns:esql="http://apache.org/cocoon/SQL/v2">
>  
>  <xsp:structure>
>   <xsp:include>java.lang.String</xsp:include>
>  </xsp:structure>
>  
>  <update>
>   <esql:connection>
>    <esql:pool>sca</esql:pool>
>    <xsp:logic>
>    
>     String   app_id                   = request.getParameter("app_id");
>     String   user_id                  = request.getParameter("user_id");
>     if (app_id != null || user_id != null) {
>    
>      <esql:call>
>       {call bookmark.update_bookmark_list(<esql:parameter 
> direction="in" type="String">\
>                <xsp:expr>user_id</xsp:expr></esql:parameter>,\
>                <esql:parameter direction="in" type="String">\
>                <xsp:expr>app_id</xsp:expr></esql:parameter>)}
>      </esql:call>
>      <esql:call-results>
>      <esql:update-results>
>       <number-of-rows><esql:get-update-count/></number-of-rows>
>      </esql:update-results>
>      </esql:call-results>
>     }
>     else {
>      <exception>Parameters does not exists</exception>
>     }
>  
>    </xsp:logic>
>   </esql:connection>
>  </update>
> </xsp:page>
>  
> I got the following result (in the web page):
>
> XML document must have a top level element. Error processing resource 
> 'http://rasputin:9090/adslV3/cubenavigator/update_bookmark'.
>
>
> In the error.log:
> [core.program-generator] (/adslV3/cubenavigator/update_bookmark) 
> http9090-Processor7/ProgramGeneratorImpl: The serverpage 
> [file:/home/cdias/altaia/tomcat/webapps/adslV3/cubenavigator/generators/dynamic/xsp/update_bookmark_list.xsp] 
> could not be preloaded, will be re-created 
> (org.apache.cocoon.components.language.LanguageException: Unable to 
> preload program 
> org/apache/cocoon/www/cubenavigator/generators/dynamic/xsp/update_bookmark_list_xsp: 
> org.apache.cocoon.components.language.LanguageException: Could not 
> load class for program 
> 'org/apache/cocoon/www/cubenavigator/generators/dynamic/xsp/update_bookmark_list_xsp' 
> due to a java.lang.ClassNotFoundException: 
> org.apache.cocoon.www.cubenavigator.generators.dynamic.xsp.update_bookmark_list_xsp)
>  
> Can anybody tell me what's going on?!
>  
> Thanks in advance,
> Carlos Dias



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org