I am here again, I already got to use a XSL with my query, but I change my previous SQL to ESQL, and I got some errors, could you tell me what's wrong ?
Here my code:
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<?xml-stylesheet href="taglib.xsl"
type="text/xsl"?>
<?cocoon-process type="xslt"?>
<xsp:page
language="java"
xmlns:esql="http://www.apache.org/1999/SQL/v2"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:request="http://www.apache.org/1999/XSP/Request"
>
<page title="SQL
Search Results">
<esql:execute-query>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@204.153.24.233:1521:cta</esql:dburl>
<esql:username>myuser</esql:username>
<esql:password>mypassword</esql:password>
<esql:doc-element>empleados</esql:doc-element>
<esql:row-element>registro</esql:row-element>
<esql:query>select
* from employee</esql:query>
</esql:execute-query>
</page>
</xsp:page>
The errors that I got
are :
Error found handling the
request.
java.lang.Exception: XSP
Java Compiler: Compilation failed for _taglib.java
82: Duplicate variable declaration:
DBBroker _esql_pool was DBBroker _esql_pool
static DBBroker
_esql_pool = DBBroker.getInstance();
^
83: Class _C_._tomcat._webapps._cocoon._servlets._sql._taglib. EsqlSession already defined in C:\tomcat\bin\repository\_C_\_tomcat\_webapps\_cocoon\_servlets\_sql\_taglib.java.
class EsqlSession {
^
83: Duplicate inner class
declaration: nested type _C_._tomcat._webapps._cocoon._servlets._sql._taglib.
EsqlSession is already defined in this scope.
class EsqlSession {
^
3 errors
at org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJavaProcessor.java:141)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:489)
at org.apache.cocoon.Engine.handle(Engine.java:359)
at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:484)
Thanks a lot,
Gustavo Mejia
INFOTEC
JEULIN Olivier wrote:
Hi,
WARNING: you are using a deprecated taglib! The correct one is esql, not
sql.
Take a look at your cocoon/samples/sql for a sample.
You will find the available elements in esql.xsd in the same directory.
Olivier> -----Message d'origine-----
> De : Gustavo Mejia [mailto:[EMAIL PROTECTED]]
> Envoyé : lundi 11 juin 2001 20:29
> À : [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Objet : Formating !
> Importance : Haute
>
>
> > Hi,
> >
> > I am new using cocoon, I am get results using a query, and
> now I wan format that information, could you
> > tell how can I do that ? I know that I need XSL document, I
> already try with this, and I did't get it.
> > here my code ..
> >
> > <?xml version="1.0"?>
> > <?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"
> > xmlns:request="http://www.apache.org/1999/XSP/Request"
> > >
> >
> > <page title="SQL Search Results">
> >
> > <sql:execute-query>
> > <sql:driver>oracle.jdbc.driver.OracleDriver</sql:driver>
> > <sql:dburl>jdbc:oracle:thin:@host:1521:CTA</sql:dburl>
> > <sql:username>mypassword</sql:username>
> > <sql:password>myuser</sql:password>
> > <sql:doc-element>empleados</sql:doc-element>
> > <sql:row-element>registro</sql:row-element>
> >
> > <sql:query>select * from employee order by empno</sql:query>
> > </sql:execute-query>
> > </page>
> > </xsp:page>
> >
> > Thanks in advance !
> > Gustavo Mejia
> > www.Infotec.com.mx
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
