JDBC_SQLObjectFactory.java

  1. /*
  2.  * GovWay - A customizable API Gateway
  3.  * https://govway.org
  4.  *
  5.  * Copyright (c) 2005-2025 Link.it srl (https://link.it).
  6.  *
  7.  * This program is free software: you can redistribute it and/or modify
  8.  * it under the terms of the GNU General Public License version 3, as published by
  9.  * the Free Software Foundation.
  10.  *
  11.  * This program is distributed in the hope that it will be useful,
  12.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14.  * GNU General Public License for more details.
  15.  *
  16.  * You should have received a copy of the GNU General Public License
  17.  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  18.  *
  19.  */

  20. package org.openspcoop2.generic_project.dao.jdbc.utils;

  21. import org.openspcoop2.utils.TipiDatabase;
  22. import org.openspcoop2.utils.sql.ISQLQueryObject;
  23. import org.openspcoop2.utils.sql.SQLQueryObjectCore;
  24. import org.openspcoop2.utils.sql.SQLQueryObjectException;

  25. /**
  26.  * JDBC_SQLObjectFactory
  27.  *
  28.  * @author Poli Andrea (apoli@link.it)
  29.  * @author $Author$
  30.  * @version $Rev$, $Date$
  31.  */
  32. public class JDBC_SQLObjectFactory {

  33.     private boolean selectForUpdate = false;
  34.    
  35.     public boolean isSelectForUpdate() {
  36.         return this.selectForUpdate;
  37.     }

  38.     public void setSelectForUpdate(boolean selectForUpdate) {
  39.         this.selectForUpdate = selectForUpdate;
  40.     }

  41.     public ISQLQueryObject createSQLQueryObject(TipiDatabase tipoDatabase) throws SQLQueryObjectException{
  42.         ISQLQueryObject sqlQueryObject = null;
  43.         switch (tipoDatabase) {
  44.         case POSTGRESQL:
  45.             sqlQueryObject = new JDBC_PostgreSQLQueryObject(this);
  46.             break;
  47.         case MYSQL:
  48.             sqlQueryObject = new JDBC_MySQLQueryObject(this);
  49.             break;
  50.         case ORACLE:
  51.             sqlQueryObject = new JDBC_OracleQueryObject(this);
  52.             break;
  53.         case HSQL:
  54.             sqlQueryObject = new JDBC_HyperQueryObject(this);
  55.             break;
  56.         case DERBY:
  57.             sqlQueryObject = new JDBC_DerbyQueryObject(this);
  58.             break;
  59.         case SQLSERVER:
  60.             sqlQueryObject = new JDBC_SQLServerQueryObject(this);
  61.             break;
  62.         case DB2:
  63.             sqlQueryObject = new JDBC_DB2SQLQueryObject(this);
  64.             break;
  65.         case DEFAULT:
  66.             throw new SQLQueryObjectException("Tipo database non gestito ["+tipoDatabase+"]");
  67.         }
  68.         if(sqlQueryObject==null) {
  69.             throw new SQLQueryObjectException("Tipo database non gestito");
  70.         }  
  71.        
  72.         sqlQueryObject.setSelectForUpdate(this.selectForUpdate);
  73.         ((SQLQueryObjectCore)sqlQueryObject).setForceSelectForUpdateDisabledForNotQueryMethod(true);
  74.         return sqlQueryObject;
  75.     }
  76. }
  77.