/*
* $Header: /home/cvs/jakarta-struts/contrib/service-manager/services/factory/src/org/apache/struts/service/factory/rowset/RowSetFactory.java,v 1.2 2002/12/08 07:53:31 rleland Exp $
* $Revision: 1.2 $
* $Date: 2002/12/08 07:53:31 $
*
* ====================================================================
*
* The Apache Software License, Version 1.1
*
* Copyright (c) 1999-2001 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 acknowlegement:
* "This product includes software developed by the
* Apache Software Foundation (http://www.apache.org/)."
* Alternately, this acknowlegement may appear in the software itself,
* if and wherever such third-party acknowlegements normally appear.
*
* 4. The names "The Jakarta Project", "Struts", 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 names without prior written
* permission of the Apache Group.
*
* 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. For more
* information on the Apache Software Foundation, please see
* <http://www.apache.org/>.
*
*/
package org.apache.struts.service.factory.rowset;
import java.lang.Throwable;
import javax.sql.DataSource;
import java.sql.SQLException;
import java.sql.Connection;
import sun.jdbc.rowset.CachedRowSet;
import javax.servlet.ServletException;
import org.apache.struts.service.factory.Factory;
import org.apache.struts.service.factory.Parameter;
import org.apache.struts.service.ServletServiceManager;
/**
* @author Oleg V Alexeev
* @version $Revision: 1.2 $ $Date: 2002/12/08 07:53:31 $
*/
public class RowSetFactory extends Factory {
public Object create( String type, Parameter[] parameters )
throws Throwable {
Connection conn = null;
CachedRowSet crs = new CachedRowSet();
RowSetFactoryMapping factoryMapping= ( RowSetFactoryMapping )getFactoryMapping();
String dataSourceName = factoryMapping.getDataSource();
DataSource dataSource = ((ServletServiceManager)getFactoryService().getServiceManager()).getStrutsDataSource( dataSourceName );
if( dataSource==null )
throw new ServletException( "DataSource '" +
dataSourceName + "' not found!");
try {
conn = dataSource.getConnection();
crs.setCommand( (String)parameters[0].getValue() );
for( int i = 1; i < parameters.length; i++ ) {
crs.setObject( i, parameters[i].getValue() );
}
crs.execute( conn );
} catch ( SQLException e ) {
try {
conn.close();
} catch ( Exception t ) {
;
}
} finally {
if( !factoryMapping.getStoreConnection() ) {
try {
conn.close();
} catch ( Exception e ) {
;
}
}
}
return new RowSetIterator( crs );
}
}