You are viewing a plain text version of this content. The canonical link for it is here.
Posted to docs@cocoon.apache.org by st...@outerthought.org on 2003/03/30 12:00:05 UTC
[WIKI-UPDATE] SQL-difference-ESQL Scherler SQL-preparation SQL-page1 SQL Sun Mar 30 12:00:05 2003
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.\\