Copyright (c) 2003 Mike Martin (TJDO) and others. All rights reserved.

Licensed 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.

Contributors:

2003 Kelly Grizzle (TJDO)

2003 Erik Bengtson  - removed exist() operation

2003 Erik Bengtson  - refactored the persistent id generator System property

2003 Andy Jefferson - added localiser

2003 Andy Jefferson - updated exception handling with SchemaTable

2003 Andy Jefferson - restructured to remove SchemaTable, and add StoreManagerHelper

2003 Andy Jefferson - updated getSubClassesForClass to recurse

2004 Erik Bengtson  - removed unused method and variables

2004 Erik Bengtson  - fixed problem with getObjectById for App ID in getClassForOID

2004 Andy Jefferson - re-emergence of SchemaTable. Addition of addClass().

2004 Andy Jefferson - Addition of AutoStartMechanism interface

2004 Andy Jefferson - Update to use Logger

2004 Andy Jefferson - Addition of Catalog name to accompany Schema name

2004 Marco Schulze  - replaced catch(NotPersistenceCapableException ...)

                  by advance-check via TypeManager.isSupportedType(...)

2004 Andy Jefferson - split StoreData into superclass.

2004 Andy Jefferson - added support for other inheritance types

2004 Andy Jefferson - added capability to dynamically add columns

2005 Marco Schulze - prevent closing starter during recursion of ClassAdder.addClassTables(...)

    ...

**********************************************************************/

* StoreManager for RDBMS datastores.

* Provided by the "store-manager" extension key "rdbms" and accepts datastore URLs valid for JDBC.

* <p>

* The RDBMS manager's responsibilities extend those for StoreManager to add :

* <ul>

* <li>creates and controls access to the data sources required for this datastore instance</li>

* <li>implements insert(), fetch(), update(), delete() in the interface to the StateManager.</li>

* <li>Providing cached access to JDBC database metadata (in particular column information).</li>

* <li>Resolving SQL identifier macros to actual SQL identifiers.</li>

* </ul>

* TODO Change RDBMSManager to share schema information (DatabaseMetaData) with other RDBMSManagers

*

* @version $Revision: 1.348 $

*/

    /** Localiser for messages. */

    protected static final Localiser LOCALISER_RDBMS = Localiser.getInstance("org.jpox.store.rdbms.Localisation",

        RDBMSManager.class.getClassLoader());

    /** The amount of time before we expire any cached column info. Hardcoded to five minutes. */

    private static final int COLUMN_INFO_EXPIRATION_MS = 5 * 60 * 1000;

    /** Catalog name for the RDBMS database */

    private String catalogName = null;

    /** Schema name for the RDBMS database */

    private String schemaName = null;

    /** Map of ColumnInfo for tables, keyed by the fully-qualified table name. */

    private Map columnInfoByTableName = new HashMap();

    /** Map of ColumnInfo for column name, keyed by the fully-qualified column name. */

    private Map columnInfoByColumnName = new HashMap();

    /** Timestamp when the ColumnInfo was refreshed. */

    private long columnInfoReadTimestamp = -1;

    /** The connectionProvider for this RDBMS **/

    private ConnectionProvider connProvider;

    /** Controller for SQL executed on this store. */

    private SQLController sqlController = null;

    /** Whether to check if table/view exists */

    protected final boolean checkExistTablesOrViews;

    /**

     * The active class adder transaction, if any. Some RDBMSManager methods are

     * called recursively in the course of adding new classes. This field allows

     * such methods to coordinate with the active ClassAdder transaction.

     * Recursive methods include:

     * <ul>

     * <li>addClasses()</li>

     * <li>addSetTable()</li>

     * <li>addMapTable()</li>

     * <li>addListTable()</li>

     * <li>addArrayTable()</li>

     * </ul>

     * Access is synchronized on the RDBMSManager itself.

     * Invariant: classAdder == null if RDBMSManager is unlocked.

     */

    private ClassAdder classAdder = null;

    /**

     * Object to use for locking the ClassAdder process. This could be revised with CORE-3409

     * and the above ClassAdder field to find a better locking strategy.

     * TODO This locks all RDBMSManager ClassAdder but should really only lock one

     */

    private final Object CLASSADDER_MUTEX = new Object();

    /**

     * Constructs a new RDBMSManager. On successful return the new RDBMSManager

     * will have successfully connected to the database with the given

     * credentials and determined the schema name, but will not have inspected

     * the schema contents any further. The contents (tables, views, etc.) will

     * be subsequently created and/or validated on-demand as the application

     * accesses persistent classes.

     * <p>

     * To avoid creating unnecessary redundant RDBMSManagers, new RDBMSManagers

     * should always be obtained from the {@link org.jpox.store.StoreManagerFactory},

     * rather than constructed directly.

     *

     * @param clr the ClassLoaderResolver

     * @param omf The corresponding PersistenceManagerFactory. This factory's non-tx data source will be

     *     used to get database connections as needed to perform management functions.

     * @exception JPOXDataStoreException If the database could not be accessed or the name of the

     *                schema could not be determined.

     */

    public RDBMSManager(ClassLoaderResolver clr, OMFContext omfContext)

    {

        super("rdbms", clr, omfContext);

        PersistenceConfiguration conf = omfContext.getPersistenceConfiguration();

        checkExistTablesOrViews = conf.getBooleanProperty("org.jpox.rdbms.CheckExistTablesOrViews");

        try

        {

            connProvider = (ConnectionProvider) omfContext.getPluginManager().createExecutableExtension(

                    "org.jpox.store_connectionprovider", "name",

                    conf.getStringProperty("org.jpox.store.connectionProvider.Name"),

                    "class-name", null, null);

            if (connProvider == null)