Page: http://wiki.cocoondev.org/Wiki.jsp?page=SQL-difference-ESQL , version: 1 on Sun Mar 30 09:58:37 2003 by Scherler
New page created: + ''I found different ways for SQL in cocoon. On the one hand there is <esql:.../>, on the other <sql:...>. So consider this a work in progress -- [Scherler]'' + ---- + __*please correct me if I am wrong, I am a beginner*__\\ + \\ + The main difference that I see is that <sql:.../> is based on a transformer and <esql:...> on a generator.\\ + One advantage in XSP is that you can add more logic to a document. You can use Java and ESQL within XSP.\\ + One advantage in using SQL is that you can have multiple transformer within a match.\\ + Both are based on different logicsheets.\\ + Page: http://wiki.cocoondev.org/Wiki.jsp?page=Scherler , version: 9 on Sun Mar 30 09:51:12 2003 by Scherler - * [Database Access|SQL/] ? ^ + * [Database Access|SQL%2F] ? ^^^ Page: http://wiki.cocoondev.org/Wiki.jsp?page=SQL-preparation , version: 1 on Sun Mar 30 09:54:55 2003 by Scherler New page created: + + To get started make sure your sitemap.xmap have the following components: + {{{... + <map:generators default="file"> + ... + <!--We will need this generator to use <esql:...> and Java in our *.xsp pages--> + <map:generator label="content,data" logger="sitemap.generator.serverpages" + name="xsp" pool-grow="2" pool-max="32" pool-min="4" + src="org.apache.cocoon.generation.ServerPagesGenerator"/> + </map:generators> + <map:transformers default="xslt"> + ... + <!--We will need this transformer to use <sql:...> our *.xml pages--> + <map:transformer logger="sitemap.transformer.sql" + name="sql" src="org.apache.cocoon.transformation.SQLTransformer"/> + </map:transformers> + ...}}} + + In your pipelines put: + {{{... + <map:pipeline> + <map:match pattern="db.xml"> + <map:generate type="xsp" src="db.xsp"/> + <map:serialize type="xml"/> + </map:match> + <map:pipeline> + ...}}} + Page: http://wiki.cocoondev.org/Wiki.jsp?page=SQL-page1 , version: 1 on Sun Mar 30 09:54:06 2003 by Scherler New page created: + ''I found different ways for SQL in cocoon. On the one hand there is <esql:.../>, on the other <sql:...>. So consider this a work in progress -- [Scherler]'' + ---- + __*please correct me if I am wrong, I am a beginner*__\\ + \\ + The main difference that I see is that <sql:.../> is based on a transformer and <esql:...> on a generator.\\ + One advantage in XSP is that you can add more logic to a document. You can use Java and ESQL within XSP.\\ + One advantage in using SQL is that you can have multiple transformer within a match.\\ + Both are based on different logicsheets.\\ + Page: http://wiki.cocoondev.org/Wiki.jsp?page=SQL , version: 11 on Sun Mar 30 09:57:16 2003 by Scherler + - __*please correct me if I am wrong, I am a beginner*__\\ - \\ - The main difference that I see is that <sql:.../> is based on a transformer and <esql:...> on a generator.\\ - One advantage in XSP is that you can add more logic to a document. You can use Java and ESQL within XSP.\\ - One advantage in using SQL is that you can have multiple transformer within a match.\\ - Both are based on different logicsheets.\\ + + first page:\\ + The main difference that I see is that <sql:.../> is based on a transformer and <esql:...> on a generator.\\
