You are viewing a plain text version of this content. The canonical link for it is here.
Posted to cvs@cocoon.apache.org by gr...@apache.org on 2001/01/10 23:05:50 UTC

cvs commit: xml-cocoon/samples/sql database-page.xml README taglib.xml

greenrd     01/01/10 14:05:50

  Modified:    xdocs    sqlprocessor.xml sqltaglib.xml
  Added:       samples/sql/old database-page.xml taglib.xml
  Removed:     samples/sql database-page.xml README taglib.xml
  Log:
  deprecating sql taglib
  
  Revision  Changes    Path
  1.6       +1 -1      xml-cocoon/xdocs/sqlprocessor.xml
  
  Index: sqlprocessor.xml
  ===================================================================
  RCS file: /home/cvs/xml-cocoon/xdocs/sqlprocessor.xml,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- sqlprocessor.xml	2000/09/19 23:01:45	1.5
  +++ sqlprocessor.xml	2001/01/10 22:05:44	1.6
  @@ -7,7 +7,7 @@
   	<s1 title="Description">
       <note><strong>SQLProcessor is deprecated and no longer supported,</strong>
        and it is recommended that you use
  -     the <connect href="sqltaglib.xml">SQL XSP taglibs</connect>
  +     the <connect href="esql.xml">ESQL XSP taglib</connect>
        instead. This documentation is provided for those who
        are still using SQLProcessor.</note>
   
  
  
  
  1.12      +9 -1      xml-cocoon/xdocs/sqltaglib.xml
  
  Index: sqltaglib.xml
  ===================================================================
  RCS file: /home/cvs/xml-cocoon/xdocs/sqltaglib.xml,v
  retrieving revision 1.11
  retrieving revision 1.12
  diff -u -r1.11 -r1.12
  --- sqltaglib.xml	2000/11/07 22:35:33	1.11
  +++ sqltaglib.xml	2001/01/10 22:05:45	1.12
  @@ -5,7 +5,15 @@
   <document><header><title>SQL Taglib</title><authors><person name="Donald A. Ball Jr." email="balld@webslingerz.com"/></authors></header><body>
   
   	<s1 title="Description">
  -		<p>The SQL logicsheet is an XSP logicsheet that performs sql queries and serializes their results as XML. This allows you to work with data from a wide variety of different sources when using Cocoon.</p>
  +    <note><strong>The SQL logicsheet is deprecated and no longer supported,</strong>
  +     and it is recommended that you use
  +     the <connect href="esql.xml">ESQL logicsheet</connect>
  +     instead. This documentation is provided for those who
  +     are still using the SQL logicsheet.</note>
  +
  +    <p>The SQL logicsheet is an 
  +XSP logicsheet that performs sql queries and serializes their 
  +results as XML. This allows you to work with data from a wide variety of different sources when using Cocoon.</p>
   	</s1>
   
   	<s1 title="Installation">
  
  
  
  1.1                  xml-cocoon/samples/sql/old/database-page.xml
  
  Index: database-page.xml
  ===================================================================
  <?xml version="1.0"?>
  
  <?cocoon-process type="sql"?>
  
  <page>
  
   <connectiondefs>
    <connection name="foo_connection">
     <driver>org.gjt.mm.mysql.Driver</driver>
     <dburl>jdbc:mysql://localhost/test</dburl>
     <!--<username>foo_user</username>
     <password>foo_password</password>-->
    </connection>
   </connectiondefs> 
   
   <query connection="foo_connection">
    select * from foo_table
   </query>
   
  </page>
  
  
  
  1.1                  xml-cocoon/samples/sql/old/taglib.xml
  
  Index: taglib.xml
  ===================================================================
  <?xml version="1.0"?>
  
  <?cocoon-process type="xsp"?>
  
  <xsp:page
    language="java"
    xmlns:sql="http://www.apache.org/1999/SQL"
    xmlns:xsp="http://www.apache.org/1999/XSP/Core"
    xmlns:request="http://www.apache.org/1999/XSP/Request"
  >
  
    <page title="SQL Search Results">
  
    	<sql:execute-query>
  		<sql:driver>org.gjt.mm.mysql.Driver</sql:driver>
  		<sql:dburl>jdbc:mysql://localhost/test</sql:dburl>
  		<sql:doc-element>things</sql:doc-element>
  		<sql:row-element>thing</sql:row-element>
  		<sql:column-format>
  			<sql:name>my_date</sql:name>
  			<sql:class>java.text.SimpleDateFormat</sql:class>
  			<sql:parameter>MM/dd/yyyy</sql:parameter>
  		</sql:column-format>
  		<sql:column-format>
  			<sql:name>my_time</sql:name>
  			<sql:class>java.text.SimpleDateFormat</sql:class>
  			<sql:parameter>hh:mm (ss)</sql:parameter>
  		</sql:column-format>
  		<sql:query>select * from column_type_table where id = <request:get-parameter name="id"/></sql:query>
  	</sql:execute-query>
  
    </page>
  
  </xsp:page>