You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Muenzer Peter <Pe...@fthw.siemens.de> on 2000/12/12 16:27:19 UTC
Problem with ESQL
Hi Folks!
I have an massive Problem with ESQL and Oracle.
I've been using the SQL - Processor for a while and it worked well
now im trying to use ESQL Taglib for one sigle reason -
<esql:autocommit>false</esql:autocommit> ;-)
But ahhhhh - Panic - it does not work ! ;-)
Im using Cocoon 1.8 with Jserv 1.2.2 and esql.xsl V 1.5 from the CVS
Repository.
I tink that davide semprini [semprini_davide@hotmail.com] had an similar
Problem a few day's before.
But that didn't helped me out.
Please Help ! - and sorry for that massive Posting....
Thanks !'
Peter
When Cocoon is Processing my Source file the Folowing output is generated:
----------------------------------------------------------------------------
------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN"
"http://www.w3.org/TR/REC-html40/strict.dtd">
<page xmlns:request="http://www.apache.org/1999/XSP/Request">
<esql:connection>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@nexus01:1521:NEXU</esql:dburl>
<esql:username>**</esql:username>
<esql:password>**</esql:password>
<esql:autocommit>false</esql:autocommit>
<message
xmlns:request="http://www.apache.org/1999/XSP/Request"></message><stacktrace
xmlns:request="http://www.apache.org/1999/XSP/Request">java.util.EmptyStackE
xception
at java.util.Stack.peek(Stack.java, Compiled Code)
at java.lang.Exception.<init>(Exception.java, Compiled Code)
at java.lang.RuntimeException.<init>(RuntimeException.java,
Compiled Code)
at
java.util.EmptyStackException.<init>(EmptyStackException.java,
Compiled Code)
at java.util.Stack.peek(Stack.java, Compiled Code)
at
_C_._Programme._Apache_Group._Apache._htdocs._Massnahmenneu._ESQL_updEINZELM
ASSNAHMENDATEN._esql_execute_query_N938de490(_ESQL_updEINZELMASSNAHMENDATEN.
java, Compiled Code)
at
_C_._Programme._Apache_Group._Apache._htdocs._Massnahmenneu._ESQL_updEINZELM
ASSNAHMENDATEN.populateDocument(_ESQL_updEINZELMASSNAHMENDATEN.java:525)
at
org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
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:588)
at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
at org.apache.jserv.JServConnection.run(JServConnection.java:188)
at java.lang.Thread.run(Thread.java:479)
</stacktrace>
</esql:connection>
</page>
<!-- This page was served in 2564 milliseconds by Cocoon 1.8 -->
............................................................................
....................................................
My Source File is a simple ( ok-mayby not ) uptdate statement...
source XML File:
----------------------------------------------------------------------------
-------------------------
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<xsp:page
language="java"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:request="http://www.apache.org/1999/XSP/Request">
<page>
<esql:connection>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@nexus01:1521:NEXU</esql:dburl>
<esql:username>*****</esql:username>
<esql:password>*****</esql:password>
<esql:autocommit>false</esql:autocommit>
<esql:execute-query>
<esql:query>
UPDATE MCADMINDEV.EINZELMASSNAHMEN
SET
MASSNAHMENVERANTWORTLICHER_ID = <request:get-parameter
name="jsCMassnahmenverantwortlicher"/>,
UMSETZUNGSVERANTWORTLICHER_ID = <request:get-parameter
name="jsCUmsetzungsverantwortlicher}"/>,
HAERTEGRAD_ID = <request:get-parameter name="jsCHaertegrad"/>,
MASSNAHMENART_ID = <request:get-parameter name="jsCMassnahmenart"/>,
ERTRAGSKREIS_ID = <request:get-parameter name="jsCErtragskreis"/>,
ORGANISATION_ID = <request:get-parameter name="jsCOrgeinheit"/>,
QUERSCHNITTSPROJEKTE_ID = <request:get-parameter
name="@jsCQuerschnisproj"/>,
MASSNAHMETITEL = \' <request:get-parameter name="jsTFMassnahmentitel"/>
\',
MASSNAHMENZIEL = \' <request:get-parameter name="jsTAMassnahmenziel"/> \',
MONATQUARTAL = '<request:get-parameter name="jsRBMonatQRT"/>',
PLANTERMIN_HG3_IST = TO_DATE( '<request:get-parameter
name="jsTFPlanterminHG3Ist"/>', 'DD.MM.YYYY') ,
PLANTERMIN_HG3_SOLL = TO_DATE('<request:get-parameter
name="jsTFPlanterminHG3Soll"/>', 'DD.MM.YYYY') ,
PLANTERMIN_HG4_IST = TO_DATE('<request:get-parameter
name="jsTFPlanterminHG4Ist"/>', 'DD.MM.YYYY') ,
PLANTERMIN_HG4_SOLL = TO_DATE('<request:get-parameter
name="jsTFPlanterminHG4Soll"/>', 'DD.MM.YYYY') ,
PLANTERMIN_HG5_IST = TO_DATE('<request:get-parameter
name="jsTFPlanterminHG5Ist"/>', 'DD.MM.YYYY'),
PLANTERMIN_HG5_SOLL = TO_DATE('<request:get-parameter
name="jsTFPlanterminHG5Soll"/>', 'DD.MM.YYYY') ,
MASSNAHMENWIRKUNG_ID = <request:get-parameter name="jsCWirkungTreiber"/>,
KOSTENSTELLE_ID = <request:get-parameter name="jsCKostenstelle"/>,
STATUS = <request:get-parameter name="jsCStatus"/>
WHERE EINZELMASSNAHMEN_ID = <request:get-parameter
name="jsTFMassnahmennummer"/>;
</esql:query>
<esql:update-results>
<updatecount><esql:get-update-count/></updatecount>
</esql:update-results>
<esql:no-results>
<error>no results were found</error>
</esql:no-results>
<esql:error-results>
<message><esql:get-message/></message>
<stacktrace><esql:get-stacktrace/></stacktrace>
</esql:error-results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
----------------------------------------------------------------------------
------
Re: ESQL documentation or how to display results w/ SQL Taglibs?
Posted by Donald Ball <ba...@webslingerZ.com>.
On Wed, 13 Dec 2000, Ryan J. McDonough wrote:
> Is there any documentation for the ESQL Tags in the Cocoon 1.8 distribution?
> There are references to theses docs but they are dead links. I've also been
> looking at the SQL Taglibs but I don't see any documentation on how to
> display the query results using the tags. Any help would be greatly
> appreciated. Thanks.
not in the 1.8 distribution, no. if you look in the cvs version, you'll
find a samples/sql directory with both an extensive sample and a (possibly
correct) schema.
ESQL documentation or how to display results w/ SQL Taglibs?
Posted by "Ryan J. McDonough" <ry...@randomthought.org>.
Is there any documentation for the ESQL Tags in the Cocoon 1.8 distribution?
There are references to theses docs but they are dead links. I've also been
looking at the SQL Taglibs but I don't see any documentation on how to
display the query results using the tags. Any help would be greatly
appreciated. Thanks.
Ryan-
+-----------------------------------------+
Ryan J. McDonough
http://www.randomthought.org
mailto:ryan@randomthought.org
+-----------------------------------------+
Re: Problem with ESQL
Posted by Donald Ball <ba...@webslingerZ.com>.
On Tue, 12 Dec 2000, Muenzer Peter wrote:
> Hi Folks!
> I have an massive Problem with ESQL and Oracle.
>
> I've been using the SQL - Processor for a while and it worked well
> now im trying to use ESQL Taglib for one sigle reason -
> <esql:autocommit>false</esql:autocommit> ;-)
>
> But ahhhhh - Panic - it does not work ! ;-)
>
> Im using Cocoon 1.8 with Jserv 1.2.2 and esql.xsl V 1.5 from the CVS
> Repository.
might i suggest that you _update your esql.xsl_? it's up to v1.37!!!
- donald