Hi! I think you can make use of esql transformation. I guess you are using xsp:esql in you XSP file, because you need to get new data from the database with the base of the first data you got from your own logicsheet.
I am correct? If this is the problem, then is generated because Cocoon cannot know you are trying to make use of xsp:esql in TWO steps. I recommend you to read the chapter #6 from the Carsten-Matthew book. You can read this chapter it at: http://xml.apache.org/cocoon/link/books.html Better I recommend you buy the book. I hope it can help ;-) Regards, Antonio Gallardo > Hi, > > I am trying to write my own logicsheet which uses esql to fetch some > data from a mysql database. This works fine as long as the xsp-page > itself does not use esql. However, when I also want to use esql in the > xsp, I get a lot of 'duplicate definition of variable' errors. How can I > resolve this? > > Thanks, > > Andreas > > Below are the logicsheet, the xsp file and the errors I get: > > Part of the mm_logic.xsl file: > > <?xml version="1.0"?> > <xsl:stylesheet > version="1.0" > xmlns:xsp="http://apache.org/xsp" > xmlns:session="http://apache.org/xsp/session/2.0" > xmlns:mm="http://siemens.com/mm" > xmlns:esql="http://apache.org/cocoon/SQL/v2" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > ... > <!-- database access --> > > <esql:connection> > <esql:pool>mm</esql:pool> > <esql:execute-query> > ... > </esql:execute-query> > </esql:connection> > </category-list> > </xsl:template>--> > > <xsl:template match="@*|*|text()|processing-instruction()"> > <xsl:copy> > <xsl:apply-templates > select="@*|*|text()|processing-instruction()"/> > </xsl:copy> > </xsl:template> > > </xsl:stylesheet> > > --------------------------------------------------------------------- > > Part of the list.xsp > > <?xml version="1.0" encoding="ISO-8859-1"?> > <xsp:page > language="java" > xmlns:xsp="http://apache.org/xsp" > > xmlns:session="http://apache.org/xsp/session/2.0" > xmlns:mm="http://siemens.com/mm" > > xmlns:esql="http://apache.org/cocoon/SQL/v2"> > <page> > ... > <esql:connection> > <esql:pool>mm</esql:pool> > <esql:execute-query> > ... > </esql:execute-query> > </esql:connection> > </category-list> > > ... > </page> > </xsp:page> > > ----------------------------------------------------------- > > The errors I get: > > org.apache.cocoon.ProcessingException: Language Exception: > org.apache.cocoon.components.language.LanguageException: Error compiling > videolist_xsp: > Line 299, column 18: duplicate definition of variable _esql_connections > in class org.apache.cocoon.www.xsp.videolist_xsp > Line 300, column 34: duplicate definition of variable _esql_connection > in class org.apache.cocoon.www.xsp.videolist_xsp > Line 301, column 18: duplicate definition of variable _esql_queries in > class org.apache.cocoon.www.xsp.videolist_xsp > Line 302, column 22: duplicate definition of variable _esql_query in > class org.apache.cocoon.www.xsp.videolist_xsp > Line 303, column 25: duplicate definition of variable _esql_exception > in class org.apache.cocoon.www.xsp.videolist_xsp > Line 304, column 25: duplicate definition of variable > _esql_exception_writer in class org.apache.cocoon.www.xsp.videolist_xsp > Line 320, column 27: duplicate definition of method > _esql_printObject(java.lang.Object, org.xml.sax.helpers.AttributesImpl) > in class org.apache.cocoon.www.xsp.videolist_xsp > Line 0, column 0: > 7 errors > > P.S.: I looked at the esql.xsl file. If I understand it correctly, the > global import statements and the global _esql_*-variables should only be > generated when a xsp:page tag is found - and there is only one of those. > > //_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > // Andreas Ebert, Corporate Technology, Siemens AG > // E-Mail: [EMAIL PROTECTED] NEW! > > > --------------------------------------------------------------------- > 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]>