/* * This program is free software; you can redistribute it and/or modify it under the * terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software * Foundation. * * You should have received a copy of the GNU Lesser General Public License along with this * program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html * or from the Free Software Foundation, Inc., * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. * * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. * See the GNU Lesser General Public License for more details. * * Copyright (c) 2009 Pentaho Corporation. All rights reserved. */ package org.pentaho.reporting.engine.classic.extensions.datasources.olap4j.connections; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.olap4j.OlapConnection; import org.olap4j.OlapWrapper; import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot; import org.pentaho.reporting.engine.classic.core.modules.misc.connections.DataSourceService; import org.pentaho.reporting.engine.classic.core.modules.misc.connections.DatasourceServiceException; import javax.sql.DataSource; import java.io.IOException; import java.io.ObjectInputStream; import java.sql.Connection; import java.sql.SQLException; import java.util.ArrayList; public class JndiConnectionProvider implements OlapConnectionProvider { private transient DataSourceService dataSourceService; private static final Log logger = LogFactory.getLog( JndiConnectionProvider.class ); private String connectionPath; private String username; private String password; public JndiConnectionProvider() { this.dataSourceService = ClassicEngineBoot.getInstance().getObjectFactory().get( DataSourceService.class ); } public String getConnectionPath() { return connectionPath; } public void setConnectionPath( final String connectionPath ) { this.connectionPath = connectionPath; } public String getUsername() { return username; } public void setUsername( final String username ) { this.username = username; } public String getPassword() { return password; } public void setPassword( final String password ) { this.password = password; } public OlapConnection createConnection( final String user, final String password ) throws SQLException { try { final DataSource ds = dataSourceService.getDataSource( connectionPath ); final String realUser; final String realPassword; if ( username != null ) { realUser = username; } else { realUser = user; } if ( this.password != null ) { realPassword = this.password; } else { realPassword = password; } if ( realUser == null ) { final Connection connection = ds.getConnection(); if ( connection == null ) { throw new SQLException( "JNDI DataSource is invalid; it returned null without throwing a meaningful error." ); } if ( connection instanceof OlapConnection ) { return (OlapConnection) connection; } if ( connection instanceof OlapWrapper ) { final OlapWrapper wrapper = (OlapWrapper) connection; return wrapper.unwrap( OlapConnection.class ); } throw new SQLException( "Unable to unwrap the connection: " + connectionPath ); //$NON-NLS-1$ } final Connection connection = ds.getConnection( realUser, realPassword ); if ( connection == null ) { throw new SQLException( "JNDI DataSource is invalid; it returned null without throwing a meaningful error." ); } if ( connection instanceof OlapConnection ) { return (OlapConnection) connection; } if ( connection instanceof OlapWrapper ) { final OlapWrapper wrapper = (OlapWrapper) connection; return wrapper.unwrap( OlapConnection.class ); } return connection.unwrap( OlapConnection.class ); } catch ( DatasourceServiceException ne ) { JndiConnectionProvider.logger.warn( "Failed to access the JDNI-System", ne ); throw new SQLException( "Failed to access the JNDI system" ); } } public Object getConnectionHash() { final ArrayList<Object> list = new ArrayList<Object>(); list.add( getClass().getName() ); list.add( connectionPath ); list.add( username ); return list; } public boolean equals( final Object o ) { if ( this == o ) { return true; } if ( o == null || getClass() != o.getClass() ) { return false; } final JndiConnectionProvider that = (JndiConnectionProvider) o; if ( connectionPath != null ? !connectionPath.equals( that.connectionPath ) : that.connectionPath != null ) { return false; } if ( password != null ? !password.equals( that.password ) : that.password != null ) { return false; } if ( username != null ? !username.equals( that.username ) : that.username != null ) { return false; } return true; } public int hashCode() { int result; result = ( connectionPath != null ? connectionPath.hashCode() : 0 ); result = 31 * result + ( username != null ? username.hashCode() : 0 ); result = 31 * result + ( password != null ? password.hashCode() : 0 ); return result; } private void readObject( final ObjectInputStream stream ) throws IOException, ClassNotFoundException { stream.defaultReadObject(); dataSourceService = ClassicEngineBoot.getInstance().getObjectFactory().get( DataSourceService.class ); } }