Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 3295 invoked from network); 8 May 2006 13:53:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 8 May 2006 13:53:56 -0000 Received: (qmail 60308 invoked by uid 500); 8 May 2006 13:53:50 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 59935 invoked by uid 500); 8 May 2006 13:53:49 -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 59924 invoked by uid 99); 8 May 2006 13:53:48 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 May 2006 06:53:48 -0700 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=HTML_FONT_BIG,HTML_MESSAGE,HTML_TAG_EXIST_TBODY X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [213.133.33.30] (HELO mailrelay.is.nl) (213.133.33.30) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 May 2006 06:53:47 -0700 Received: from [213.133.51.241] (HELO hai01.hippo.local) by mailrelay.is.nl (CommuniGate Pro SMTP 4.3.5) with ESMTP id 16118361 for users@cocoon.apache.org; Mon, 08 May 2006 15:53:25 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C672A6.C670419A" Subject: RE: SQLTransformer problem with cocoon 2.1.7 Date: Mon, 8 May 2006 15:53:24 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SQLTransformer problem with cocoon 2.1.7 Thread-Index: AcZyoY7tdGNDlHlmQtmsrsqT7VjdjwAAD7GwAAE06+A= From: "Ard Schrijvers" To: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------_=_NextPart_001_01C672A6.C670419A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Looks like a namespace problem that after your transform type=3D"jx" = the element belongs to sql namespace. =20 Hi all, =20 I ma trying to use SQL Transformer to execute a query from cocoon. SQL Transformer seems to be working fine with cocoon2.1.5 and when we = port our application from 2.1.5 to cocoon2.1.7=20 We are getting the following exception. SQLTransformer: Not expecting a start value element: page org.apache.cocoon.ProcessingException: Failed to execute pipeline.: = java.lang.IllegalStateException: SQLTransformer: Not expecting a start = value element: page cause: java.lang.IllegalStateException: SQLTransformer: Not expecting a = start value element: page full exception chain stacktrace[hide]=20 org.apache.cocoon.ProcessingException: Failed to execute pipeline.: = java.lang.IllegalStateException: SQLTransformer: Not expecting a start = value element: page=20 at = org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processX= MLPipeline(AbstractProcessingPipeline.java:582)=20 at = org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipel= ine.processXMLPipeline(AbstractCachingProcessingPipeline.java:183)=20 at = org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(= AbstractProcessingPipeline.java:483)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(S= erializeNode.java:120)=20 at = org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i= nvokeNodes(AbstractParentProcessingNode.java:46)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.in= voke(PreparableMatchNode.java:130)=20 at = org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i= nvokeNodes(AbstractParentProcessingNode.java:68)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pi= pelineNode.java:138)=20 at = org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i= nvokeNodes(AbstractParentProcessingNode.java:68)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(P= ipelinesNode.java:92)=20 at = org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(= ConcreteTreeProcessor.java:234)=20 at = org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(= ConcreteTreeProcessor.java:176)=20 at = org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProc= essor.java:243)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(Mount= Node.java:117)=20 at = org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i= nvokeNodes(AbstractParentProcessingNode.java:46)=20 at = org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.in= voke(PreparableMatchNode.java:130)=20 at = org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i= nvokeNodes(AbstractParentProcessingNode.java:68)=20 at org.apache.cocoon.components.treeprocessor.sitemap. =20 Do I need to change anything with the xml which I supply to the sql = transformer. I am constructing an xml with jxtemplate as follows :- =20 =20 =20 imAdmin Select id from temp =20 I have an entry in sitemap.xmap as follows :- =20 =20 I tried to remove the page and see but I got the sql generated by the jx = template back instead of the output query. Please tell me any suggestions for this and also please tell me where I = can find resources with respect to the SQL transformer. =20 Thanks and Regards, Baskar =20 The information contained in this electronic message and any attachments = to this message are intended for the exclusive use of the addressee(s) = and may contain proprietary, confidential or privileged information. If = you are not the intended recipient, you should not disseminate, = distribute or copy this e-mail. Please notify the sender immediately and = destroy all copies of this message and any attachments.=20 WARNING: Computer viruses can be transmitted via email. The recipient = should check this email and any attachments for the presence of viruses. = The company accepts no liability for any damage caused by any virus = transmitted by this email. www.wipro.com =09 ------_=_NextPart_001_01C672A6.C670419A Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 Looks like a=20 namespace problem that after your transform type=3D"jx" the element = <page> belongs to sql namespace.=20  

