001: /*
002: * $Header: /export/home/cvsroot/MyPersonalizerRepository/MyPersonalizer/Subsystems/Kernel/Sources/es/udc/mypersonalizer/kernel/model/repository/sql/storers/NativeEntityIdentifierGeneratorSingleton.java,v 1.1.1.1 2004/03/25 12:08:36 fbellas Exp $
003: * $Revision: 1.1.1.1 $
004: * $Date: 2004/03/25 12:08:36 $
005: *
006: * =============================================================================
007: *
008: * Copyright (c) 2003, The MyPersonalizer Development Group
009: * (http://www.tic.udc.es/~fbellas/mypersonalizer/index.html) at
010: * University Of A Coruna
011: * All rights reserved.
012: *
013: * Redistribution and use in source and binary forms, with or without
014: * modification, are permitted provided that the following conditions are met:
015: *
016: * - Redistributions of source code must retain the above copyright notice,
017: * this list of conditions and the following disclaimer.
018: *
019: * - Redistributions in binary form must reproduce the above copyright notice,
020: * this list of conditions and the following disclaimer in the documentation
021: * and/or other materials provided with the distribution.
022: *
023: * - Neither the name of the University Of A Coruna nor the names of its
024: * contributors may be used to endorse or promote products derived from
025: * this software without specific prior written permission.
026: *
027: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
028: * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
029: * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
030: * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
031: * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
032: * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
033: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
034: * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
035: * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
036: * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
037: * POSSIBILITY OF SUCH DAMAGE.
038: *
039: */
040:
041: package es.udc.mypersonalizer.kernel.model.repository.sql.storers;
042:
043: import java.sql.Connection;
044: import java.sql.ResultSet;
045: import java.sql.SQLException;
046: import java.sql.Statement;
047:
048: import es.udc.mypersonalizer.kernel.model.repository.sql.config.DatabaseConventionsConfigManager;
049: import es.udc.mypersonalizer.kernel.model.repository.sql.config.DatabaseSpecificsConfigManager;
050: import es.udc.mypersonalizer.kernel.model.repository.sql.config.DatabaseTemplatesConfig;
051: import es.udc.mypersonalizer.kernel.model.repository.sql.util.SQLOperations;
052: import es.udc.mypersonalizer.kernel.util.exceptions.InternalErrorException;
053:
054: /**
055: * Identifier generator for databases that natively support sequences.
056: *
057: * The template <code>next-id</code> is used to obtain the identifier.
058: *
059: * Uses the configuration bean
060: * {@link es.udc.mypersonalizer.kernel.model.repository.sql.config.DatabaseTemplatesConfig}
061: * to obtain the template query for retrieving the next identifier.
062: * @author Abel Muinho
063: * @since 1.0
064: */
065: public class NativeEntityIdentifierGeneratorSingleton extends
066: EntityIdentifierGeneratorSingleton {
067:
068: private String sequenceSuffix;
069:
070: private DatabaseTemplatesConfig databaseTemplates;
071:
072: public NativeEntityIdentifierGeneratorSingleton()
073: throws InternalErrorException {
074: super ();
075: sequenceSuffix = DatabaseConventionsConfigManager.getConfig()
076: .getSequenceSuffix();
077: databaseTemplates = DatabaseSpecificsConfigManager.getConfig()
078: .getDatabaseTemplatesConfig();
079: }
080:
081: public Long nextIdentifier(Connection connection,
082: String entityTableName) throws InternalErrorException {
083:
084: Statement statement = null;
085: try {
086: ResultSet resultSet;
087: String sequenceName = entityTableName + sequenceSuffix;
088: String queryString = databaseTemplates
089: .getNextId(sequenceName);
090:
091: /*
092: * Retrieve the next identifier from database.
093: */
094: statement = connection.createStatement();
095: resultSet = statement.executeQuery(queryString);
096: if (!resultSet.next()) {
097: throw new InternalErrorException(
098: "There is no sequence for " + entityTableName);
099: }
100: return new Long(resultSet.getLong(1));
101: } catch (SQLException e) {
102: throw new InternalErrorException(e);
103: } finally {
104: SQLOperations.closeStatement(statement);
105: }
106: }
107: }
|