ExternalConnection.java Source code

Introduction

Here is the source code for ExternalConnection.java

Source

/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements. See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership. The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the  "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
/*
 * $Id: ExternalConnection.java 470245 2006-11-02 06:34:33Z minchau $
 */
// 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.ConnectionPoolManager;

// Imported java classes
import java.io.StringReader;
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("org.apache.derby.jdbc.EmbeddedDriver");
        cp.setURL("jdbc:derby:sampleDB");
        //cp.setUser("sa");
        //cp.setPassword("");
        cp.setMinConnections(10);
        cp.setPoolEnabled(true);

        // Now let's register our connection pool so we can use
        // in a stylesheet
        ConnectionPoolManager pm = new ConnectionPoolManager();
        pm.registerPool("extpool", 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();

        // Grab the Name of the Stylesheet from the commad line
        if (args.length == 0) {
            System.out.println("You must provide the path and name to a stylesheet to process");
            System.exit(0);
        }

        String stylesheet = args[0];
        System.out.println("Transforming Stylesheet " + stylesheet);

        // 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(stylesheet));

        // For this transformation, all the required information is in the stylesheet, so generate 
        // a minimal XML source document for the input.
        // Note: the command-line processor (org.apache.xalan.xslt.Process) uses this strategy when 
        // the user does not provide an -IN parameter.
        StringReader reader = new StringReader("<?xml version=\"1.0\"?> <doc/>");

        // Use the Transformer to apply the associated Templates object to an XML document
        // and write the output to a file.
        transformer.transform(new StreamSource(reader), new StreamResult(new FileOutputStream("dbtest-out.html")));

        System.out.println("************* The result is in dbtest-out.html *************");

        cp.setPoolEnabled(false);
    }
}