Look into the ESQL stuff, into using the Database Actions, or into using the SQL Transformer.
You take a static XML file that describes an SQL query on a database, use the SQL Transformer to convert this to a table of responses in XML, then use a stylesheet to make it look however you want. The Cocoon book by Langham & Carsten has a whole chapter that does this stuff. This should be fairly straightforward, and there are many ways of pulling the data from the database into an XML stream. rob On Thu, 24 Oct 2002, Robert Siqueira wrote: > Ok.. but, in my architecture its complicated > use this structure.. i dont use jsp here... only > servlets... > The SAX events too write xml or just read the > xml files !?!?!? > > thanks... > > > > Andrew Timberlake wrote: > > > Look into using the ESQL logicsheet and xsp: > > http://xml.apache.org/cocoon/userdocs/xsp/esql.html > > Follow the links on the left for more information on XSP. > > XSP is similar to JSP but helps to create the XML in SAX events in a > > rapid development "script" language. > > > > Andrew > > > > On Thu, 2002-10-24 at 17:47, Robert Siqueira wrote: > > > I dont understood you explanation.. For example: > > > > > > When a user enter in my application java and request > > > one report, I do this: > > > > > > 1) I get the data from my database and I write a xml file (test.xml).. > > > 2) I do a request to coccon with a file.pdf > > > (http://localhost:8080/cocoon/test.pdf) > > > 3) in my sitemap.xmap I have: > > > > > > <map:pipelines> > > > <map:match pattern="*.pdf"> > > > <map:generate src="{1}.xml"/> > > > <map:transform src="test.xsl"/> > > > <map:serialize type="fo2pdf"/> > > > </map:match> > > > </map:pipeline> > > > > > > > > > So, the adobe acrobat its opened, shown my PDF !!!! > > > > > > Now, in this case, I have that write a xml, every time that the user request a > > > pdf.. this because > > > i have to get the data in my database... then, I asked if there is a > > > possibility of dont > > > write this XML... do all in memory ?!?!?!!? > > > > > > Thanks.. > > > sorry by extensive text !!! > > > > > > > > > > > > Robert Ellis Parrott wrote: > > > > > > > While XML is generated, I believe that it is processed in the pipeline as > > > > SAX events, and not as an XML file. So all is in memory. > > > > > > > > Look at the samples; I believe that there is a simple "Hello world" type > > > > example there. While it may may a generator that reads from an XML file, > > > > this isn't necessary; any generator can be used. > > > > > > > > rob > > > > > > > > On Thu, 24 Oct 2002 [EMAIL PROTECTED] wrote: > > > > > > > > > Hi All !!! > > > > > > > > > > I have a java application and I would like to use the cocoon to turn data > > > > > from my data base into report pdf. > > > > > >From what I've studied about coccon, it needs a xml and a xsl:fo to turn > > > > > it into pdf. > > > > > Then, it means that, at each user's request, I have to access my data > > > > > base, > > > > > get the data, generate a xml and call the coccon. > > > > > Could you imagine 20 users needing a request? > > > > > Would I have to create 20 xml's in a hard disk? > > > > > Is there any way for not create the xml in a hard disk? > > > > > > > > > > I'll be waiting for your answer. > > > > > Thank you. > > > > > > > > > -- > Robert Siqueira > Desenvolvimento WEB > Centro de Computação - CCUEC - UNICAMP > UIN 70479124 > ---------------------------------------------------- > "O conhecimento pertence a humanidade" > ---------------------------------------------------- > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.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/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
