Subject: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>
Subject: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/