You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@xalan.apache.org by sb...@apache.org on 2001/01/04 11:01:01 UTC
cvs commit: xml-xalan/java/samples/SQLExtension/show-error dbinfo.xml dbtest.xsl
sboag 01/01/04 02:01:00
Added: java/samples/SQLExtension ConnectionPools.htm README
java/samples/SQLExtension/basic-connection dbinfo.xml
dbtest-cinfo.xsl dbtest.xsl
java/samples/SQLExtension/ext-connection
ExternalConnection.java dbtest.out dbtest.xml
dbtest.xsl
java/samples/SQLExtension/pquery dbinfo.xml
dbtest-pquery.xsl
java/samples/SQLExtension/show-error dbinfo.xml dbtest.xsl
Log:
John Gentilin <johnglinux@eyecatching.com> work,
for SQL Extensions.
Revision Changes Path
1.1 xml-xalan/java/samples/SQLExtension/ConnectionPools.htm
Index: ConnectionPools.htm
===================================================================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>SQL Extension; DB Connection Pools</title>
</head>
<body>
<hr />
<h2>Overview</h2>
<hr />
<p>
Database connection pools have been added to the Xalan SQL Extension
for two reasons.
<ol>
<li>A performance enhancement where consecutive transformation can reused
databse connections without reallocating resources from the JDBC Driver.
</li>
<li>A method to share databse connections created outside the scope of the
Xalan XSLT process with the stylesheets that use the SQL extensions
<li>
</ol>
</p>
<hr />
<h2>Requirments</h2>
<hr />
<p>
<DL>
<DT><i>Named Connection Pools</i></DT>
<DD>Connection Pools will be refered to by name to provide a linkage to
connection pools created outside the scope of the Xalan Processor. Named
Connection Pools will also provide a mechinsim to support non-native
connection used in JDBC 1.0 and JNDI references in JDBC 2.0
</DD>
<DT><i>Backwards Compatibility</i><DT>
<DD>If the existing connection mechinsim is used (constructors in
XConnection), crreate a connection pool on its behalf. The name of the
connecton pool will be the concatenation of the Driver name, DB URL,
User name and password.
</DD>
<DT><i>Connection Pool Wrapppers</i><DT>
<DD>Implement a connection pool interface that defines the required
beahvoiur for connection pools. This interface will be used to adapt
other connection mechinsims to the Xalan SQL Extensions
</DD>
<DT><i>Minimal Dependancies</i></DT>
<DD>The SQL Extension will implement a minimal default connection pool
mechinism. This will reduce the dependancy of third party libraries to
build and use the Xalan SQL Processor. Other wrappers can be written
to adapt third party connection pools to the processor. A sample of the
Apache Turbine project is planned as a sample for the project.
</DD>
</DL>
</p>
<hr />
<h2>Examples of Use</h2>
<hr />
<UL>
<li>Establishing a basic connection</li><br />
<code> Some code text</code>
<li>Establishing a connection by suppliying the connection information
in the XML </li><br />
<code> Some code text</code>
<li>Using a connecction that has been established outside the Xalan
Processor</li><br />
<code> Some code text</code>
</UL>
<hr />
<h2>SQL Results</h2>
<hr />
<hr />
<h2>Error Control</h2>
<hr />
</body>
</html>
1.1 xml-xalan/java/samples/SQLExtension/README
Index: README
===================================================================
Samples
Static login, Static Query
Login with XML Data, Static Query
Login with Ext Param, Static Query
Login with Ext Pool, Static Query
Login with XML Data,PQuery - Type with data, Data in XML
Login with XML Data, PQuery - Type with query, Data in XML
Login with XML Data, PQuery - Type with query, Data Ext Param
To Do,
Single XConnection constructor
Make a connect method that returns a NodeIterator
Create a Exception that will serianlze itself as a stree Node
Docs
How to Connect
How to execute a query
1.1 xml-xalan/java/samples/SQLExtension/basic-connection/dbinfo.xml
Index: dbinfo.xml
===================================================================
<dbtest>
<description>This file contains information required to make a connection to the DBMS</description>
<DBINFO>
<dbdriver>com.sybase.jdbc2.jdbc.SybDriver</dbdriver>
<dburl>jdbc:sybase:Tds:localhost:5000/smart911</dburl>
<user>sa</user>
<password/>
</DBINFO>
</dbtest>
1.1 xml-xalan/java/samples/SQLExtension/basic-connection/dbtest-cinfo.xsl
Index: dbtest-cinfo.xsl
===================================================================
<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">
<xsl:output method="html" indent="yes"/>
<xsl:param name="query" select=""SELECT FirstName, LastName, Street1, City, Zip FROM Account where AcctID='2019990000'""/>
<xsl:template match="/">
<!-- 1. Make the connection -->
<xsl:param name="cinfo" select="//DBINFO" />
<xsl:variable name="accounts"
select='sql:new($cinfo)'/>
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE border="1">
<!--2. Execute the query -->
<xsl:variable name="table" select='sql:query($accounts, $query)'/>
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="$table/row-set/row"/>
<xsl:text> </xsl:text>
</TABLE>
</BODY>
</HTML>
<!-- 3. Close the connection -->
<xsl:value-of select="sql:close($accounts)"/>
</xsl:template>
<xsl:template match="row">
<TR>
<xsl:apply-templates select="col"/>
</TR>
</xsl:template>
<xsl:template match="col">
<TD>
<!-- Here is the column data -->
<xsl:value-of select="text()"/>
</TD>
</xsl:template>
</xsl:stylesheet>
1.1 xml-xalan/java/samples/SQLExtension/basic-connection/dbtest.xsl
Index: dbtest.xsl
===================================================================
<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">
<xsl:output method="html" indent="yes"/>
<xsl:param name="query" select=""SELECT FirstName, LastName, Street1, City, Zip FROM Account where AcctID='2019990000'""/>
<xsl:template match="/">
<!-- 1. Make the connection -->
<xsl:variable name="accounts"
select="sql:new('com.sybase.jdbc2.jdbc.SybDriver',
'jdbc:sybase:Tds:localhost:5000/smart911', 'sa',
'')"/>
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE border="1">
<!--2. Execute the query -->
<xsl:variable name="table" select='sql:query($accounts, $query)'/>
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="$table/row-set/row"/>
<xsl:text> </xsl:text>
</TABLE>
</BODY>
</HTML>
<!-- 3. Close the connection -->
<xsl:value-of select="sql:close($accounts)"/>
</xsl:template>
<xsl:template match="row">
<TR>
<xsl:apply-templates select="col"/>
</TR>
</xsl:template>
<xsl:template match="col">
<TD>
<!-- Here is the column data -->
<xsl:value-of select="text()"/>
</TD>
</xsl:template>
</xsl:stylesheet>
1.1 xml-xalan/java/samples/SQLExtension/ext-connection/ExternalConnection.java
Index: ExternalConnection.java
===================================================================
/*
* The Apache Software License, Version 1.1
*
*
* Copyright (c) 1999 The Apache Software Foundation. All rights
* reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, 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 "XSLT4J" 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 apache@apache.org.
*
* 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 (INCLUDING, 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 based on software copyright (c) 1999, Lotus
* Development Corporation., http://www.lotus.com. For more
* information on the Apache Software Foundation, please see
* <http://www.apache.org/>.
*/
// Imported TraX classes
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.Transformer;
import javax.xml.transform.stream.StreamSource;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerConfigurationException;
import org.apache.xalan.lib.sql.DefaultConnectionPool;
import org.apache.xalan.lib.sql.XConnectionPoolManager;
// Imported java classes
import java.io.FileOutputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
/**
* Use the TraX interface to perform a transformation in the simplest manner possible
* (3 statements).
*/
public class ExternalConnection
{
public static void main(String[] args)
throws TransformerException, TransformerConfigurationException,
FileNotFoundException, IOException
{
// Create a connection to the database server
// Up the connection pool count for testing
DefaultConnectionPool cp = new DefaultConnectionPool();
cp.setDriver("com.sybase.jdbc2.jdbc.SybDriver");
cp.setURL("jdbc:sybase:Tds:localhost:5000/smart911");
cp.setUser("sa");
cp.setPassword("");
cp.setMinConnections(10);
cp.setActive(true);
// Now let's register our connection pool so we can use
// in a stylesheet
XConnectionPoolManager pm = new XConnectionPoolManager();
pm.registerPool("sybase", cp);
// Use the static TransformerFactory.newInstance() method to instantiate
// a TransformerFactory. The javax.xml.transform.TransformerFactory
// system property setting determines the actual class to instantiate --
// org.apache.xalan.transformer.TransformerImpl.
TransformerFactory tFactory = TransformerFactory.newInstance();
// Use the TransformerFactory to instantiate a Transformer that will work with
// the stylesheet you specify. This method call also processes the stylesheet
// into a compiled Templates object.
Transformer transformer = tFactory.newTransformer(
new StreamSource("dbtest.xsl"));
// Use the Transformer to apply the associated Templates object to an XML document
// (foo.xml) and write the output to a file (foo.out).
transformer.transform(
new StreamSource("dbtest.xml"),
new StreamResult(new FileOutputStream("dbtest.out")));
System.out.println("************* The result is in dbtest.out *************");
}
}
1.1 xml-xalan/java/samples/SQLExtension/ext-connection/dbtest.out
Index: dbtest.out
===================================================================
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
</HEAD>
<BODY>
<TABLE border="1">
<TR>
<TH>FirstName</TH><TH>LastName</TH><TH>Street1</TH><TH>City</TH><TH>Zip</TH>
</TR>
<TR>
<TD></TD><TD></TD><TD></TD><TD></TD><TD></TD>
</TR>
<TR>
<TD>Lawrence </TD><TD>Friesen </TD><TD>4010 Santa Rosa Ave </TD><TD>Tulare </TD><TD>92313</TD>
</TR>
</TABLE>
</BODY>
</HTML>
1.1 xml-xalan/java/samples/SQLExtension/ext-connection/dbtest.xml
Index: dbtest.xml
===================================================================
<dbtest>
<description>This file contains information required to make a connection to the DBMS</description>
<DBINFO>
<dbdriver>com.sybase.jdbc2.jdbc.SybDriver</dbdriver>
<dburl>jdbc:sybase:Tds:localhost:5000/smart911</dburl>
<user>sa</user>
<password/>
</DBINFO>
</dbtest>
1.1 xml-xalan/java/samples/SQLExtension/ext-connection/dbtest.xsl
Index: dbtest.xsl
===================================================================
<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">
<xsl:output method="html" indent="yes"/>
<xsl:param name="query" select=""SELECT FirstName, LastName, Street1, City, Zip FROM Account where AcctID='2019990000'""/>
<xsl:template match="/">
<!-- 1. Make the connection -->
<xsl:variable name="accounts"
select="sql:new('sybase')"/>
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE border="1">
<!--2. Execute the query -->
<xsl:variable name="table" select='sql:query($accounts, $query)'/>
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="$table/row-set/row"/>
<xsl:text> </xsl:text>
</TABLE>
</BODY>
</HTML>
<!-- 3. Close the connection -->
<xsl:value-of select="sql:close($accounts)"/>
</xsl:template>
<xsl:template match="row">
<TR>
<xsl:apply-templates select="col"/>
</TR>
</xsl:template>
<xsl:template match="col">
<TD>
<!-- Here is the column data -->
<xsl:value-of select="text()"/>
</TD>
</xsl:template>
</xsl:stylesheet>
1.1 xml-xalan/java/samples/SQLExtension/pquery/dbinfo.xml
Index: dbinfo.xml
===================================================================
<XMLSTORE>
<QUERY>
<ACCTID>2019990000</ACCTID>
</QUERY>
<DBINFO>
<dbdriver>com.sybase.jdbc2.jdbc.SybDriver</dbdriver>
<dburl>jdbc:sybase:Tds:localhost:5000/smart911</dburl>
<user>sa</user>
<password/>
</DBINFO>
</XMLSTORE>
1.1 xml-xalan/java/samples/SQLExtension/pquery/dbtest-pquery.xsl
Index: dbtest-pquery.xsl
===================================================================
<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">
<xsl:output method="html" indent="yes"/>
<xsl:param name="q1" select=""SELECT FirstName, LastName, Street1, City, Zip FROM Account where AcctID= ? ""/>
<xsl:param name="q1type" select="string"/>
<xsl:template match="/">
<!-- 1. Make the connection -->
<xsl:param name="cinfo" select="//DBINFO" />
<xsl:variable name="accounts"
select='sql:new($cinfo)'/>
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE border="1">
<!--2. Execute the query -->
<xsl:param name="q1param" select="//QUERY" />
<xsl:variable name="foo" select='sql:addParameterFromElement($accounts, $q1param)' />
<xsl:variable name="table" select='sql:pquery($accounts, $q1, $q1type)'/>
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="$table/row-set/row"/>
<xsl:text> </xsl:text>
</TABLE>
</BODY>
</HTML>
<!-- 3. Close the connection -->
<xsl:value-of select="sql:close($accounts)"/>
</xsl:template>
<xsl:template match="row">
<TR>
<xsl:apply-templates select="col"/>
</TR>
</xsl:template>
<xsl:template match="col">
<TD>
<!-- Here is the column data -->
<xsl:value-of select="text()"/>
</TD>
</xsl:template>
</xsl:stylesheet>
1.1 xml-xalan/java/samples/SQLExtension/show-error/dbinfo.xml
Index: dbinfo.xml
===================================================================
<XMLSTORE>
<USERPROFILE>
<USERNAME>gentijo</USERNAME>
<PASSWD>drowssap</PASSWD>
</USERPROFILE>
<QUERY>
<ACCTID>2019990000</ACCTID>
</QUERY>
<DBINFO>
<dbdriver>com.sybase.jdbc2.jdbc.SybDriver</dbdriver>
<dburl>jdbc:sybase:Tds:localhost:5000/smart911</dburl>
<user>sa</user>
<password/>
</DBINFO>
</XMLSTORE>
1.1 xml-xalan/java/samples/SQLExtension/show-error/dbtest.xsl
Index: dbtest.xsl
===================================================================
<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">
<xsl:output method="html" indent="yes"/>
<xsl:param name="query" select=""SELEC FirstName, LastName, Street1, City, Zip FROM Account where AcctID='2019990000'""/>
<xsl:template match="/">
<!-- 1. Make the connection -->
<xsl:variable name="accounts"
select="sql:new('com.sybase.jdbc2.jdbc.SybDriver',
'jdbc:sybase:Tds:localhost:5000/smart911', 'sa',
'')"/>
<!--2. Execute the query -->
<xsl:variable name="table" select='sql:query($accounts, $query)'/>
<xsl:apply-templates select="$table/row-set" />
<xsl:apply-templates select="$table/ext-error" />
<!-- 3. Close the connection -->
<xsl:value-of select="sql:close($accounts)"/>
</xsl:template>
<xsl:template match="row-set">
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE border="1">
<TR>
<!-- Get column-label attribute from each column-header-->
<xsl:for-each select="row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH>
</xsl:for-each>
</TR>
<xsl:apply-templates select="/row-set/row"/>
<xsl:text> </xsl:text>
</TABLE>
</BODY>
</HTML>
</xsl:template>
<xsl:template match="row">
<TR>
<xsl:apply-templates select="col"/>
</TR>
</xsl:template>
<xsl:template match="col">
<TD>
<!-- Here is the column data -->
<xsl:value-of select="text()"/>
</TD>
</xsl:template>
<xsl:template match="//ext-error">
<xsl:text>Woops, an error occured: </xsl:text>
<xsl:apply-templates />
</xsl:template>
</xsl:stylesheet>