/*
* 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.ui.datasources.jdbc;
import org.pentaho.di.core.database.DatabaseInterface;
import org.pentaho.di.core.database.DatabaseMeta;
import org.pentaho.di.core.database.GenericDatabaseMeta;
import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot;
import org.pentaho.reporting.libraries.base.config.Configuration;
public class DatabaseMapping
{
private DatabaseMapping()
{
}
public static DatabaseInterface getMappingForDriver(final String driverClass)
{
if (driverClass == null || driverClass.length() == 0)
{
return getGenericInterface();
}
final Configuration configuration = ClassicEngineBoot.getInstance().getGlobalConfig();
final String mappedInstance = configuration.getConfigProperty
("org.pentaho.reporting.ui.datasources.jdbc.driver-mapping." + driverClass);
final DatabaseInterface[] interfaces = DatabaseMeta.getDatabaseInterfaces();
for (int i = 0; i < interfaces.length; i++)
{
final DatabaseInterface databaseInterface = interfaces[i];
if (databaseInterface.getClass().getName().equals(mappedInstance))
{
return databaseInterface;
}
}
return mapTypeFromDriver(driverClass);
}
public static DatabaseInterface getGenericInterface()
{
// as kettle objects are so easy to break, we have to get the references from the public arrays out
// of kettle. There is no safe way (since numeric ids are deprecated) to actually reference a database
// meta object without hardcoding its ID.
final DatabaseInterface[] interfaces = DatabaseMeta.getDatabaseInterfaces();
for (int i = 0; i < interfaces.length; i++)
{
final DatabaseInterface anInterface = interfaces[i];
if ("GENERIC".equals(anInterface.getPluginId()))
{
return anInterface;
}
}
return null;
}
private static DatabaseInterface mapTypeFromDriver(final String driverClass)
{
if (driverClass == null)
{
return new GenericDatabaseMeta();
}
final DatabaseInterface[] interfaces = DatabaseMeta.getDatabaseInterfaces();
for (int i = 0; i < interfaces.length; i++)
{
final DatabaseInterface dbi = interfaces[i];
final int[] accessTypeList = dbi.getAccessTypeList();
for (int j = 0; j < accessTypeList.length; j++)
{
final int al = accessTypeList[j];
if (al != DatabaseMeta.TYPE_ACCESS_ODBC)
{
dbi.setAccessType(al);
if (driverClass.equals(dbi.getDriverClass()))
{
return dbi;
}
}
}
}
return new GenericDatabaseMeta();
}
}