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.&lt;init&gt;(Exception.java, Compiled Code)
	at java.lang.RuntimeException.&lt;init&gt;(RuntimeException.java,
Compiled Code)
	at
java.util.EmptyStackException.&lt;init&gt;(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