Return-Path: X-Original-To: apmail-cocoon-users-archive@www.apache.org Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AB2889183 for ; Thu, 22 Mar 2012 10:14:23 +0000 (UTC) Received: (qmail 38490 invoked by uid 500); 22 Mar 2012 10:14:23 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 38449 invoked by uid 500); 22 Mar 2012 10:14:23 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org List-Id: Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 38440 invoked by uid 99); 22 Mar 2012 10:14:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Mar 2012 10:14:23 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of pdechandol@ajlsm.com designates 87.98.178.36 as permitted sender) Received: from [87.98.178.36] (HELO mo3.mail-out.ovh.net) (87.98.178.36) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Mar 2012 10:14:13 +0000 Received: from mail437.ha.ovh.net (b9.ovh.net [213.186.33.59]) by mo3.mail-out.ovh.net (Postfix) with SMTP id 160A8FFBB68 for ; Thu, 22 Mar 2012 11:13:58 +0100 (CET) Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 22 Mar 2012 12:13:50 +0200 Received: from 179.167.84.77.rev.sfr.net (HELO ?192.168.1.26?) (pdechandol@ajlsm.com@77.84.167.179) by ns0.ovh.net with SMTP; 22 Mar 2012 12:13:47 +0200 From: =?iso-8859-1?Q?Patricia_D=E9chandol?= Mime-Version: 1.0 (Apple Message framework v1251.1) Content-Type: multipart/alternative; boundary="Apple-Mail=_81C6C34C-1C0E-41BC-BED5-95B9F2083ABB" X-Ovh-Mailout: 178.32.228.3 (mo3.mail-out.ovh.net) Subject: Re: Problem with query in Cocoon Date: Thu, 22 Mar 2012 11:13:47 +0100 In-Reply-To: To: users@cocoon.apache.org References: <927C66C0775CCA43B88EB1E3006614B30691EEF0@eu1rdcrdc1wx032.exi.nxp.com> <927C66C0775CCA43B88EB1E3006614B30691EF35@eu1rdcrdc1wx032.exi.nxp.com> <77348B06-1F9F-4DCE-BC03-661B0E4B6CAC@ajlsm.com> <927C66C0775CCA43B88EB1E3006614B30691EF8C@eu1rdcrdc1wx032.exi.nxp.com> Message-Id: <6BE9A7CE-9323-4091-B409-137219A143E3@ajlsm.com> X-Mailer: Apple Mail (2.1251.1) X-Ovh-Tracer-Id: 18112070327703082650 X-Ovh-Remote: 77.84.167.179 (179.167.84.77.rev.sfr.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-OVH-SPAMSTATE: OK X-OVH-SPAMSCORE: 0 X-OVH-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrfeegvddrgeelucetggdotefuucfrrhhofhhilhgvmecuqfggjfenuceurghilhhouhhtmecufedttdenucenucfhrhhomheprfgrthhrihgtihgrpgffrogthhgrnhguohhluceophguvggthhgrnhguohhlsegrjhhlshhmrdgtohhmqeenucfjughrpefhgggtufffjgfvfhfkofesrgdtreerhhdtje X-Spam-Check: DONE|U 0.5/N X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrfeegvddrgeelucetggdotefuucfrrhhofhhilhgvmecuqfggjfenuceurghilhhouhhtmecufedttdenucenucfhrhhomheprfgrthhrihgtihgrpgffrogthhgrnhguohhluceophguvggthhgrnhguohhlsegrjhhlshhmrdgtohhmqeenucfjughrpefhgggtufffjgfvfhfkofesrgdtreerhhdtje X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_81C6C34C-1C0E-41BC-BED5-95B9F2083ABB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Yeah !!! My problem is resolved=E2=80=A6 the only problem is that I don't know = exactly how !!! I change the place of my pipeline (another site map), declared many = things in my sitemap. When the error occurred, it seems that the pipeline called whas = interacting with another one provocating the error. Now I can call the query generated page and get the xml result. Thanks for your help Robby. Patricia Le 22 mars 2012 =C3=A0 09:50, Patricia D=C3=A9chandol a =C3=A9crit : >=20 > Le 22 mars 2012 =C3=A0 09:44, Robby Pelssers a =C3=A9crit : >=20 >> Ok. If you would have dropped that code base on my shoulders I would = do following checks: >> =20 >> 1) Check if that @src for the xquery generator picks up that file = correctly. Easiest way would be to just replace the original pattern = with this >> =20 >> >> >> >=20 > Yes, I'll try this immediately. >=20 >> =20 >> 2) Next I would check if there was any other pattern also using the = xquery generator that actually works. If it=E2=80=99s in the same = sitemap, you already know that the generator is configured correctly. >=20 > This pattern is the first time in the project I try to use xquery. So = I can't check this point. >=20 >> 3) Definitely try out the query from some XML DB tool (I know there = are a few for Sedna, so there must be also for Exist probably). Or you = just paste that query in the exist play ground web app >=20 > The query is OK. I checked it executing it directly on my eXist client = server. >=20 >> 4) the logs are of course very important but I don=E2=80=99t see any = connectivity issue or authentication error >=20 > The Tomcat and application logs don't see any trace. >=20 > Thanks Robby. Keep on touch about this. >=20 > Patricia >=20 >> =20 >> Robby >> =20 >> =20 >> From: Patricia D=C3=A9chandol [mailto:pdechandol@ajlsm.com]=20 >> Sent: Thursday, March 22, 2012 9:31 AM >> To: users@cocoon.apache.org >> Subject: Re: Problem with query in Cocoon >> =20 >> Yes, that's exactly what you understood. >> I tested with a simplified query. >> I guessed that the resulting xml if malformed, that's why I tested = with "" only response. >> So I wonder if the problem may be in my sitemap in the called = pipeline. >> But I can't see error. >> =20 >> I go on thinking about it. >> Will give you news if I have another idea ! >> =20 >> Patricia >> =20 >> Le 22 mars 2012 =C3=A0 09:24, Robby Pelssers a =C3=A9crit : >>=20 >>=20 >> The error message seems obvious although my French is a bit out of = date ;-) >> =20 >> The query does not return xml and hence you run into this exception. = I also noticed you set a parent-id parameter but it=E2=80=99s not used = in your query. I guess that=E2=80=99s because you simplified the xquery. = As I can=E2=80=99t test for you if that xquery does indeed return a = valid XML result it=E2=80=99s a bit hard to pinpoint the exact issue. = The only sensible thing to do is to first write a >> parameterless xquery and make sure it returns results. Next try that = same xquery with the xquery generator. But from the looks of it you = already tried this?! >> =20 >> Robby >> =20 >> From: Patricia D=C3=A9chandol [mailto:pdechandol@ajlsm.com]=20 >> Sent: Thursday, March 22, 2012 9:14 AM >> To: users@cocoon.apache.org >> Subject: Re: Problem with query in Cocoon >> =20 >> Thanks Robby >> I will try it but I have already tried this : >> =20 >> xquery version "1.0"; >> (: $Id: get-children-rubriques.xq 12373 2008-10-15 14:41:34Z = pdechandol $ :) >> =20 >> (: XQuery qui retourne la collection de notices Bmgexporub li=C3=A9= e =C3=A0 une notice parent :) >> =20 >> let $rubriques :=3D = fn:collection('Bmgexporub')/record[lien_rubrique_parent=3D'Bmgexporub-0000= 002'] >> return >> >> >> =20 >> and it failed with the same error. >> =20 >> I wonder if it's the .xq which makes problem or something somewhere = else in cocoon. >> My xquery gives results when I execute it from eXist graphic java = client. >> =20 >> Patricia >> =20 >> =20 >> Le 22 mars 2012 =C3=A0 09:08, Robby Pelssers a =C3=A9crit : >>=20 >>=20 >>=20 >> You might give this a try: >> =20 >> xquery version "1.0"; >> (: $Id: get-children-rubriques.xq 12373 2008-10-15 14:41:34Z = pdechandol $ :) >> =20 >> (: XQuery qui retourne la collection de notices Bmgexporub li=C3=A9= e =C3=A0 une notice parent :) >> =20 >> let $rubriques :=3D = fn:collection('Bmgexporub')/record[lien_rubrique_parent=3D'Bmgexporub-0000= 002'] >> return >> >> { >> for $rubrique in $rubriques >> return $rubrique >> } >> >> =20 >> Robby >> =20 >> =20 >> From: Patricia D=C3=A9chandol [mailto:pdechandol@ajlsm.com]=20 >> Sent: Wednesday, March 21, 2012 12:22 PM >> To: users@cocoon.apache.org >> Subject: Problem with query in Cocoon >> =20 >> Hi everybody, >> =20 >> new problem ! >> =20 >> I try to execute query from cocoon >> =20 >> I declared a xquery generator in my sitemap : >> =20 >> > collection=3D"xmldb:exist://localhost:8899/exist/xmlrpc/db" >> user=3D"admin" >> password=3D"admin" >> create-session=3D"false" >> expand-xincludes=3D"false" >> authen=3D"" >> cache-validity=3D"-1" >> /> >> =20 >> I match a pattern corresponding : >> =20 >> >> >> >> >> >> >> =20 >> I prepared the following .xq: >> =20 >> xquery version "1.0"; >> (: $Id: get-children-rubriques.xq 12373 2008-10-15 14:41:34Z = pdechandol $ :) >> =20 >> (: XQuery qui retourne la collection de notices Bmgexporub li=C3=A9= e =C3=A0 une notice parent :) >> =20 >> let $rubriques :=3D = fn:collection('Bmgexporub')/record[lien_rubrique_parent=3D'Bmgexporub-0000= 002'] >> >> return $rubriques >> >> =20 >> Executing the following URL : = http://localhost:8080/bm-grenoble/Bmgexporub/get-children-rubriques.xml?pa= rentid=3DBmgexporub-0000002 >> the response is this one : >> =20 >> Erreur d'analyse XML : aucun =C3=A9l=C3=A9ment trouv=C3=A9 >> Emplacement : = http://localhost:8080/bm-grenoble/Bmgexporub/get-children-rubriques.xml?pa= rentid=3DBmgexporub-0000002 >> Num=C3=A9ro de ligne 1, Colonne 1 : >> =20 >> with the following logs : >> =20 >> >> = Erreur=E2=80=8C=C2=B7d'analyse=E2=80=8C=C2=B7XML :=E2=80=8C=C2=B7aucu= n=E2=80=8C=C2=B7=C3=A9l=C3=A9ment=E2=80=8C=C2=B7trouv=C3=A9=E2=80=8C=C2=B6= Emplacement :=E2=80=8C=C2=B7http://localhost:8080/bm-grenoble/Bmgexpo= rub/get-children-rubriques.xml?parentid=3DBmgexporub-0000002=E2=80=8C=C2=B6= Num=C3=A9ro=E2=80=8C=C2=B7de=E2=80=8C=C2=B7ligne=E2=80=8C=C2=B71,=E2=80=8C= =C2=B7Colonne=E2=80=8C=C2=B71 : >> =E2=80=8C=C2=B6^ >> >> =20 >> I checked that my query request is correct by testing in the eXist = client. >> I can't understand at which level there's an error=E2=80=A6 lo log in = tomcat !!! >> =20 >> Patricia >> =20 >> =20 >> =20 >> =20 >=20 --Apple-Mail=_81C6C34C-1C0E-41BC-BED5-95B9F2083ABB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Yeah !!!
My problem is resolved=E2=80=A6= the only problem is that I don't know exactly how = !!!
I = change the place of my pipeline (another site map), declared many things = in my sitemap.
When the error occurred, it seems that the pipeline = called whas interacting with another one provocating the = error.
Now I can call the query generated page and get the xml = result.

