Cocoon/2.xsp

From Fxp Wiki

 
<?xml version="1.0" encoding="ISO-8859-1"?>
 
 
<xsp:page language="java" xmlns:esql="http://apache.org/cocoon/SQL/v2" xmlns:xsp="http://apache.org/xsp">
<page>
<!--
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="2.xsl" type="text/xsl"?>
<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<xsp:page language="java" xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp="http://apache.org/xsp">
-->
 <title>Hello World!</title>
 <content>
  <paragraph>This is my first Cocoon page!</paragraph>
 </content>
 
 
<query>
<esql:connection>
		
 
			<esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
			<esql:dburl>jdbc:odbc:cib</esql:dburl>
 
			<esql:username>sa</esql:username>
			<esql:password>sa</esql:password>
 
<esql:execute-query>
			<esql:query>SELECT * FROM Notions WHERE Langue='en';</esql:query>
 
<esql:results>
				
				<notions><esql:get-string column="Notion"/></notions>
				<lg><esql:get-string column="Langue"/></lg>
								
			</esql:results>
 
			<esql:no-results><error>no results were found</error></esql:no-results>
 
			<esql:error-results>
				 <message><esql:get-message/></message>
				 <stacktrace><esql:get-stacktrace/></stacktrace>
			</esql:error-results>
 
		</esql:execute-query>
</esql:connection>
	</query>
 
 
 
</page>
 
</xsp:page>