You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by di...@es.pwcglobal.com on 2000/11/16 20:25:44 UTC
Problems with SQL taglibs....
I´m trying to use the next xml file with Cocoon:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<?cocoon-process type="xsp"?>
<xsp:page
language="java"
xmlns:sql="http://www.apache.org/1999/SQL"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>
<sql:execute-query>
<sql:driver>weblogic.jdbc.oci.Driver</sql:driver>
<sql:dburl>jdbc:weblogic:oracle:servicioORCL</sql:dburl>
<sql:username>interfaz</sql:username>
<sql:password>interfaz</sql:password>
<sql:doc-element>ROWSET</sql:doc-element>
<sql:row-element>ROW</sql:row-element>
<sql:query>select * from ppp_info_bancaria</sql:query>
</sql:execute-query>
</xsp:page>
I think i have correctly configured the cocoon.properties to use my pool but
when i use Cocoon to process it i get the next error:
java.lang.Exception: XSP Java Compiler: Compilation failed for _sql.java
44: Undefined variable: document
document,
^
68: Undefined variable: document
document,
^
89: Undefined variable or class name: xspCurrentNode
xspCurrentNode.appendChild(
^
3 errors
at
org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJavaProcessor.java,
Compiled Code)
at java.lang.Exception.(Exception.java, Compiled Code)
at
org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJavaProcessor.java,
Compiled Code)
at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java, Compiled
Code)
at org.apache.cocoon.Engine.handle(Engine.java, Compiled Code)
at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:123)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:761)
at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:708)
at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:252)
at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:346)
at
weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:246)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java, Compiled
Code)
Can anybody tell me what i am doing wrong???? Thank you very much
indeed....Diego
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
Re: Problems with SQL taglibs....
Posted by Donald Ball <ba...@webslingerZ.com>.
On Thu, 16 Nov 2000 diego.gonzalez.areizaga@es.pwcglobal.com wrote:
>
>
> I�m�trying to use the next xml file with Cocoon:
>
> <?xml version="1.0" encoding="ISO-8859-1" ?>
> <?cocoon-process type="xsp"?>
> <xsp:page
> language="java"
> xmlns:sql="http://www.apache.org/1999/SQL"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core"
> >
> <sql:execute-query>
> <sql:driver>weblogic.jdbc.oci.Driver</sql:driver>
> <sql:dburl>jdbc:weblogic:oracle:servicioORCL</sql:dburl>
> <sql:username>interfaz</sql:username>
> <sql:password>interfaz</sql:password>
> <sql:doc-element>ROWSET</sql:doc-element>
> <sql:row-element>ROW</sql:row-element>
> <sql:query>select * from ppp_info_bancaria</sql:query>
> </sql:execute-query>
> </xsp:page>
so sorry, i'm not supporting the sql logicsheet anymore. try using the
latest esql logicsheet from cvs.
offhand, though, i'd say the problem is that you need to put a root
element around the <sql:execute-query> element.
- donald