--- Upayavira <[EMAIL PROTECTED]> wrote: > ... > Have you successfully used the CLI to render non SQL > pages? >
Yes, I didn't have much problems with non SQL pages, although I had to try some times to get these parameters right (one thing, "-x cli.xconf" didn't seem to work, "cocoon cli -x cli.xconf" outputs errors like "need destination directory", which was in "cli.xconf"; after adding "-d xxx" to the cli, another exception, "WEB-APP/logkit.xconf couldn't be found", came up. Finally, I had to put everything on cli to get it to work). > ... > Are you prepared to help debug this? If so, I will > do my best to guide > you through, which would then make this feature > available to all who > want to use the CLI with databases. > Sure, I'd like to help. By the way, I appreciate all your work at cocoon, the software is awesome. Thanks for taking time to reply my email, D. Zhu > With best wishes, > > Upayavira > > David Zhu wrote: > > >Hello everyone, > > > >I have a question regarding connection to Oracle > >database when using CLI. I have a project that > needs > >to generate some static pages from an Oracle db, I > am > >able to do that throught browser, but got > SQLexception > >when I used Command line interface. Is there any > >difference between servlet and CLI regarding sql > >connection? and how do I get the configuration > right? > >any help will be greatly appreciated. > > > >my cocoon version is 2.1.1 (the last, I just > >downloaded it a couple of days ago), the OS is > >windowsXP with java SDK 1.4.1. cocoon.xconf and > >web.xml are attached. > > > >I used this command: > >E:\temp\new\cocoon-2.1.1>cocoon.bat cli -C > >build\webapp\web-inf\cocoon.xconf -d dest -c > >build\webapp -u DEBUG -L > >oracle.jdbc.driver.OracleDriver sqlou > >t.xml > > > >The java exception looks like: > > > >Cannot find CatalogManager.properties > >ERROR 2003-09-23 16:53:58.916 [sitemap.] (): > Caught > >a SQLException > >java.sql.SQLException: Failed to obtain connection. > >Made 5 attempts with 5000ms interval > > at > >org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTransformer.java:1007) > > at > >org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1061) > > 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.cocoon.components.sax.XMLTeePipe.endElement(XMLTeePipe.java:124) > > at > >org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > >Source) > > at > >org.apache.xerces.parsers.XML11Configuration.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.DTDConfiguration.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.XMLParser.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown > >Source) > > at > >org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:318) > > at > >org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:337) > > at > >org.apache.cocoon.components.source.SourceUtil.parse(SourceUtil.java:229) > > at > >org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:139) > > at > >org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:272) > > > > 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:164) > > 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:363) > > at > >org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:316) > > at > >org.apache.cocoon.Cocoon.process(Cocoon.java:637) > > at > >org.apache.cocoon.bean.CocoonWrapper.processLenient(CocoonWrapper.java:609) > > at > >org.apache.cocoon.bean.CocoonWrapper.getType(CocoonWrapper.java:596) > > at > >org.apache.cocoon.bean.CocoonBean.processTarget(CocoonBean.java:394) > > at > >org.apache.cocoon.bean.CocoonBean.process(CocoonBean.java:294) > > at > org.apache.cocoon.Main.main(Main.java:392) > > at > >sun.reflect.NativeMethodAccessorImpl.invoke0(Native > >Method) > > at > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at > >java.lang.reflect.Method.invoke(Method.java:324) > > at Loader.invokeMain(Unknown Source) > > at Loader.run(Unknown Source) > > at Loader.main(Unknown Source) > >ERROR 2003-09-23 16:54:26.095 [sitemap.] (): > Caught > >a SQLException > >java.sql.SQLException: Failed to obtain connection. > >Made 5 attempts with 5000ms interval > > at > >org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTransformer.java:1007) > > at > >org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1061) > > 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.cocoon.components.sax.XMLTeePipe.endElement(XMLTeePipe.java:124) > > at > >org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > >Source) > > at > >org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > >Source) > > at > >org.apache.xerces.parsers.XML11Configuration.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.DTDConfiguration.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.XMLParser.parse(Unknown > >Source) > > at > >org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown > === message truncated === __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
