Aloha,
I added clob support to the esql stylesheet, but don't know if anyone
added it to the release. I've attached it to this message, this
allows you to use get-xml with clobs.
Thursday, April 25, 2002, 8:34:56 AM, you wrote:
SS> The only tag that supports clobs is <esql:get-ascii/>. Try this:
SS> <util:include-expr><util:expr><esql:get-ascii
column="myclob"/>></util:expr></util:include-expr>
SS> Steve
SS> -----Original Message-----
SS> From: yuryx [mailto:[EMAIL PROTECTED]]
SS> Sent: Thursday, April 25, 2002 12:03 PM
SS> To: [EMAIL PROTECTED]
SS> Subject: Re: clob-esql-xml
SS> yuryx wrote:
>> Steven Sedlmeyer wrote:
>>
>>> try <esql:get-ascii column="myclob"/>
>>>
>>> Steve
>>>
>> Thx, but I need XML,not ascii...
>> Yury
>>
SS> <esql:get-xml /> don't work with CLOB
SS> if use VARCHAR then it work very good...
SS> May be <esql:get-xml /> don't support CLOB?
SS> Yury.
>>>
>>> -----Original Message-----
>>> From: yuryx [mailto:[EMAIL PROTECTED]]
>>> Sent: Thursday, April 25, 2002 1:46 AM
>>> To: [EMAIL PROTECTED]
>>> Subject: clob-esql-xml
>>>
>>>
>>> Hi all!
>>> How to extract clob column as xml into dynamic page?
>>> For example:
>>> my CLOB: <h1>hello!</h1>
>>> in sample.xsp I define:
>>> ...
>>> <esql:execute-query>
>>> <esql:query>select myclob from mytable</esql:query>
>>> <esql:results>
>>> <esql:row-results>
>>> <esql:get-xml column="myclob"/>
>>> </esql:row-results>
>>> </esql:results>
>>> </esql:execute-query>
>>> ...
>>> ?This example don't work :(
>>> What I'm wrong?
>>> Thanx.
>>> Yury.
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> Please check that your question has not already been answered in the
>>> FAQ before posting. <http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.html>
>>
>> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>> For additional commands, e-mail: <[EMAIL PROTECTED]>
>>
SS> ---------------------------------------------------------------------
SS> Please check that your question has not already been answered in the
SS> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
SS> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
SS> For additional commands, e-mail: <[EMAIL PROTECTED]>
SS> ---------------------------------------------------------------------
SS> Please check that your question has not already been answered in the
SS> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
SS> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
SS> For additional commands, e-mail: <[EMAIL PROTECTED]>
--
Mahalo,
Russell mailto:[EMAIL PROTECTED]
Distinguished Engineer
"I know how hard it is for you to put food on your family."
-Our President
<?xml version="1.0"?>
<!-- $Id: esql.xsl,v 1.3 2002/03/28 03:43:46 russell Exp $-->
<!--
============================================================================
The Apache Software License, Version 1.2
============================================================================
Copyright (C) @year@ The Apache Software Foundation. All rights reserved.
Redistribution and use in source and binary forms, with or without modifica-
tion, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
3. The end-user documentation included with the redistribution, if any, must
include the following acknowledgment: "This product includes software
developed by the Apache Software Foundation (http://www.apache.org/)."
Alternately, this acknowledgment may appear in the software itself, if
and wherever such third-party acknowledgments normally appear.
4. The names "Cocoon" and "Apache Software Foundation" must not be used to
endorse or promote products derived from this software without prior
written permission. For written permission, please contact
[EMAIL PROTECTED]
5. Products derived from this software may not be called "Apache", nor may
"Apache" appear in their name, without prior written permission of the
Apache Software Foundation.
THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLU-
DING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
This software consists of voluntary contributions made by many individuals
on behalf of the Apache Software Foundation and was originally created by
Stefano Mazzocchi <[EMAIL PROTECTED]>. For more information on the Apache
Software Foundation, please see <http://www.apache.org/>.
-->
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xsp="http://www.apache.org/1999/XSP/Core";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xspdoc="http://apache.org/cocoon/XSPDoc/v1";
>
<!--
-->
<xsl:param name="XSP-ENVIRONMENT"/>
<xsl:param name="XSP-VERSION"/>
<xsl:param name="filename"/>
<xsl:param name="language"/>
<xsl:variable name="cocoon1-environment">Cocoon 1</xsl:variable>
<xsl:variable name="cocoon2-environment">Cocoon 2</xsl:variable>
<xsl:variable name="cocoon1-xsp-namespace-uri">http://www.apache.org/1999/XSP/Core</xsl:variable>
<xsl:variable name="cocoon2-xsp-namespace-uri">http://apache.org/xsp</xsl:variable>
<xsl:variable name="environment">
<xsl:choose>
<xsl:when test="starts-with($XSP-ENVIRONMENT,$cocoon1-environment)">
<xsl:text>cocoon1</xsl:text>
</xsl:when>
<xsl:when test="starts-with($XSP-ENVIRONMENT,$cocoon2-environment)">
<xsl:text>cocoon2</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:text>cocoon1</xsl:text>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<xsl:variable name="xsp-namespace-uri">
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
<xsl:value-of select="$cocoon1-xsp-namespace-uri"/>
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
<xsl:value-of select="$cocoon2-xsp-namespace-uri"/>
</xsl:when>
</xsl:choose>
</xsl:variable>
<xsl:template name="get-nested-content">
<xsl:param name="content"/>
<xsl:choose>
<xsl:when test="$content/*">
<xsl:apply-templates select="$content/*"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$content"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="get-nested-string">
<xsl:param name="content"/>
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
<xsl:choose>
<xsl:when test="$content/*">
""
<xsl:for-each select="$content/node()">
<xsl:choose>
<xsl:when test="name(.)">
+ <xsl:apply-templates select="."/>
</xsl:when>
<xsl:otherwise>
+ "<xsl:value-of select="translate(.,'	 ',' ')"/>"
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:when>
<xsl:otherwise>
"<xsl:value-of select="normalize-space($content)"/>"
</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
<xsl:choose>
<xsl:when test="$content/*">
""
<xsl:for-each select="$content/node()">
<xsl:choose>
<xsl:when test="name(.)">
<xsl:choose>
<xsl:when test="namespace-uri(.)='http://apache.org/xsp' and local-name(.)='text'">
+ "<xsl:value-of select="."/>"
</xsl:when>
<xsl:otherwise>
+ <xsl:apply-templates select="."/>
</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:otherwise>
+ "<xsl:value-of select="translate(.,'	 ',' ')"/>"
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:when>
<xsl:otherwise>"<xsl:value-of select="normalize-space($content)"/>"</xsl:otherwise>
</xsl:choose>
</xsl:when>
</xsl:choose>
</xsl:template>
<xsl:template match="xsp:page">
<xsp:page>
<xsl:apply-templates select="@*"/>
<xsp:structure>
<xsp:include>java.sql.DriverManager</xsp:include>
<xsp:include>java.sql.Clob</xsp:include>
<xsp:include>java.sql.Connection</xsp:include>
<xsp:include>java.sql.Statement</xsp:include>
<xsp:include>java.sql.PreparedStatement</xsp:include>
<xsp:include>java.sql.ResultSet</xsp:include>
<xsp:include>java.sql.ResultSetMetaData</xsp:include>
<xsp:include>java.sql.SQLException</xsp:include>
<xsp:include>java.text.SimpleDateFormat</xsp:include>
<xsp:include>java.text.DecimalFormat</xsp:include>
<xsp:include>java.io.StringWriter</xsp:include>
<xsp:include>java.io.PrintWriter</xsp:include>
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
<xsp:include>org.apache.turbine.services.db.PoolBrokerService</xsp:include>
<xsp:include>org.apache.turbine.util.db.pool.DBConnection</xsp:include>
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
<xsp:include>org.apache.cocoon.components.datasource.DataSourceComponent</xsp:include>
<xsp:include>org.apache.cocoon.components.language.markup.xsp.XSPUtil</xsp:include>
</xsl:when>
</xsl:choose>
</xsp:structure>
<xsp:logic>
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
static PoolBrokerService _esql_pool = PoolBrokerService.getInstance();
public static Reader getXML(ResultSet rs, String colName) throws SQLException {
if (rs == null || colName == null) {
return new StringReader(new String());
}
Object o = rs.getObject(colName);
if (o instanceof Clob) {
java.io.InputStream is = ((Clob)o).getAsciiStream();
InputStreamReader isr = new InputStreamReader(is);
return isr;
} else {
return new StringReader(rs.getString(colName));
}//fi
} //method
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
private static ComponentSelector _esql_selector = null;
public void compose(ComponentManager manager) {
super.compose(manager);
if (_esql_selector == null) {
try {
_esql_selector = (ComponentSelector) manager.lookup(Roles.DB_CONNECTION);
} catch (ComponentManagerException cme) {
log.error("Could not look up the datasource component", cme);
}
}
}
</xsl:when>
</xsl:choose>
class EsqlConnection {
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
DBConnection db_connection = null;
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
DataSourceComponent datasource = null;
</xsl:when>
</xsl:choose>
Connection connection = null;
String dburl = null;
String username = null;
String password = null;
}
class EsqlQuery {
String query;
Statement statement;
PreparedStatement prepared_statement;
ResultSet resultset;
ResultSetMetaData resultset_metadata;
/** the position of the current row in the resultset **/
int position = -1;
int max_rows = -1;
int skip_rows = 0;
boolean results;
}
</xsp:logic>
<xsl:apply-templates/>
</xsp:page>
</xsl:template>
<xsl:template match="xsp:page/*[not(namespace-uri(.)=$xsp-namespace-uri)]">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsp:logic>
Stack _esql_connections = new Stack();
EsqlConnection _esql_connection = null;
Stack _esql_queries = new Stack();
EsqlQuery _esql_query = null;
SQLException _esql_exception = null;
StringWriter _esql_exception_writer = null;
</xsp:logic>
<xsl:apply-templates/>
</xsl:copy>
</xsl:template>
<xsl:template match="esql:connection">
<xsl:variable name="driver"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:driver"/></xsl:call-template></xsl:variable>
<xsl:variable name="dburl"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:dburl"/></xsl:call-template></xsl:variable>
<xsl:variable name="username"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:username"/></xsl:call-template></xsl:variable>
<xsl:variable name="password"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:password"/></xsl:call-template></xsl:variable>
<xsl:variable name="pool"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:pool"/></xsl:call-template></xsl:variable>
<xsl:variable name="autocommit"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:autocommit"/></xsl:call-template></xsl:variable>
<xsp:logic>
if (_esql_connection != null) {
_esql_connections.push(_esql_connection);
}
_esql_connection = new EsqlConnection();
try {
<xsl:choose>
<xsl:when test="esql:pool and $environment = 'cocoon1'">
try {
_esql_connection.db_connection = _esql_pool.getConnection(String.valueOf(<xsl:copy-of select="$pool"/>));
_esql_connection.connection = _esql_connection.db_connection.getConnection();
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error opening pooled connection: "+String.valueOf(<xsl:copy-of select="$pool"/>)+": "+_esql_exception_<xsl:value-of select="generate-id(.)"/>.getMessage());
}
if (_esql_connection.connection == null) {
throw new RuntimeException("Could not open pooled connection: "+String.valueOf(<xsl:copy-of select="$pool"/>));
}
</xsl:when>
<xsl:when test="esql:pool and $environment = 'cocoon2'">
try {
//fucking hell;
_esql_connection.datasource = (DataSourceComponent) _esql_selector.select(String.valueOf(<xsl:copy-of select="$pool"/>));
_esql_connection.connection = _esql_connection.datasource.getConnection();
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
log.error("Could not get the datasource",_esql_exception_<xsl:value-of select="generate-id(.)"/>);
throw new RuntimeException("Could not get the datasource "+_esql_exception_<xsl:value-of select="generate-id(.)"/>);
}
</xsl:when>
<xsl:otherwise>
<xsl:if test="esql:driver">
try {
Class.forName(String.valueOf(<xsl:copy-of select="$driver"/>)).newInstance();
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error loading driver: "+String.valueOf(<xsl:copy-of select="$driver"/>));
}
</xsl:if>
try {
<xsl:choose>
<xsl:when test="esql:username">
_esql_connection.connection = DriverManager.getConnection(
String.valueOf(<xsl:copy-of select="$dburl"/>),
String.valueOf(<xsl:copy-of select="$username"/>),
String.valueOf(<xsl:copy-of select="$password"/>)
);
</xsl:when>
<xsl:otherwise>
_esql_connection.connection = DriverManager.getConnection(
String.valueOf(<xsl:copy-of select="$dburl"/>)
);
</xsl:otherwise>
</xsl:choose>
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error opening connection to dburl: "+String.valueOf(<xsl:copy-of select="$dburl"/>));
}
</xsl:otherwise>
</xsl:choose>
try {
if ("false".equals(String.valueOf(<xsl:copy-of select="$autocommit"/>))) {
_esql_connection.connection.setAutoCommit(false);
} else {
_esql_connection.connection.setAutoCommit(true);
}
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error setting connection autocommit");
}
<xsl:apply-templates/>
} finally {
try {
if(!_esql_connection.connection.getAutoCommit()) {
_esql_connection.connection.commit();
}
<xsl:choose>
<xsl:when test="esql:pool and $environment = 'cocoon1'">
_esql_pool.releaseConnection(_esql_connection.db_connection);
</xsl:when>
<xsl:otherwise>
_esql_connection.connection.close();
</xsl:otherwise>
</xsl:choose>
if (_esql_connections.empty()) {
_esql_connection = null;
} else {
_esql_connection = (EsqlConnection)_esql_connections.pop();
}
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {}
}
</xsp:logic>
</xsl:template>
<xsl:template match="esql:connection/esql:driver"/>
<xsl:template match="esql:connection/esql:dburl"/>
<xsl:template match="esql:connection/esql:username"/>
<xsl:template match="esql:connection/esql:password"/>
<xsl:template match="esql:connection/esql:pool"/>
<xsl:template match="esql:connection/esql:autocommit"/>
<xsl:template match="esql:connection//esql:execute-query">
<xsl:variable name="query"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:query"/></xsl:call-template></xsl:variable>
<xsl:variable name="maxrows"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:max-rows"/></xsl:call-template></xsl:variable>
<xsl:variable name="skiprows"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:skip-rows"/></xsl:call-template></xsl:variable>
<xsp:logic>
if (_esql_query != null) {
_esql_queries.push(_esql_query);
}
_esql_query = new EsqlQuery();
_esql_query.query = String.valueOf(<xsl:copy-of select="$query"/>);
try {
_esql_query.max_rows = Integer.parseInt(String.valueOf(<xsl:copy-of select="$maxrows"/>));
} catch (NumberFormatException e) {}
try {
_esql_query.skip_rows = Integer.parseInt(String.valueOf(<xsl:copy-of select="$skiprows"/>));
} catch (NumberFormatException e) {}
try {
<xsl:choose>
<!-- this is a prepared statement -->
<xsl:when test="esql:query//esql:parameter">
try {
_esql_query.prepared_statement = _esql_connection.connection.prepareStatement(_esql_query.query);
} catch (SQLException _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error preparing statement: "+_esql_query.query);
}
_esql_query.statement = _esql_query.prepared_statement;
<xsl:for-each select="esql:query//esql:parameter">
try {
<xsl:text>_esql_query.prepared_statement.</xsl:text>
<xsl:choose>
<xsl:when test="@type">
<xsl:variable name="type"><xsl:value-of select="concat(translate(substring(@type,1,1),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'),substring(@type,2))"/></xsl:variable>
<xsl:text>set</xsl:text><xsl:value-of select="$type"/>(<xsl:value-of select="position()"/>,<xsl:call-template name="get-nested-content"><xsl:with-param name="content" select="."/></xsl:call-template>);<xsl:text>
</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:text>setString(</xsl:text><xsl:value-of select="position()"/>,String.valueOf(<xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="."/></xsl:call-template>));<xsl:text>
</xsl:text>
</xsl:otherwise>
</xsl:choose>
} catch (SQLException _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error setting parameter on statement: "+_esql_query.query);
}
</xsl:for-each>
try {
_esql_query.results = _esql_query.prepared_statement.execute();
} catch (SQLException _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("Error executed prepared statement: "+_esql_query.query);
}
</xsl:when>
<!-- this is a normal query -->
<xsl:otherwise>
_esql_query.statement = _esql_connection.connection.createStatement();
_esql_query.results = _esql_query.statement.execute(_esql_query.query);
</xsl:otherwise>
</xsl:choose>
if (_esql_query.results) {
_esql_query.resultset = _esql_query.statement.getResultSet();
_esql_query.resultset_metadata = _esql_query.resultset.getMetaData();
_esql_query.position = 0;
if (_esql_query.skip_rows > 0) {
while (_esql_query.resultset.next()) {
_esql_query.position++;
if (_esql_query.position == _esql_query.skip_rows) {
break;
}
}
}
<xsl:apply-templates select="esql:results"/>
<xsl:apply-templates select="esql:no-results"/>
_esql_query.resultset.close();
} else {
_esql_query.position = _esql_query.statement.getUpdateCount();
if (_esql_query.position >= 0) {
<xsl:apply-templates select="esql:update-results/*"/>
}
}
_esql_query.statement.close();
} catch (SQLException _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
try {
<xsl:choose>
<xsl:when test="esql:error-results">
_esql_exception = _esql_exception_<xsl:value-of select="generate-id(.)"/>;
_esql_exception_writer = new StringWriter();
_esql_exception.printStackTrace(new PrintWriter(_esql_exception_writer));
<xsl:apply-templates select="esql:error-results"/>
if (!_esql_connection.connection.getAutoCommit()) {
_esql_connection.connection.rollback();
}
</xsl:when>
<xsl:otherwise>
if (!_esql_connection.connection.getAutoCommit()) {
_esql_connection.connection.rollback();
}
</xsl:otherwise>
</xsl:choose>
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>_2) {}
}
if (_esql_queries.empty()) {
_esql_query = null;
} else {
_esql_query = (EsqlQuery)_esql_queries.pop();
}
</xsp:logic>
</xsl:template>
<xsl:template match="esql:query//esql:parameter">"?"</xsl:template>
<xsl:template match="esql:execute-query//esql:results">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="esql:execute-query//esql:error-results">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="esql:execute-query//esql:no-results">
<xsp:logic>
if (_esql_query.position == _esql_query.skip_rows) {
<xsl:apply-templates/>
}
</xsp:logic>
</xsl:template>
<xsl:template match="esql:update-results//esql:get-update-count">
<xsp:expr>_esql_query.position</xsp:expr>
</xsl:template>
<xsl:template match="esql:results//esql:row-results">
<xsp:logic>
while (_esql_query.resultset.next()) {
<xsl:apply-templates/>
_esql_query.position++;
if (_esql_query.max_rows != -1 && _esql_query.position - _esql_query.skip_rows == _esql_query.max_rows-1) {
break;
}
}
</xsp:logic>
</xsl:template>
<xspdoc:desc>results in a set of elements whose names are the names of the columns. the elements each have one text child, whose value is the value of the column interpreted as a string. No special formatting is allowed here. If you want to mess around with the names of the elements or the value of the text field, use the type-specific get methods and write out the result fragment yourself.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-columns">
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
<xsp:logic>
for (int _esql_i=1; _esql_i <= _esql_query.resultset_metadata.getColumnCount(); _esql_i++) {
Node _esql_node = document.createElement(_esql_query.resultset_metadata.getColumnName(_esql_i));
_esql_node.appendChild(document.createTextNode(
<xsl:call-template name="get-string-encoded">
<xsl:with-param name="column-spec">_esql_i</xsl:with-param>
<xsl:with-param name="resultset">_esql_query.resultset</xsl:with-param>
</xsl:call-template>
));
xspCurrentNode.appendChild(_esql_node);
}
</xsp:logic>
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
<xsp:logic>
for (int _esql_i = 1; _esql_i <= _esql_query.resultset_metadata.getColumnCount(); _esql_i++) {
String _esql_tagname = _esql_query.resultset_metadata.getColumnName(_esql_i);
<xsp:element>
<xsp:param name="name"><xsp:expr>_esql_tagname</xsp:expr></xsp:param>
<xsp:expr>
<xsl:call-template name="get-string-encoded">
<xsl:with-param name="column-spec">_esql_i</xsl:with-param>
<xsl:with-param name="resultset">_esql_query.resultset</xsl:with-param>
</xsl:call-template>
</xsp:expr>
</xsp:element>
}
this.characters("\n");
</xsp:logic>
</xsl:when>
<xsl:otherwise>
<xsp:logic>
throw new RuntimeException("esql:get-columns is not supported in this environment: "+<xsl:value-of select="$environment"/>);
</xsp:logic>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a string</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-string" name="get-string">
<xsp:expr>
<xsl:call-template name="get-string-encoded">
<xsl:with-param name="column-spec"><xsl:call-template name="get-column"/></xsl:with-param>
<xsl:with-param name="resultset"><xsl:call-template name="get-resultset"/></xsl:with-param>
</xsl:call-template>
</xsp:expr>
</xsl:template>
<xsl:template match="esql:row-results//esql:get-xml-string" name="get-xml-string">
<xsp:expr>
<xsl:call-template name="get-xml-encoded">
<xsl:with-param name="column-spec"><xsl:call-template name="get-column"/></xsl:with-param>
<xsl:with-param name="resultset"><xsl:call-template name="get-resultset"/></xsl:with-param>
</xsl:call-template>
</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a date. if a format attribute exists, its value is taken to be a date format string as defined in java.text.SimpleDateFormat, and the result is formatted accordingly.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-date">
<xsl:choose>
<xsl:when test="@format">
<xsp:expr>new SimpleDateFormat("<xsl:value-of select="@format"/>").format(<xsl:call-template name="get-resultset"/>.getDate(<xsl:call-template name="get-column"/>))</xsp:expr>
</xsl:when>
<xsl:otherwise>
<xsp:expr><xsl:call-template name="get-resultset"/>.getDate(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a time. if a format attribute exists, its value is taken to be a date format string as defined in java.text.SimpleDateFormat, and the result is formatted accordingly.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-time">
<xsl:choose>
<xsl:when test="@format">
<xsp:expr>new SimpleDateFormat("<xsl:value-of select="@format"/>").format(<xsl:call-template name="get-resultset"/>.getTime(<xsl:call-template name="get-column"/>))</xsp:expr>
</xsl:when>
<xsl:otherwise>
<xsp:expr><xsl:call-template name="get-resultset"/>.getTime(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a timestamp. if a format attribute exists, its value is taken to be a date format string as defined in java.text.SimpleDateFormat, and the result is formatted accordingly.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-timestamp">
<xsl:choose>
<xsl:when test="@format">
<xsp:expr>new SimpleDateFormat("<xsl:value-of select="@format"/>").format(<xsl:call-template name="get-resultset"/>.getTimestamp(<xsl:call-template name="get-column"/>))</xsp:expr>
</xsl:when>
<xsl:otherwise>
<xsp:expr><xsl:call-template name="get-resultset"/>.getTimestamp(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as true or false</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-boolean">
<xsp:expr><xsl:call-template name="get-resultset"/>.getBoolean(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a double. if a format attribute exists, its value is taken to be a decimal format string as defined in java.text.DecimalFormat, and the result is formatted accordingly.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-double">
<xsl:choose>
<xsl:when test="@format">
<xsp:expr>new DecimalFormat("<xsl:value-of select="@format"/>").format(new Double(<xsl:call-template name="get-resultset"/>.getDouble(<xsl:call-template name="get-column"/>)))</xsp:expr>
</xsl:when>
<xsl:otherwise>
<xsp:expr><xsl:call-template name="get-resultset"/>.getDouble(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a float. if a format attribute exists, its value is taken to be a decimal format string as defined in java.text.DecimalFormat, and the result is formatted accordingly.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-float">
<xsl:choose>
<xsl:when test="@format">
<xsp:expr>new DecimalFormat("<xsl:value-of select="@format"/>").format(new Float(<xsl:call-template name="get-resultset"/>.getFloat(<xsl:call-template name="get-column"/>)))</xsp:expr>
</xsl:when>
<xsl:otherwise>
<xsp:expr><xsl:call-template name="get-resultset"/>.getFloat(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the value of the given column as an integer</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-int">
<xsp:expr><xsl:call-template name="get-resultset"/>.getInt(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a long</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-long">
<xsp:expr><xsl:call-template name="get-resultset"/>.getLong(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the value of the given column as a short</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-short">
<xsp:expr><xsl:call-template name="get-resultset"/>.getShort(<xsl:call-template name="get-column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the value of the given column interpeted as an xml fragment.
The fragment is parsed by the default xsp parser and the document element is returned.
If a root attribute exists, its value is taken to be the name of an element to wrap around the contents of
the fragment before parsing.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-xml">
<xsl:variable name="content">
<xsl:choose>
<xsl:when test="@root">
<xsl:text>"<</xsl:text>
<xsl:value-of select="@root"/>
<xsl:text>>"+</xsl:text>
<xsl:call-template name="get-xml-string"/>
<xsl:text>+"</</xsl:text>
<xsl:value-of select="@root"/>
<xsl:text>>"</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:call-template name="get-xml-string"/>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<xsl:choose>
<xsl:when test="$environment = 'cocoon1'">
<xsp:expr>this.xspParser.parse(new InputSource(<xsl:copy-of select="$content"/>)).getDocumentElement()</xsp:expr>
<!--xsp:expr>this.xspParser.parse(new InputSource(new StringReader(<xsl:copy-of select="$content"/>))).getDocumentElement()</xsp:expr -->
</xsl:when>
<xsl:when test="$environment = 'cocoon2'">
<xsp:logic>
try {
XSPUtil.include(new InputSource(new StringReader(<xsl:copy-of select="$content"/>)),this.contentHandler,parser);
} catch (Exception _esql_exception_<xsl:value-of select="generate-id(.)"/>) {
throw new RuntimeException("error parsing xml: "+_esql_exception_<xsl:value-of select="generate-id(.)"/>.getMessage()+": "+String.valueOf(<xsl:copy-of select="$content"/>));
}
</xsp:logic>
</xsl:when>
<xsl:otherwise>
<xsp:logic>
throw new RuntimeException("esql:get-xml is not supported in this environment: "+<xsl:value-of select="$environment"/>);
</xsp:logic>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>returns the position of the current row in the result set</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-row-position|esql:results//esql:get-row-position">
<xsp:expr>_esql_query.position</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the name of the given column. the column mus tbe specified by number, not name.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-column-name">
<xsp:expr><xsl:call-template name="get-resultset"/>.getMetaData().getColumnName(<xsl:value-of select="@column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the label of the given column. the column mus tbe specified by number, not name.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-column-label">
<xsp:expr><xsl:call-template name="get-resultset"/>.getMetaData().getColumnLabel(<xsl:value-of select="@column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the name of the type of the given column. the column must be specified by number, not name.</xspdoc:desc>
<xsl:template match="esql:row-results//esql:get-column-type-name">
<xsp:expr><xsl:call-template name="get-resultset"/>.getMetaData().getColumnTypeName(<xsl:value-of select="@column"/>)</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the message of the current exception</xspdoc:desc>
<xsl:template match="esql:error-results//esql:get-message">
<xsp:expr>_esql_exception.getMessage()</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the current exception as a string</xspdoc:desc>
<xsl:template match="esql:error-results//esql:to-string">
<xsp:expr>_esql_exception.toString()</xsp:expr>
</xsl:template>
<xspdoc:desc>returns the stacktrace of the current exception</xspdoc:desc>
<xsl:template match="esql:error-results//esql:get-stacktrace">
<xsp:expr>_esql_exception_writer.toString()</xsp:expr>
</xsl:template>
<xsl:template name="get-resultset">
<xsl:call-template name="get-query"/><xsl:text>.resultset</xsl:text>
</xsl:template>
<xsl:template name="get-query">
<xsl:choose>
<xsl:when test="@ancestor">
<xsl:text>((EsqlQuery)_esql_queries.elementAt(_esql_queries.size()-</xsl:text>
<xsl:value-of select="@ancestor"/>
<xsl:text>))</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:text>_esql_query</xsl:text>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xspdoc:desc>used internally to determine which column is the given column. if a column attribute exists and its value is a number, it is taken to be the column's position. if the value is not a number, it is taken to be the column's name. if a column attribute does not exist, an esql:column element is assumed to exist and to render as a string (after all of the xsp instructions have been evaluated), which is taken to be the column's name.</xspdoc:desc>
<xsl:template name="get-column">
<xsl:choose>
<xsl:when test="@column">
<xsl:choose>
<xsl:when test="not(string(number(@column))='NaN')">
<xsl:value-of select="@column"/>
</xsl:when>
<xsl:otherwise>
<xsl:text>"</xsl:text>
<xsl:value-of select="@column"/>
<xsl:text>"</xsl:text>
</xsl:otherwise>
</xsl:choose>
</xsl:when>
<xsl:when test="esql:column">
<xsl:call-template name="get-nested-string">
<xsl:with-param name="content" select="esql:column"/>
</xsl:call-template>
</xsl:when>
</xsl:choose>
</xsl:template>
<xsl:template name="get-string-encoded">
<xsl:param name="column-spec"/>
<xsl:param name="resultset"/>
<xsl:variable name="encoding"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:encoding"/></xsl:call-template></xsl:variable>
<xsl:choose>
<xsl:when test="esql:encoding">
new String (<xsl:value-of select="$resultset"/>.getBytes
(<xsl:value-of select="$column-spec"/>), <xsl:value-of select="$encoding"/>)
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$resultset"/>.getString(<xsl:value-of select="$column-spec"/>)
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template name="get-xml-encoded">
<xsl:param name="column-spec"/>
<xsl:param name="resultset"/>
<xsl:variable name="encoding"><xsl:call-template name="get-nested-string"><xsl:with-param name="content" select="esql:encoding"/></xsl:call-template></xsl:variable>
<xsl:choose>
<xsl:when test="esql:encoding">
new String (<xsl:value-of select="$resultset"/>.getBytes
(<xsl:value-of select="$column-spec"/>), <xsl:value-of select="$encoding"/>)
</xsl:when>
<xsl:otherwise>
getXML(<xsl:value-of select="$resultset"/>,<xsl:value-of select="$column-spec"/>)
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<!-- added by mistake. Not needed, I think - RDG
<xsl:template name="add-xml-decl">
<xsl:choose>
<xsl:when test="@encoding">
"<?xml version=\"1.0\" encoding=\"<xsl:value-of select="@encoding"/>\"?>"
</xsl:when>
<xsl:otherwise>
"<?xml version=\"1.0\"?>"
</xsl:otherwise>
</xsl:choose>
+
</xsl:template>
-->
<xsl:template match="@*|node()" priority="-1">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