Thanks for your help Robby.

Patricia


Le = 22 mars 2012 =C3=A0 09:50, Patricia D=C3=A9chandol a =C3=A9crit = :


Le 22 mars 2012 =C3=A0 09:44, Robby = Pelssers a =C3=A9crit :

Ok.  If you would = have dropped that code base on my shoulders I would do following = checks:
1) = Check if that @src for the xquery generator picks up that file = correctly. Easiest way would be to just replace the original pattern = with this
map:match pattern=3D  <map:read src=3Dmap:matchYes, = I'll try this immediately.

2) Next I would check if = there was any other pattern also using the xquery generator that = actually works.  If it=E2=80=99s in the same sitemap, you already = know that the generator is configured = correctly.

This pattern is the first time in the project I = try to use xquery. So I can't check this = point.

3) Definitely = try out the query from some XML DB tool   (I know there are a = few for Sedna, so there must be also for Exist probably).  Or you = just paste that query in the exist play ground web = app

The query is OK. I checked it executing it = directly on my eXist client server.

4) the logs = are of course very important but I don=E2=80=99t see any connectivity = issue or authentication = error

The Tomcat and application logs don't see any = trace.

Thanks Robby. Keep on touch about = this.

Patricia

Robby
From: Patricia D=C3=A9chandol = [mailto:pdechandol@ajlsm.com] 
Sent: Thursday, March 22, 2012 = 9:31 AM
To: users@cocoon.apache.org
= Subject: Re: = Problem with query in Cocoon
 
