XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » SQL extension for XSLT
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
latha yelchuruSubject: SQL extension for XSLT
Author: latha yelchuru
Date: 08 Dec 2006 10:22 AM
Hi,

I am working on SQL extensions on XSLT using xalan SQL Library. My requirement is to insert some data which comes in the form of XML to one of our tables. I tried to write a sample XSLT to retrieve the data from the database (thought I can change it to insert once I succeed retrieving data). The XSLT is not working. I think I am able to connect to database successfully but not able to retrieve any results. Any help would be greatly appreciated.

Thanks in advance,
Latha

Here is my sample XSLT.

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:sql="org.apache.xalan.lib.sql.XConnection"
extension-element-prefixes="sql"
xmlns:xalan="http://xml.apache.org/xalan"
exclude-result-prefixes="xalan"
>
<xsl:param name="queryString" select="'SELECT * FROM FASTATUS'"></xsl:param>
<xsl:output method="html" indent="yes"/>
<xsl:template match="/">
<xsl:variable name="dbObj" select="sql:new()"></xsl:variable>
<!-- Connect to the database with minimal error detection -->
<xsl:if test="not(sql:connect($dbObj, 'extpool'))" >
<xsl:message>Error Connecting to the Database</xsl:message>
<xsl:copy-of select="sql:getError($dbObj)/ext-error" />
</xsl:if>
<xsl:message>Database Coneection successful</xsl:message>
<HTML>
<HEAD>
<TITLE>List of Values</TITLE>
</HEAD>
<BODY>
<!--
Let's include Error Checking, the error is actually stored
in the connection since $table will be either data or null
-->
<xsl:variable name="table">
<xsl:copy-of select="sql:query($dbObj, $queryString)"/>
</xsl:variable>

<xsl:if test="not($table)" >
<xsl:message>Error in Query</xsl:message>
<xsl:copy-of select="sql:getError($dbObj)/ext-error" />
</xsl:if>
<xsl:message>Query execution successful</xsl:message>
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="$table/sql/metadata/column-header">
<TH>
<xsl:value-of select="@column-label"/>
</TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="$table/sql/row-set/row"/>
<xsl:text>&#10;</xsl:text>
</BODY>
</HTML>
<xsl:value-of select="sql:close($dbObj)"/>
</xsl:template>
<xsl:template match="row">
<TR><xsl:apply-templates select="col"/></TR>
</xsl:template>

<xsl:template match="col">
<TD><xsl:value-of select="text()"/></TD>
</xsl:template>
</xsl:stylesheet>
Posttop
Tony LavinioSubject: SQL extension for XSLT
Author: Tony Lavinio
Date: 11 Dec 2006 09:36 AM
If you are using Stylus Studio, you can use SQL/XML or XQuery.
If you want to use the Xalan extensions, you need to ask on a
Xalan-specific mailing list. There are several that might be
useful over at http://www.apache.org/
 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.