cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T K <tgckni...@yahoo.de>
Subject RE: precompile xsp cocoon2.1
Date Mon, 03 Nov 2003 14:07:09 GMT
Sorry for that subject-mistake, I'll start a new thread ! 
@1: I did, but without success. Indeed I tried every possible combination.
@2: this was a typing error. Should be  NUMBER in the type-Attribute
@3: sorry, what does "dml" mean. 
 
Thanx and sorry for the wrong subject
Torsten

"Grange, John" <john.grange@bluefinger.com> wrote:
Not sure that the subject of this post is correct, but...
 
Three ideas:
 
1)  Have you tried using a version of your return_ parameter without the underscore (call
it retval or something similar)
2)  Your output type for param 2 is a cursor, but is declared as a plain number in the pl/sql
3)  If you are still having problems, do you have the option of calling a pl/sql function,
in which case you could select from dual (this will not work if you are performing dml in
the function, however)
 
Hope this helps
 

John Grange 
Software Team Leader 

Tel: +44 (0) 1749 834922 
Email: john.grange@bluefinger.com 


BlueFinger Limited 
Underwood Business Park, Wookey Hole Road, Wells, Somerset, BA5 1AF, UK 
Tel: +44 (0) 1749 834900
Fax: +44 (0) 1749 834902 
Mobile: +44 (0) 7876 038058 
web: www.bluefinger.com 

 

Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG.

*** This E-mail contains confidential information for the addressee only. If you are not the
intended recipient, please notify us immediately. You should not use, disclose, distribute
or copy this communication if received in error. No binding contract will result from this
e-mail until such time as a written document is signed on behalf of the company. BlueFinger
Limited cannot accept responsibility for the completeness or accuracy of this message as it
has been transmitted over public networks.***
-----Original Message-----
From: T K [mailto:tgcknieps@yahoo.de]
Sent: 03 November 2003 13:35
To: users@cocoon.apache.org
Subject: Re: precompile xsp cocoon2.1



Hi,

I have posted this question on Friday before, but apparently no one seems to know a solution...
Therefore I am posting my problem more detailed again, for having solved this problem is really
important to me.

I'm using Cocoon2.1, JDK 1.4, Oracle9i and Tomcat 4.0.6. (anything left out ?)

I'm trying to use the SQL-Transformer to execute an stored Procedure from an Oracle DB. When
using the out-parameter tag I get an "java.sql.SQLException: ORA-01036: Variablenname/-nummer
ungültig" (illegal variable name/number). There is no error when executing a "normal" SQL-select-statement
via the SQL-Transformer and the stored Procedure is reachable and executable successfully
within SQL-Plus ! 

My code in loginAdmin.xsl:
<sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
<sql:query  isstoredprocedure="true" name="datesearch"> 
DECLARE 
 return_ NUMBER;
 outparm NUMBER;
 input VARCHAR2(200);
BEGIN 
  return_ := NULL;
  outparm := NULL;
  input := 'wa314';
 DB_HP_TST.SP_GET_USER_ID (return_, outparm, input);
 COMMIT;
END; 
</sql:query>
<sql:out-parameter sql:nr="1" sql:name="return_" sql:type="oracle.jdbc.driver.OracleTypes.NUMBER"/>
<sql:out-parameter sql:nr="2" sql:name="outparm" sql:type="oracle.jdbc.driver.OracleTypes.CURSOR"/>

The sitemap's entry:
<map:transform src="hybridProfiles/xsl/loginAdmin.xsl"/>
<map:transform type="sql">
 <map:parameter name="use-connection" value="personnel"/>
</map:transform>


I'm not that familiar with the out-parameter syntax. Must the name-attribute point to some
variable declared before or can it just be any string ? Must the nr-attribute be congruent
to the stored-procedure-syntax ?

To me it's seems to be a bug within the Transformer for I can't see any mistake in my code,
but to put the blame on something else is always quite easy, so I'll keep searching the failure
on my side, till somebody proved the opposite.

Any solutions, remarks, hints ?

Thanx in advance
Torsten

the complete error-trace (from sitemap.log):
ERROR   (2003-11-03) 12:55.55:955   [sitemap.sitemap.transformer.sql] (/cocoon/emma/logAdmin)
HttpProcessor[8080][3]/SQLTransformer$Query: Caught a SQLException
java.sql.SQLException: ORA-01036: Variablenname/-nummer ungültig
 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
 at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1617)
 at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)
 at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
 at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
 at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3975)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
 at org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1085)
 at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:309)
 at org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:466)
 at org.apache.cocoon.transformation.SQLTransformer.endTransformingElement(SQLTransformer.java:747)
 at org.apache.cocoon.transformation.AbstractSAXTransformer.endElement(AbstractSAXTransformer.java:358)
 at org.apache.xalan.transformer.ResultTreeHandler.endElement(ResultTreeHandler.java:307)
 at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:684)
 at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
 at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:678)
 at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
 at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(TransformerImpl.java:2008)
 at org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1171)
 at org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3135)
 at org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerHandlerImpl.java:433)
 at org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:91)
 at org.apache.cocoon.transformation.TraxTransformer.endDocument(TraxTransformer.java:529)
 at org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:91)
 at org.apache.cocoon.transformation.AbstractSAXTransformer.endDocument(AbstractSAXTransformer.java:312)
 at org.apache.cocoon.www.emma.hybridProfiles.xml.loginAdmin_xml.generate(org.apache.cocoon.www.emma.hybridProfiles.xml.loginAdmin_xml:323)
 at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:260)
 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:548)
 at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:196)
 at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:492)
 at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:147)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
 at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
 at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
 at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
 at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:130)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84)
 at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
 at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:163)
 at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108)
 at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161)
 at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:351)
 at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:304)
 at org.apache.cocoon.Cocoon.process(Cocoon.java:640)
 at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1104)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
 at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
 at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
 at java.lang.Thread.run(Thread.java:536)



---------------------------------
Gesendet von http://mail.yahoo.de
Schneller als Mail - der neue Yahoo! Messenger.



---------------------------------
Gesendet von http://mail.yahoo.de
Schneller als Mail - der neue Yahoo! Messenger.
Mime
View raw message