Hi=20 all,

 

I ma trying = to use=20 SQL Transformer to execute a query from = cocoon.

SQL = Transformer seems=20 to be working fine with cocoon2.1.5 and when we port our application = from=20 2.1.5 to cocoon2.1.7

We are = getting the=20 following exception.

SQLTransformer: Not expecting a start = value element:=20 page

org.apache.cocoon.ProcessingException: = Failed to=20 execute pipeline.: java.lang.IllegalStateException: SQLTransformer: = Not=20 expecting a start value element: = page

cause: java.lang.IllegalStateException:=20 SQLTransformer: Not expecting a start value element: = page

full exception chain=20 stacktrace[hide] 

org.apache.cocoon.ProcessingException: =
Failed to execute pipeline.: java.lang.IllegalStateException: =
SQLTransformer: Not expecting a start value element: page =

      at =
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processX=
MLPipeline(AbstractProcessingPipeline.java:582) =

      at =
org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipel=
ine.processXMLPipeline(AbstractCachingProcessingPipeline.java:183) =

      at =
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(=
AbstractProcessingPipeline.java:483) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(S=
erializeNode.java:120) 
      at =
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i=
nvokeNodes(AbstractParentProcessingNode.java:46) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.in=
voke(PreparableMatchNode.java:130) =

      at =
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i=
nvokeNodes(AbstractParentProcessingNode.java:68) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pi=
pelineNode.java:138) 
      at =
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i=
nvokeNodes(AbstractParentProcessingNode.java:68) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(P=
ipelinesNode.java:92) 
      at =
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(=
ConcreteTreeProcessor.java:234) =

      at =
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(=
ConcreteTreeProcessor.java:176) =

      at =
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProc=
essor.java:243) 
      at =
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(Mount=
Node.java:117) 
      at =
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i=
nvokeNodes(AbstractParentProcessingNode.java:46) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.in=
voke(PreparableMatchNode.java:130) =

      at =
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.i=
nvokeNodes(AbstractParentProcessingNode.java:68) =

      at =
org.apache.cocoon.components.treeprocessor.sitemap.
 
Do I need to change anything with the xml which I =
supply to the sql transformer. I am constructing an xml with jxtemplate =
as follows :-
 
<?xml version=3D"1.0" =
encoding=3D"utf-8"?>
 
<jx:template =
xmlns:jx=3D"http://apache.org/cocoon/templates/jx/1.0"<=
/FONT>
           =
  =
xmlns:sql=3D"http://apache.org/cocoon/SQL/2.0">
  =
<page>
           =
    <sql:execute-query> =

           =
    =
  <sql:use-connection>imAdmin</sql:use-connection><=
o:p>
           =
      =
<sql:query>
           =
            &=
nbsp;       Select id from =
temp
           =
    =
</sql:query>
           =
    =
</sql:execute-query
 
</page>

 

I have an = entry in=20 sitemap.xmap as follows :-

 

   =20 <map:match = pattern=3D"display-output">

     =20 <map:generate type=3D"jx"=20 src=3D"templates/temp.jx">

       =20 <map:parameter name=3D"lenient-xpath"=20 value=3D"true"/>

     =20 </map:generate>

     =20 <map:transform type=3D"sql">

       =20 <map:parameter name=3D"clob-encoding"=20 value=3D"UTF-8"/>

     =20 </map:transform>

     =20 <map:serialize type=3D"xml" />

   =20 </map:match>

 

I tried to = remove the=20 page and see but I got the sql generated by the jx template back = instead of=20 the output query.

Please tell = me any=20 suggestions for this and also please tell me where I can find = resources with=20 respect to the SQL transformer.

 

Thanks and=20 Regards,

Baskar

 


The information = contained in=20 this electronic message and any attachments to this message are = intended=20 for the exclusive use of the addressee(s) and may contain = proprietary,=20 confidential or privileged information. If you are not the = intended=20 recipient, you should not disseminate, distribute or copy this = e-mail.=20 Please notify the sender immediately and destroy all copies of = this=20 message and any attachments.

WARNING: Computer viruses = can be=20 transmitted via email. The recipient should check this email and = any=20 attachments for the presence of viruses. The company accepts no=20 liability for any damage caused by any virus transmitted by this = = email.

www.wipro.com
------_=_NextPart_001_01C672A6.C670419A--