Yes, that's exactly what you = understood.
I tested with a simplified = query.
I guessed that the resulting xml if malformed, that's = why I tested with "<records><records/>" only = response.
So I wonder if the problem may be = in my sitemap in the called = pipeline.
But I can't see = error.
I go on thinking about = it.
Will give you news if I have another idea = !
Patricia
 
Le 22 mars 2012 =C3=A0 09:24, Robby Pelssers a =C3=A9crit= :
The = error message seems obvious although my French is a bit out of date = ;-)
The query does not return xml and hence you run into = this exception.  I also noticed you set a parent-id parameter but = it=E2=80=99s not used in your query. I guess that=E2=80=99s because you = simplified the xquery.  As I can=E2=80=99t test for you if that = xquery does indeed return a valid XML result it=E2=80=99s a bit hard to = pinpoint the exact issue.  The only sensible thing to do is to = first write aRobby
Patricia D=C3=A9chandol = [mailto:pdechandol@ajlsm.com] 
Sent: Thursday, March 22, 2012 = 9:14 AM
To:  Re: Problem with query in = Cocoon
 
I = will try it but I have already tried this = :
 version = "1.0";
(: $Id: = get-children-rubriques.xq 12373 2008-10-15 = 14:41:34Z pdechandol $ = :)
    XQuery qui=  retourne la collection de&nb= sp;notices Bmgexporub li=C3=A9e =C3=A0 <= u>une notice parent = :)
let = $rubriques :=3D = fn:collection('Bmgexporub')/record[lien_rubrique_parent=3D'Bmgex= porub-0000002']
 
and it failed with the same = error.
 
I wonder if it's the .xq = which makes problem or something somewhere else in = cocoon.
My xquery gives results = when I execute it from eXist graphic java = client.
 
 
 
Le 22 mars 2012 =C3=A0 09:08, Robby Pelssers a =C3=A9crit= :
You might give this a = try:
xquery 
(: $Id: get-children-rubriques.xq 12373 = 2008-10-15 14:41:34Z pdechandol $ = :)
(:     XQuery qui retourne la collection de notices Bmgexporub li=C3=A9e =C3=A0 une notice parent = :)
 
let $rubriques :=3D = fn:collection('Bmgexporub')/record[lien_rubrique_parent=3D'Bmgex= porub-0000002']
  = {
    return = $rubrique
  = }
From: Patricia = D=C3=A9chandol [mailto:pdechandol@ajlsm.com] 
Sent: Wednesday, March 21, 2012 = 12:22 PM
To:  Problem with query in = Cocoon