JDBCConfigurazioneFiltroServiceSearch.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.core.plugins.dao.jdbc;

  22. import org.openspcoop2.generic_project.dao.IDBServiceUtilities;
  23. import org.openspcoop2.generic_project.dao.jdbc.IJDBCServiceSearchWithId;
  24. import org.openspcoop2.core.plugins.IdConfigurazioneFiltro;
  25. import org.openspcoop2.generic_project.beans.InUse;
  26. import org.openspcoop2.generic_project.beans.IField;
  27. import org.openspcoop2.generic_project.beans.NonNegativeNumber;
  28. import org.openspcoop2.generic_project.beans.UnionExpression;
  29. import org.openspcoop2.generic_project.beans.Union;
  30. import org.openspcoop2.generic_project.beans.FunctionField;
  31. import org.openspcoop2.generic_project.dao.jdbc.JDBCServiceManagerProperties;
  32. import org.openspcoop2.generic_project.exception.ExpressionException;
  33. import org.openspcoop2.generic_project.exception.MultipleResultException;
  34. import org.openspcoop2.generic_project.exception.NotFoundException;
  35. import org.openspcoop2.generic_project.exception.NotImplementedException;
  36. import org.openspcoop2.generic_project.exception.ServiceException;
  37. import org.openspcoop2.generic_project.exception.ValidationException;
  38. import org.openspcoop2.generic_project.expression.IExpression;
  39. import org.openspcoop2.generic_project.expression.IPaginatedExpression;
  40. import org.openspcoop2.generic_project.expression.impl.sql.ISQLFieldConverter;
  41. import org.openspcoop2.generic_project.dao.jdbc.JDBCExpression;
  42. import org.openspcoop2.generic_project.dao.jdbc.JDBCPaginatedExpression;
  43. import org.openspcoop2.generic_project.dao.jdbc.JDBCProperties;
  44. import org.openspcoop2.generic_project.dao.jdbc.utils.IJDBCFetch;
  45. import org.openspcoop2.generic_project.dao.jdbc.utils.JDBC_SQLObjectFactory;

  47. import org.openspcoop2.core.plugins.ConfigurazioneFiltro;
  48. import org.openspcoop2.core.plugins.dao.IDBConfigurazioneFiltroServiceSearch;
  49. import org.openspcoop2.core.plugins.utils.ProjectInfo;

  51. import java.sql.Connection;
  52. import java.util.List;
  53. import java.util.Map;

  55. import org.slf4j.Logger;
  56. import org.openspcoop2.utils.sql.ISQLQueryObject;

  58. /**     
  59.  * Service can be used to search for the backend objects of type {@link org.openspcoop2.core.plugins.ConfigurazioneFiltro} 
  60.  *
  61.  * @author Poli Andrea (poli@link.it)
  62.  * @author $Author$
  63.  * @version $Rev$, $Date$
  64. */
  65. public class JDBCConfigurazioneFiltroServiceSearch implements IDBConfigurazioneFiltroServiceSearch, IDBServiceUtilities<ConfigurazioneFiltro> {


  68.     protected JDBCServiceManagerProperties jdbcProperties = null;
  69.     protected JDBCServiceManager jdbcServiceManager = null;
  70.     protected Logger log = null;
  71.     protected IJDBCServiceSearchWithId<ConfigurazioneFiltro, IdConfigurazioneFiltro, JDBCServiceManager> serviceSearch = null;
  72.     protected JDBC_SQLObjectFactory jdbcSqlObjectFactory = null;
  73.     public JDBCConfigurazioneFiltroServiceSearch(JDBCServiceManager jdbcServiceManager) throws ServiceException {
  74.         this.jdbcServiceManager = jdbcServiceManager;
  75.         this.jdbcProperties = jdbcServiceManager.getJdbcProperties();
  76.         this.log = jdbcServiceManager.getLog();
  77.         String msgInit = JDBCConfigurazioneFiltroServiceSearch.class.getName()+ " initialized";
  78.         this.log.debug(msgInit);
  79.         this.serviceSearch = JDBCProperties.getInstance(org.openspcoop2.core.plugins.dao.jdbc.JDBCServiceManager.class.getPackage(),ProjectInfo.getInstance()).getServiceSearch("configurazioneFiltro");
  80.         this.serviceSearch.setServiceManager(new JDBCLimitedServiceManager(this.jdbcServiceManager));
  81.         this.jdbcSqlObjectFactory = new JDBC_SQLObjectFactory();
  82.     }
  83.     
  84.     protected void logError(Exception e) {
  85.         if(e!=null && this.log!=null) {
  86.             this.log.error(e.getMessage(),e);
  87.         }
  88.     }
  89.     protected void logDebug(Exception e) {
  90.         if(e!=null && this.log!=null) {
  91.             this.log.debug(e.getMessage(),e);
  92.         }
  93.     }
  94.     protected void logJDBCExpression(JDBCExpression jdbcExpression) throws ExpressionException{
  95.         if(this.log!=null) {
  96.             String msgDebug = "sql = "+jdbcExpression.toSql();
  97.             this.log.debug(msgDebug);
  98.         }
  99.     }
  100.     protected void logJDBCPaginatedExpression(JDBCPaginatedExpression jdbcPaginatedExpression) throws ExpressionException{
  101.         if(this.log!=null) {
  102.             String msgDebug = "sql = "+jdbcPaginatedExpression.toSql();
  103.             this.log.debug(msgDebug);
  104.         }
  105.     }
  106.     
  107.     private static final String PARAMETER_TYPE_PREFIX = "Parameter (type:";
  108.         
  109.     private ServiceException newServiceExceptionParameterObjIsNull(){
  110.         return new ServiceException(PARAMETER_TYPE_PREFIX+ConfigurazioneFiltro.class.getName()+") 'obj' is null");
  111.     }
  112.     protected ServiceException newServiceExceptionParameterIdIsNull(){
  113.         return new ServiceException(PARAMETER_TYPE_PREFIX+IdConfigurazioneFiltro.class.getName()+") 'id' is null");
  114.     }
  115.     private ServiceException newServiceExceptionParameterIdMappingResolutionBehaviourIsNull(){
  116.         return new ServiceException(PARAMETER_TYPE_PREFIX+org.openspcoop2.generic_project.beans.IDMappingBehaviour.class.getName()+") 'idMappingResolutionBehaviour' is null");
  117.     }

  119.     protected ServiceException newServiceExceptionParameterExpressionWrongType(IExpression expression){
  120.         return new ServiceException(PARAMETER_TYPE_PREFIX+expression.getClass().getName()+") 'expression' has wrong type, expect "+JDBCExpression.class.getName());
  121.     }
  122.     protected ServiceException newServiceExceptionParameterExpressionIsNull(){
  123.         return new ServiceException(PARAMETER_TYPE_PREFIX+IExpression.class.getName()+") 'expression' is null");
  124.     }
  125.     
  126.     private ServiceException newServiceExceptionParameterPaginatedExpressionIsNull(){
  127.         return new ServiceException(PARAMETER_TYPE_PREFIX+IPaginatedExpression.class.getName()+") 'expression' is null");
  128.     }
  129.     private ServiceException newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated(){
  130.         return new ServiceException(PARAMETER_TYPE_PREFIX+IPaginatedExpression.class.getName()+") 'paginatedExpression' is null");
  131.     }
  132.     private ServiceException newServiceExceptionParameterPaginatedExpressionWrongType(IPaginatedExpression expression){
  133.         return new ServiceException(PARAMETER_TYPE_PREFIX+expression.getClass().getName()+") 'expression' has wrong type, expect "+JDBCPaginatedExpression.class.getName());
  134.     }
  135.     private ServiceException newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(IPaginatedExpression paginatedExpression){
  136.         return new ServiceException(PARAMETER_TYPE_PREFIX+paginatedExpression.getClass().getName()+") 'paginatedExpression' has wrong type, expect "+JDBCPaginatedExpression.class.getName());
  137.     }
  138.     
  139.     private ServiceException newServiceExceptionParameterUnionExpressionIsNull(){
  140.         return new ServiceException(PARAMETER_TYPE_PREFIX+UnionExpression.class.getName()+") 'unionExpression' is null");
  141.     }
  142.     
  143.     private ServiceException newServiceExceptionParameterWithTypeTableIdLessEqualsZero(){
  144.         return new ServiceException(PARAMETER_TYPE_PREFIX+IdConfigurazioneFiltro.class.getName()+") 'tableId' is lessEquals 0");
  145.     }
  146.     private ServiceException newServiceExceptionParameterTableIdLessEqualsZero(){
  147.         return new ServiceException("Parameter 'tableId' is less equals 0");
  148.     }
  149.     
  150.     @Override
  151.     public void validate(ConfigurazioneFiltro configurazioneFiltro) throws ServiceException,
  152.             ValidationException, NotImplementedException {
  153.         org.openspcoop2.generic_project.utils.XSDValidator.validate(configurazioneFiltro, this.log, 
  154.                 org.openspcoop2.core.plugins.utils.XSDValidator.getXSDValidator(this.log));
  155.     }
  156.     
  157.     @Override
  158.     public IJDBCFetch getFetch() {
  159.         return this.serviceSearch.getFetch();
  160.     }

  162.     @Override
  163.     public ISQLFieldConverter getFieldConverter() {
  164.         return this.serviceSearch.getFieldConverter();
  165.     }
  166.     
  167.     @Override
  168.     public IdConfigurazioneFiltro convertToId(ConfigurazioneFiltro obj)
  169.             throws ServiceException, NotImplementedException {
  170.         
  171.         Connection connection = null;
  172.         try{
  173.             
  174.             // check parameters
  175.             if(obj==null){
  176.                 throw this.newServiceExceptionParameterObjIsNull();
  177.             }
  178.             
  179.             // ISQLQueryObject
  180.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  181.             sqlQueryObject.setANDLogicOperator(true);
  182.             // Connection sql
  183.             connection = this.jdbcServiceManager.getConnection();
  184.         
  185.             return this.serviceSearch.convertToId(this.jdbcProperties,this.log,connection,sqlQueryObject,obj);
  186.         
  187.         }catch(ServiceException | NotImplementedException e){
  188.             this.logError(e); throw e;
  189.         }catch(Exception e){
  190.             this.logError(e); throw new ServiceException("ConvertToId not completed: "+e.getMessage(),e);
  191.         }finally{
  192.             if(connection!=null){
  193.                 this.jdbcServiceManager.closeConnection(connection);
  194.             }
  195.         }
  196.         
  197.     }
  198.         
  199.     @Override
  200.     public ConfigurazioneFiltro get(IdConfigurazioneFiltro id) throws ServiceException, NotFoundException,MultipleResultException, NotImplementedException {
  201.     
  202.         Connection connection = null;
  203.         try{
  204.             
  205.             // check parameters
  206.             if(id==null){
  207.                 throw this.newServiceExceptionParameterIdIsNull();
  208.             }
  209.             
  210.             // ISQLQueryObject
  211.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  212.             sqlQueryObject.setANDLogicOperator(true);
  213.             // Connection sql
  214.             connection = this.jdbcServiceManager.getConnection();
  215.         
  216.             return this.serviceSearch.get(this.jdbcProperties,this.log,connection,sqlQueryObject,id,null);
  217.         
  218.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  219.             this.logError(e); throw e;
  220.         }catch(NotFoundException e){
  221.             this.logDebug(e); throw e;
  222.         }catch(Exception e){
  223.             this.logError(e); throw new ServiceException("Get not completed: "+e.getMessage(),e);
  224.         }finally{
  225.             if(connection!=null){
  226.                 this.jdbcServiceManager.closeConnection(connection);
  227.             }
  228.         }
  229.     
  230.     }

  232.     @Override
  233.     public ConfigurazioneFiltro get(IdConfigurazioneFiltro id, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws ServiceException, NotFoundException,MultipleResultException, NotImplementedException {
  234.         Connection connection = null;
  235.         try{
  236.             
  237.             // check parameters
  238.             if(id==null){
  239.                 throw this.newServiceExceptionParameterIdIsNull();
  240.             }
  241.             if(idMappingResolutionBehaviour==null){
  242.                 throw this.newServiceExceptionParameterIdMappingResolutionBehaviourIsNull();
  243.             }
  244.             
  245.             // ISQLQueryObject
  246.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  247.             sqlQueryObject.setANDLogicOperator(true);
  248.             // Connection sql
  249.             connection = this.jdbcServiceManager.getConnection();
  250.         
  251.             return this.serviceSearch.get(this.jdbcProperties,this.log,connection,sqlQueryObject,id,idMappingResolutionBehaviour);
  252.         
  253.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  254.             this.logError(e); throw e;
  255.         }catch(NotFoundException e){
  256.             this.logDebug(e); throw e;
  257.         }catch(Exception e){
  258.             this.logError(e); throw new ServiceException("Get (idMappingResolutionBehaviour) not completed: "+e.getMessage(),e);
  259.         }finally{
  260.             if(connection!=null){
  261.                 this.jdbcServiceManager.closeConnection(connection);
  262.             }
  263.         }
  264.     
  265.     }

  267.     @Override
  268.     public boolean exists(IdConfigurazioneFiltro id) throws MultipleResultException,ServiceException,NotImplementedException {

  270.         Connection connection = null;
  271.         try{
  272.             
  273.             // check parameters
  274.             if(id==null){
  275.                 throw this.newServiceExceptionParameterIdIsNull();
  276.             }

  278.             // ISQLQueryObject
  279.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  280.             sqlQueryObject.setANDLogicOperator(true);
  281.             // Connection sql
  282.             connection = this.jdbcServiceManager.getConnection();

  284.             return this.serviceSearch.exists(this.jdbcProperties,this.log,connection,sqlQueryObject,id);
  285.     
  286.         }catch(MultipleResultException | ServiceException | NotImplementedException e){
  287.             this.logError(e); throw e;
  288.         }catch(Exception e){
  289.             this.logError(e); throw new ServiceException("Exists not completed: "+e.getMessage(),e);
  290.         }finally{
  291.             if(connection!=null){
  292.                 this.jdbcServiceManager.closeConnection(connection);
  293.             }
  294.         }
  295.         
  296.     }
  297.     
  298.     @Override
  299.     public List<IdConfigurazioneFiltro> findAllIds(IPaginatedExpression expression) throws ServiceException, NotImplementedException {

  301.         Connection connection = null;
  302.         try{
  303.             
  304.             // check parameters
  305.             if(expression==null){
  306.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  307.             }
  308.             if( ! (expression instanceof JDBCPaginatedExpression) ){
  309.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongType(expression);
  310.             }
  311.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) expression;
  312.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  314.             // ISQLQueryObject
  315.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  316.             sqlQueryObject.setANDLogicOperator(true);
  317.             // Connection sql
  318.             connection = this.jdbcServiceManager.getConnection();
  319.             
  320.             return this.serviceSearch.findAllIds(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,null);
  321.     
  322.         }catch(ServiceException | NotImplementedException e){
  323.             this.logError(e); throw e;
  324.         }catch(Exception e){
  325.             this.logError(e); throw new ServiceException("FindAllIds not completed: "+e.getMessage(),e);
  326.         }finally{
  327.             if(connection!=null){
  328.                 this.jdbcServiceManager.closeConnection(connection);
  329.             }
  330.         }
  331.         
  332.     }
  333.     
  334.     @Override
  335.     public List<IdConfigurazioneFiltro> findAllIds(IPaginatedExpression expression, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws ServiceException, NotImplementedException {

  337.         Connection connection = null;
  338.         try{
  339.             
  340.             // check parameters
  341.             if(idMappingResolutionBehaviour==null){
  342.                 throw this.newServiceExceptionParameterIdMappingResolutionBehaviourIsNull();
  343.             }
  344.             if(expression==null){
  345.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  346.             }
  347.             if( ! (expression instanceof JDBCPaginatedExpression) ){
  348.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongType(expression);
  349.             }
  350.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) expression;
  351.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  353.             // ISQLQueryObject
  354.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  355.             sqlQueryObject.setANDLogicOperator(true);
  356.             // Connection sql
  357.             connection = this.jdbcServiceManager.getConnection();
  358.             
  359.             return this.serviceSearch.findAllIds(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,idMappingResolutionBehaviour);
  360.     
  361.         }catch(ServiceException | NotImplementedException e){
  362.             this.logError(e); throw e;
  363.         }catch(Exception e){
  364.             this.logError(e); throw new ServiceException("FindAllIds not completed: "+e.getMessage(),e);
  365.         }finally{
  366.             if(connection!=null){
  367.                 this.jdbcServiceManager.closeConnection(connection);
  368.             }
  369.         }
  370.         
  371.     }

  373.     @Override
  374.     public List<ConfigurazioneFiltro> findAll(IPaginatedExpression expression) throws ServiceException, NotImplementedException {

  376.         Connection connection = null;
  377.         try{
  378.             
  379.             // check parameters
  380.             if(expression==null){
  381.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  382.             }
  383.             if( ! (expression instanceof JDBCPaginatedExpression) ){
  384.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongType(expression);
  385.             }
  386.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) expression;
  387.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  389.             // ISQLQueryObject
  390.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  391.             sqlQueryObject.setANDLogicOperator(true);
  392.             // Connection sql
  393.             connection = this.jdbcServiceManager.getConnection();

  395.             return this.serviceSearch.findAll(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,null);         
  396.     
  397.         }catch(ServiceException | NotImplementedException e){
  398.             this.logError(e); throw e;
  399.         }catch(Exception e){
  400.             this.logError(e); throw new ServiceException("FindAll not completed: "+e.getMessage(),e);
  401.         }finally{
  402.             if(connection!=null){
  403.                 this.jdbcServiceManager.closeConnection(connection);
  404.             }
  405.         }
  406.         
  407.     }
  408.     
  409.     @Override
  410.     public List<ConfigurazioneFiltro> findAll(IPaginatedExpression expression, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws ServiceException, NotImplementedException {

  412.         Connection connection = null;
  413.         try{
  414.             
  415.             // check parameters
  416.             if(idMappingResolutionBehaviour==null){
  417.                 throw this.newServiceExceptionParameterIdMappingResolutionBehaviourIsNull();
  418.             }
  419.             if(expression==null){
  420.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  421.             }
  422.             if( ! (expression instanceof JDBCPaginatedExpression) ){
  423.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongType(expression);
  424.             }
  425.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) expression;
  426.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  428.             // ISQLQueryObject
  429.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  430.             sqlQueryObject.setANDLogicOperator(true);
  431.             // Connection sql
  432.             connection = this.jdbcServiceManager.getConnection();

  434.             return this.serviceSearch.findAll(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,idMappingResolutionBehaviour);         
  435.     
  436.         }catch(ServiceException | NotImplementedException e){
  437.             this.logError(e); throw e;
  438.         }catch(Exception e){
  439.             this.logError(e); throw new ServiceException("FindAll not completed: "+e.getMessage(),e);
  440.         }finally{
  441.             if(connection!=null){
  442.                 this.jdbcServiceManager.closeConnection(connection);
  443.             }
  444.         }
  445.         
  446.     }

  448.     @Override
  449.     public ConfigurazioneFiltro find(IExpression expression) throws ServiceException, NotFoundException, MultipleResultException, NotImplementedException {

  451.         Connection connection = null;
  452.         try{
  453.             
  454.             // check parameters
  455.             if(expression==null){
  456.                 throw this.newServiceExceptionParameterExpressionIsNull();
  457.             }
  458.             if( ! (expression instanceof JDBCExpression) ){
  459.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  460.             }
  461.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  462.             this.logJDBCExpression(jdbcExpression);

  464.             // ISQLQueryObject
  465.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  466.             sqlQueryObject.setANDLogicOperator(true);
  467.             // Connection sql
  468.             connection = this.jdbcServiceManager.getConnection();

  470.             return this.serviceSearch.find(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression,null);         

  472.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  473.             this.logError(e); throw e;
  474.         }catch(NotFoundException e){
  475.             this.logDebug(e); throw e;
  476.         }catch(Exception e){
  477.             this.logError(e); throw new ServiceException("Find not completed: "+e.getMessage(),e);
  478.         }finally{
  479.             if(connection!=null){
  480.                 this.jdbcServiceManager.closeConnection(connection);
  481.             }
  482.         }
  483.         
  484.     }
  485.     
  486.     @Override
  487.     public ConfigurazioneFiltro find(IExpression expression, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws ServiceException, NotFoundException, MultipleResultException, NotImplementedException {

  489.         Connection connection = null;
  490.         try{
  491.             
  492.             // check parameters
  493.             if(idMappingResolutionBehaviour==null){
  494.                 throw this.newServiceExceptionParameterIdMappingResolutionBehaviourIsNull();
  495.             }
  496.             if(expression==null){
  497.                 throw this.newServiceExceptionParameterExpressionIsNull();
  498.             }
  499.             if( ! (expression instanceof JDBCExpression) ){
  500.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  501.             }
  502.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  503.             this.logJDBCExpression(jdbcExpression);

  505.             // ISQLQueryObject
  506.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  507.             sqlQueryObject.setANDLogicOperator(true);
  508.             // Connection sql
  509.             connection = this.jdbcServiceManager.getConnection();

  511.             return this.serviceSearch.find(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression,idMappingResolutionBehaviour);         

  513.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  514.             this.logError(e); throw e;
  515.         }catch(NotFoundException e){
  516.             this.logDebug(e); throw e;
  517.         }catch(Exception e){
  518.             this.logError(e); throw new ServiceException("Find not completed: "+e.getMessage(),e);
  519.         }finally{
  520.             if(connection!=null){
  521.                 this.jdbcServiceManager.closeConnection(connection);
  522.             }
  523.         }
  524.         
  525.     }

  527.     @Override
  528.     public NonNegativeNumber count(IExpression expression) throws ServiceException, NotImplementedException {

  530.         Connection connection = null;
  531.         try{
  532.             
  533.             // check parameters
  534.             if(expression==null){
  535.                 throw this.newServiceExceptionParameterExpressionIsNull();
  536.             }
  537.             if( ! (expression instanceof JDBCExpression) ){
  538.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  539.             }
  540.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  541.             this.logJDBCExpression(jdbcExpression);
  542.             
  543.             // ISQLQueryObject
  544.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  545.             sqlQueryObject.setANDLogicOperator(true);
  546.             // Connection sql
  547.             connection = this.jdbcServiceManager.getConnection();

  549.             return this.serviceSearch.count(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression);
  550.     
  551.         }catch(ServiceException | NotImplementedException e){
  552.             this.logError(e); throw e;
  553.         }catch(Exception e){
  554.             this.logError(e); throw new ServiceException("Count not completed: "+e.getMessage(),e);
  555.         }finally{
  556.             if(connection!=null){
  557.                 this.jdbcServiceManager.closeConnection(connection);
  558.             }
  559.         }
  560.         
  561.     }

  563.     @Override
  564.     public InUse inUse(IdConfigurazioneFiltro id) throws ServiceException, NotFoundException,NotImplementedException {

  566.         Connection connection = null;
  567.         try{
  568.             
  569.             // check parameters
  570.             if(id==null){
  571.                 throw this.newServiceExceptionParameterIdIsNull();
  572.             }
  573.             
  574.             // ISQLQueryObject
  575.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  576.             sqlQueryObject.setANDLogicOperator(true);
  577.             // Connection sql
  578.             connection = this.jdbcServiceManager.getConnection();

  580.             return this.serviceSearch.inUse(this.jdbcProperties,this.log,connection,sqlQueryObject,id); 
  581.     
  582.         }catch(ServiceException | NotImplementedException e){
  583.             this.logError(e); throw e;
  584.         }catch(NotFoundException e){
  585.             this.logDebug(e); throw e;
  586.         }catch(Exception e){
  587.             this.logError(e); throw new ServiceException("InUse not completed: "+e.getMessage(),e);
  588.         }finally{
  589.             if(connection!=null){
  590.                 this.jdbcServiceManager.closeConnection(connection);
  591.             }
  592.         }
  593.         
  594.     }
  595.     
  596.     @Override
  597.     public List<Object> select(IPaginatedExpression paginatedExpression, IField field) throws ServiceException,NotFoundException,NotImplementedException {
  598.     
  599.         Connection connection = null;
  600.         try{
  601.             
  602.             // check parameters
  603.             if(paginatedExpression==null){
  604.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated();
  605.             }
  606.             if( ! (paginatedExpression instanceof JDBCPaginatedExpression) ){
  607.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(paginatedExpression);
  608.             }
  609.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) paginatedExpression;
  610.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  612.             // ISQLQueryObject
  613.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  614.             sqlQueryObject.setANDLogicOperator(true);
  615.             // Connection sql
  616.             connection = this.jdbcServiceManager.getConnection();

  618.             return this.serviceSearch.select(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,field);         
  619.     
  620.         }catch(ServiceException | NotImplementedException e){
  621.             this.logError(e); throw e;
  622.         }catch(NotFoundException e){
  623.             this.logDebug(e); throw e;
  624.         }catch(Exception e){
  625.             this.logError(e); throw new ServiceException("Select 'field' not completed: "+e.getMessage(),e);
  626.         }finally{
  627.             if(connection!=null){
  628.                 this.jdbcServiceManager.closeConnection(connection);
  629.             }
  630.         }
  631.     
  632.     }
  633.     
  634.     @Override
  635.     public List<Object> select(IPaginatedExpression paginatedExpression, boolean distinct, IField field) throws ServiceException,NotFoundException,NotImplementedException {

  637.         Connection connection = null;
  638.         try{
  639.             
  640.             // check parameters
  641.             if(paginatedExpression==null){
  642.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated();
  643.             }
  644.             if( ! (paginatedExpression instanceof JDBCPaginatedExpression) ){
  645.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(paginatedExpression);
  646.             }
  647.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) paginatedExpression;
  648.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  650.             // ISQLQueryObject
  651.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  652.             sqlQueryObject.setANDLogicOperator(true);
  653.             // Connection sql
  654.             connection = this.jdbcServiceManager.getConnection();

  656.             return this.serviceSearch.select(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,distinct,field);            
  657.     
  658.         }catch(ServiceException | NotImplementedException e){
  659.             this.logError(e); throw e;
  660.         }catch(NotFoundException e){
  661.             this.logDebug(e); throw e;
  662.         }catch(Exception e){
  663.             this.logError(e); throw new ServiceException("Select 'distinct:"+distinct+"' field not completed: "+e.getMessage(),e);
  664.         }finally{
  665.             if(connection!=null){
  666.                 this.jdbcServiceManager.closeConnection(connection);
  667.             }
  668.         }
  669.         
  670.     }
  671.     
  672.     @Override
  673.     public List<Map<String,Object>> select(IPaginatedExpression paginatedExpression, IField ... field) throws ServiceException,NotFoundException,NotImplementedException {
  674.     
  675.         Connection connection = null;
  676.         try{
  677.             
  678.             // check parameters
  679.             if(paginatedExpression==null){
  680.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated();
  681.             }
  682.             if( ! (paginatedExpression instanceof JDBCPaginatedExpression) ){
  683.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(paginatedExpression);
  684.             }
  685.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) paginatedExpression;
  686.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  688.             // ISQLQueryObject
  689.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  690.             sqlQueryObject.setANDLogicOperator(true);
  691.             // Connection sql
  692.             connection = this.jdbcServiceManager.getConnection();

  694.             return this.serviceSearch.select(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,field);         
  695.     
  696.         }catch(ServiceException | NotImplementedException e){
  697.             this.logError(e); throw e;
  698.         }catch(NotFoundException e){
  699.             this.logDebug(e); throw e;
  700.         }catch(Exception e){
  701.             this.logError(e); throw new ServiceException("Select not completed: "+e.getMessage(),e);
  702.         }finally{
  703.             if(connection!=null){
  704.                 this.jdbcServiceManager.closeConnection(connection);
  705.             }
  706.         }
  707.     
  708.     }
  709.     @Override
  710.     public List<Map<String,Object>> select(IPaginatedExpression paginatedExpression, boolean distinct, IField ... field) throws ServiceException,NotFoundException,NotImplementedException {

  712.         Connection connection = null;
  713.         try{
  714.             
  715.             // check parameters
  716.             if(paginatedExpression==null){
  717.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated();
  718.             }
  719.             if( ! (paginatedExpression instanceof JDBCPaginatedExpression) ){
  720.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(paginatedExpression);
  721.             }
  722.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) paginatedExpression;
  723.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  725.             // ISQLQueryObject
  726.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  727.             sqlQueryObject.setANDLogicOperator(true);
  728.             // Connection sql
  729.             connection = this.jdbcServiceManager.getConnection();

  731.             return this.serviceSearch.select(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,distinct,field);            
  732.     
  733.         }catch(ServiceException | NotImplementedException e){
  734.             this.logError(e); throw e;
  735.         }catch(NotFoundException e){
  736.             this.logDebug(e); throw e;
  737.         }catch(Exception e){
  738.             this.logError(e); throw new ServiceException("Select distinct:"+distinct+" not completed: "+e.getMessage(),e);
  739.         }finally{
  740.             if(connection!=null){
  741.                 this.jdbcServiceManager.closeConnection(connection);
  742.             }
  743.         }
  744.         
  745.     }
  746.     
  747.     @Override
  748.     public Object aggregate(IExpression expression, FunctionField functionField) throws ServiceException,NotFoundException,NotImplementedException {

  750.         Connection connection = null;
  751.         try{
  752.             
  753.             // check parameters
  754.             if(expression==null){
  755.                 throw this.newServiceExceptionParameterExpressionIsNull();
  756.             }
  757.             if( ! (expression instanceof JDBCExpression) ){
  758.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  759.             }
  760.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  761.             this.logJDBCExpression(jdbcExpression);

  763.             // ISQLQueryObject
  764.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  765.             sqlQueryObject.setANDLogicOperator(true);
  766.             // Connection sql
  767.             connection = this.jdbcServiceManager.getConnection();

  769.             return this.serviceSearch.aggregate(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression,functionField);           
  770.     
  771.         }catch(ServiceException | NotImplementedException e){
  772.             this.logError(e); throw e;
  773.         }catch(NotFoundException e){
  774.             this.logDebug(e); throw e;
  775.         }catch(Exception e){
  776.             this.logError(e); throw new ServiceException("Aggregate not completed: "+e.getMessage(),e);
  777.         }finally{
  778.             if(connection!=null){
  779.                 this.jdbcServiceManager.closeConnection(connection);
  780.             }
  781.         }
  782.         
  783.     }
  784.     
  785.     @Override
  786.     public Map<String,Object> aggregate(IExpression expression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException {

  788.         Connection connection = null;
  789.         try{
  790.             
  791.             // check parameters
  792.             if(expression==null){
  793.                 throw this.newServiceExceptionParameterExpressionIsNull();
  794.             }
  795.             if( ! (expression instanceof JDBCExpression) ){
  796.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  797.             }
  798.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  799.             this.logJDBCExpression(jdbcExpression);

  801.             // ISQLQueryObject
  802.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  803.             sqlQueryObject.setANDLogicOperator(true);
  804.             // Connection sql
  805.             connection = this.jdbcServiceManager.getConnection();

  807.             return this.serviceSearch.aggregate(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression,functionField);           
  808.     
  809.         }catch(ServiceException | NotImplementedException e){
  810.             this.logError(e); throw e;
  811.         }catch(NotFoundException e){
  812.             this.logDebug(e); throw e;
  813.         }catch(Exception e){
  814.             this.logError(e); throw new ServiceException("Aggregate not completed: "+e.getMessage(),e);
  815.         }finally{
  816.             if(connection!=null){
  817.                 this.jdbcServiceManager.closeConnection(connection);
  818.             }
  819.         }
  820.         
  821.     }
  822.     
  823.     @Override
  824.     public List<Map<String,Object>> groupBy(IExpression expression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException {

  826.         Connection connection = null;
  827.         try{
  828.             
  829.             // check parameters
  830.             if(expression==null){
  831.                 throw this.newServiceExceptionParameterExpressionIsNull();
  832.             }
  833.             if( ! (expression instanceof JDBCExpression) ){
  834.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  835.             }
  836.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  837.             this.logJDBCExpression(jdbcExpression);

  839.             // ISQLQueryObject
  840.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  841.             sqlQueryObject.setANDLogicOperator(true);
  842.             // Connection sql
  843.             connection = this.jdbcServiceManager.getConnection();

  845.             return this.serviceSearch.groupBy(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression,functionField);         
  846.     
  847.         }catch(ServiceException | NotImplementedException e){
  848.             this.logError(e); throw e;
  849.         }catch(NotFoundException e){
  850.             this.logDebug(e); throw e;
  851.         }catch(Exception e){
  852.             this.logError(e); throw new ServiceException("GroupBy not completed: "+e.getMessage(),e);
  853.         }finally{
  854.             if(connection!=null){
  855.                 this.jdbcServiceManager.closeConnection(connection);
  856.             }
  857.         }
  858.         
  859.     }
  860.     
  861.     @Override
  862.     public List<Map<String,Object>> groupBy(IPaginatedExpression paginatedExpression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException {

  864.         Connection connection = null;
  865.         try{
  866.             
  867.             // check parameters
  868.             if(paginatedExpression==null){
  869.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNullErrorParameterPaginated();
  870.             }
  871.             if( ! (paginatedExpression instanceof JDBCPaginatedExpression) ){
  872.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongTypeErrorParameterPaginated(paginatedExpression);
  873.             }
  874.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) paginatedExpression;
  875.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  877.             // ISQLQueryObject
  878.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  879.             sqlQueryObject.setANDLogicOperator(true);
  880.             // Connection sql
  881.             connection = this.jdbcServiceManager.getConnection();

  883.             return this.serviceSearch.groupBy(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression,functionField);            
  884.     
  885.         }catch(ServiceException | NotImplementedException e){
  886.             this.logError(e); throw e;
  887.         }catch(NotFoundException e){
  888.             this.logDebug(e); throw e;
  889.         }catch(Exception e){
  890.             this.logError(e); throw new ServiceException("GroupBy not completed: "+e.getMessage(),e);
  891.         }finally{
  892.             if(connection!=null){
  893.                 this.jdbcServiceManager.closeConnection(connection);
  894.             }
  895.         }
  896.         
  897.     }
  898.     
  899.     @Override
  900.     public List<Map<String,Object>> union(Union union, UnionExpression ... unionExpression) throws ServiceException,NotFoundException,NotImplementedException {

  902.         Connection connection = null;
  903.         try{
  904.             
  905.             // check parameters
  906.             if(unionExpression==null){
  907.                 throw this.newServiceExceptionParameterUnionExpressionIsNull();
  908.             }
  909.             
  910.             // ISQLQueryObject
  911.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  912.             sqlQueryObject.setANDLogicOperator(true);
  913.             // Connection sql
  914.             connection = this.jdbcServiceManager.getConnection();

  916.             return this.serviceSearch.union(this.jdbcProperties,this.log,connection,sqlQueryObject,union,unionExpression);          
  917.     
  918.         }catch(ServiceException | NotImplementedException e){
  919.             this.logError(e); throw e;
  920.         }catch(NotFoundException e){
  921.             this.logDebug(e); throw e;
  922.         }catch(Exception e){
  923.             this.logError(e); throw new ServiceException("Union not completed: "+e.getMessage(),e);
  924.         }finally{
  925.             if(connection!=null){
  926.                 this.jdbcServiceManager.closeConnection(connection);
  927.             }
  928.         }
  929.         
  930.     }
  931.     
  932.     @Override
  933.     public NonNegativeNumber unionCount(Union union, UnionExpression ... unionExpression) throws ServiceException,NotFoundException,NotImplementedException {

  935.         Connection connection = null;
  936.         try{
  937.             
  938.             // check parameters
  939.             if(unionExpression==null){
  940.                 throw this.newServiceExceptionParameterUnionExpressionIsNull();
  941.             }
  942.             
  943.             // ISQLQueryObject
  944.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  945.             sqlQueryObject.setANDLogicOperator(true);
  946.             // Connection sql
  947.             connection = this.jdbcServiceManager.getConnection();

  949.             return this.serviceSearch.unionCount(this.jdbcProperties,this.log,connection,sqlQueryObject,union,unionExpression);         
  950.     
  951.         }catch(ServiceException | NotImplementedException e){
  952.             this.logError(e); throw e;
  953.         }catch(NotFoundException e){
  954.             this.logDebug(e); throw e;
  955.         }catch(Exception e){
  956.             this.logError(e); throw new ServiceException("UnionCount not completed: "+e.getMessage(),e);
  957.         }finally{
  958.             if(connection!=null){
  959.                 this.jdbcServiceManager.closeConnection(connection);
  960.             }
  961.         }
  962.         
  963.     }

  965.     @Override
  966.     public IExpression newExpression() throws ServiceException,NotImplementedException {

  968.         return this.serviceSearch.newExpression(this.log);

  970.     }

  972.     @Override
  973.     public IPaginatedExpression newPaginatedExpression() throws ServiceException, NotImplementedException {

  975.         return this.serviceSearch.newPaginatedExpression(this.log);

  977.     }
  978.     
  979.     @Override
  980.     public IExpression toExpression(IPaginatedExpression paginatedExpression) throws ServiceException,NotImplementedException {

  982.         return this.serviceSearch.toExpression((JDBCPaginatedExpression)paginatedExpression,this.log);

  984.     }

  986.     @Override
  987.     public IPaginatedExpression toPaginatedExpression(IExpression expression) throws ServiceException, NotImplementedException {

  989.         return this.serviceSearch.toPaginatedExpression((JDBCExpression)expression,this.log);

  991.     }
  992.     

  994.     // -- DB
  995.     
  996.     @Override
  997.     public void mappingTableIds(IdConfigurazioneFiltro id, ConfigurazioneFiltro obj) throws ServiceException,NotFoundException,NotImplementedException{
  998.         Connection connection = null;
  999.         try{
  1000.             
  1001.             // check parameters
  1002.             if(id==null){
  1003.                 throw this.newServiceExceptionParameterIdIsNull();
  1004.             }
  1005.             if(obj==null){
  1006.                 throw this.newServiceExceptionParameterObjIsNull();
  1007.             }
  1008.             
  1009.             // ISQLQueryObject
  1010.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1011.             sqlQueryObject.setANDLogicOperator(true);
  1012.             // Connection sql
  1013.             connection = this.jdbcServiceManager.getConnection();
  1014.         
  1015.             this.serviceSearch.mappingTableIds(this.jdbcProperties,this.log,connection,sqlQueryObject,id,obj);
  1016.         
  1017.         }catch(ServiceException | NotImplementedException e){
  1018.             this.logError(e); throw e;
  1019.         }catch(NotFoundException e){
  1020.             this.logDebug(e); throw e;
  1021.         }catch(Exception e){
  1022.             this.logError(e); throw new ServiceException("mappingIds(IdObject) not completed: "+e.getMessage(),e);
  1023.         }finally{
  1024.             if(connection!=null){
  1025.                 this.jdbcServiceManager.closeConnection(connection);
  1026.             }
  1027.         }
  1028.     }
  1029.     
  1030.     @Override
  1031.     public void mappingTableIds(long tableId, ConfigurazioneFiltro obj) throws ServiceException,NotFoundException,NotImplementedException{
  1032.         Connection connection = null;
  1033.         try{
  1034.             
  1035.             // check parameters
  1036.             if(tableId<=0){
  1037.                 throw this.newServiceExceptionParameterWithTypeTableIdLessEqualsZero();
  1038.             }
  1039.             if(obj==null){
  1040.                 throw this.newServiceExceptionParameterObjIsNull();
  1041.             }
  1042.             
  1043.             // ISQLQueryObject
  1044.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1045.             sqlQueryObject.setANDLogicOperator(true);
  1046.             // Connection sql
  1047.             connection = this.jdbcServiceManager.getConnection();
  1048.         
  1049.             this.serviceSearch.mappingTableIds(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId,obj);
  1050.         
  1051.         }catch(ServiceException | NotImplementedException e){
  1052.             this.logError(e); throw e;
  1053.         }catch(NotFoundException e){
  1054.             this.logDebug(e); throw e;
  1055.         }catch(Exception e){
  1056.             this.logError(e); throw new ServiceException("mappingIds(tableId) not completed: "+e.getMessage(),e);
  1057.         }finally{
  1058.             if(connection!=null){
  1059.                 this.jdbcServiceManager.closeConnection(connection);
  1060.             }
  1061.         }
  1062.     }
  1063.         
  1064.     @Override
  1065.     public ConfigurazioneFiltro get(long tableId) throws ServiceException, NotFoundException,MultipleResultException, NotImplementedException {
  1066.     
  1067.         Connection connection = null;
  1068.         try{
  1069.             
  1070.             // check parameters
  1071.             if(tableId<=0){
  1072.                 throw this.newServiceExceptionParameterTableIdLessEqualsZero();
  1073.             }
  1074.             
  1075.             // ISQLQueryObject
  1076.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1077.             sqlQueryObject.setANDLogicOperator(true);
  1078.             // Connection sql
  1079.             connection = this.jdbcServiceManager.getConnection();
  1080.         
  1081.             return this.serviceSearch.get(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId,null);
  1082.         
  1083.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  1084.             this.logError(e); throw e;
  1085.         }catch(NotFoundException e){
  1086.             this.logDebug(e); throw e;
  1087.         }catch(Exception e){
  1088.             this.logError(e); throw new ServiceException("Get(tableId) not completed: "+e.getMessage(),e);
  1089.         }finally{
  1090.             if(connection!=null){
  1091.                 this.jdbcServiceManager.closeConnection(connection);
  1092.             }
  1093.         }
  1094.     
  1095.     }
  1096.     
  1097.     @Override
  1098.     public ConfigurazioneFiltro get(long tableId,org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws ServiceException, NotFoundException,MultipleResultException, NotImplementedException {
  1099.     
  1100.         Connection connection = null;
  1101.         try{
  1102.             
  1103.             // check parameters
  1104.             if(tableId<=0){
  1105.                 throw this.newServiceExceptionParameterTableIdLessEqualsZero();
  1106.             }
  1107.             if(idMappingResolutionBehaviour==null){
  1108.                 throw this.newServiceExceptionParameterIdMappingResolutionBehaviourIsNull();
  1109.             }
  1110.             
  1111.             // ISQLQueryObject
  1112.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1113.             sqlQueryObject.setANDLogicOperator(true);
  1114.             // Connection sql
  1115.             connection = this.jdbcServiceManager.getConnection();
  1116.         
  1117.             return this.serviceSearch.get(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId,idMappingResolutionBehaviour);
  1118.         
  1119.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  1120.             this.logError(e); throw e;
  1121.         }catch(NotFoundException e){
  1122.             this.logDebug(e); throw e;
  1123.         }catch(Exception e){
  1124.             this.logError(e); throw new ServiceException("Get(tableId,idMappingResolutionBehaviour) not completed: "+e.getMessage(),e);
  1125.         }finally{
  1126.             if(connection!=null){
  1127.                 this.jdbcServiceManager.closeConnection(connection);
  1128.             }
  1129.         }
  1130.     
  1131.     }
  1132.     
  1133.     @Override
  1134.     public boolean exists(long tableId) throws MultipleResultException,ServiceException,NotImplementedException {

  1136.         Connection connection = null;
  1137.         try{
  1138.             
  1139.             // check parameters
  1140.             if(tableId<=0){
  1141.                 throw this.newServiceExceptionParameterTableIdLessEqualsZero();
  1142.             }

  1144.             // ISQLQueryObject
  1145.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1146.             sqlQueryObject.setANDLogicOperator(true);
  1147.             // Connection sql
  1148.             connection = this.jdbcServiceManager.getConnection();

  1150.             return this.serviceSearch.exists(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId);           
  1151.     
  1152.         }catch(MultipleResultException | ServiceException | NotImplementedException e){
  1153.             this.logError(e); throw e;
  1154.         }catch(Exception e){
  1155.             this.logError(e); throw new ServiceException("Exists(tableId) not completed: "+e.getMessage(),e);
  1156.         }finally{
  1157.             if(connection!=null){
  1158.                 this.jdbcServiceManager.closeConnection(connection);
  1159.             }
  1160.         }
  1161.         
  1162.     }
  1163.     
  1164.     @Override
  1165.     public List<Long> findAllTableIds(IPaginatedExpression expression) throws ServiceException, NotImplementedException {
  1166.         
  1167.         Connection connection = null;
  1168.         try{
  1169.             
  1170.             // check parameters
  1171.             if(expression==null){
  1172.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  1173.             }
  1174.             if( ! (expression instanceof JDBCPaginatedExpression) ){
  1175.                 throw this.newServiceExceptionParameterPaginatedExpressionWrongType(expression);
  1176.             }
  1177.             JDBCPaginatedExpression jdbcPaginatedExpression = (JDBCPaginatedExpression) expression;
  1178.             logJDBCPaginatedExpression(jdbcPaginatedExpression);

  1180.             // ISQLQueryObject
  1181.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1182.             sqlQueryObject.setANDLogicOperator(true);
  1183.             // Connection sql
  1184.             connection = this.jdbcServiceManager.getConnection();
  1185.             
  1186.             return this.serviceSearch.findAllTableIds(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcPaginatedExpression);
  1187.     
  1188.         }catch(ServiceException | NotImplementedException e){
  1189.             this.logError(e); throw e;
  1190.         }catch(Exception e){
  1191.             this.logError(e); throw new ServiceException("findAllTableIds not completed: "+e.getMessage(),e);
  1192.         }finally{
  1193.             if(connection!=null){
  1194.                 this.jdbcServiceManager.closeConnection(connection);
  1195.             }
  1196.         }
  1197.         
  1198.     }
  1199.     
  1200.     @Override
  1201.     public long findTableId(IExpression expression) throws ServiceException, NotFoundException, MultipleResultException, NotImplementedException {
  1202.     
  1203.         Connection connection = null;
  1204.         try{
  1205.             
  1206.             // check parameters
  1207.             if(expression==null){
  1208.                 throw this.newServiceExceptionParameterPaginatedExpressionIsNull();
  1209.             }
  1210.             if( ! (expression instanceof JDBCExpression) ){
  1211.                 throw this.newServiceExceptionParameterExpressionWrongType(expression);
  1212.             }
  1213.             JDBCExpression jdbcExpression = (JDBCExpression) expression;
  1214.             this.logJDBCExpression(jdbcExpression);

  1216.             // ISQLQueryObject
  1217.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1218.             sqlQueryObject.setANDLogicOperator(true);
  1219.             // Connection sql
  1220.             connection = this.jdbcServiceManager.getConnection();

  1222.             return this.serviceSearch.findTableId(this.jdbcProperties,this.log,connection,sqlQueryObject,jdbcExpression);           

  1224.         }catch(ServiceException | MultipleResultException | NotImplementedException e){
  1225.             this.logError(e); throw e;
  1226.         }catch(NotFoundException e){
  1227.             this.logDebug(e); throw e;
  1228.         }catch(Exception e){
  1229.             this.logError(e); throw new ServiceException("findTableId not completed: "+e.getMessage(),e);
  1230.         }finally{
  1231.             if(connection!=null){
  1232.                 this.jdbcServiceManager.closeConnection(connection);
  1233.             }
  1234.         }
  1235.     
  1236.     }
  1237.     
  1238.     @Override
  1239.     public InUse inUse(long tableId) throws ServiceException, NotFoundException, NotImplementedException {
  1240.     
  1241.         Connection connection = null;
  1242.         try{
  1243.             
  1244.             // check parameters
  1245.             if(tableId<=0){
  1246.                 throw this.newServiceExceptionParameterTableIdLessEqualsZero();
  1247.             }
  1248.             
  1249.             // ISQLQueryObject
  1250.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1251.             sqlQueryObject.setANDLogicOperator(true);
  1252.             // Connection sql
  1253.             connection = this.jdbcServiceManager.getConnection();

  1255.             return this.serviceSearch.inUse(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId);        
  1256.     
  1257.         }catch(ServiceException | NotImplementedException e){
  1258.             this.logError(e); throw e;
  1259.         }catch(NotFoundException e){
  1260.             this.logDebug(e); throw e;
  1261.         }catch(Exception e){
  1262.             this.logError(e); throw new ServiceException("InUse(tableId) not completed: "+e.getMessage(),e);
  1263.         }finally{
  1264.             if(connection!=null){
  1265.                 this.jdbcServiceManager.closeConnection(connection);
  1266.             }
  1267.         }
  1268.     
  1269.     }
  1270.     
  1271.     @Override
  1272.     public IdConfigurazioneFiltro findId(long tableId, boolean throwNotFound)
  1273.             throws NotFoundException, ServiceException, NotImplementedException {
  1274.         
  1275.         Connection connection = null;
  1276.         try{
  1277.             
  1278.             // check parameters
  1279.             if(tableId<=0){
  1280.                 throw this.newServiceExceptionParameterTableIdLessEqualsZero();
  1281.             }
  1282.             
  1283.             // ISQLQueryObject
  1284.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1285.             sqlQueryObject.setANDLogicOperator(true);
  1286.             // Connection sql
  1287.             connection = this.jdbcServiceManager.getConnection();

  1289.             return this.serviceSearch.findId(this.jdbcProperties,this.log,connection,sqlQueryObject,tableId,throwNotFound);     
  1290.     
  1291.         }catch(ServiceException | NotImplementedException e){
  1292.             this.logError(e); throw e;
  1293.         }catch(NotFoundException e){
  1294.             this.logDebug(e); throw e;
  1295.         }catch(Exception e){
  1296.             this.logError(e); throw new ServiceException("findId(tableId,throwNotFound) not completed: "+e.getMessage(),e);
  1297.         }finally{
  1298.             if(connection!=null){
  1299.                 this.jdbcServiceManager.closeConnection(connection);
  1300.             }
  1301.         }
  1302.         
  1303.     }

  1305.     @Override
  1306.     public Long findTableId(IdConfigurazioneFiltro id, boolean throwNotFound)
  1307.             throws NotFoundException, ServiceException, NotImplementedException {
  1308.         
  1309.         Connection connection = null;
  1310.         try{
  1311.             
  1312.             // check parameters
  1313.             if(id==null){
  1314.                 throw new ServiceException("Parameter 'id' is null");
  1315.             }
  1316.             
  1317.             // ISQLQueryObject
  1318.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1319.             sqlQueryObject.setANDLogicOperator(true);
  1320.             // Connection sql
  1321.             connection = this.jdbcServiceManager.getConnection();

  1323.             return this.serviceSearch.findTableId(this.jdbcProperties,this.log,connection,sqlQueryObject,id,throwNotFound);     
  1324.     
  1325.         }catch(ServiceException | NotImplementedException e){
  1326.             this.logError(e); throw e;
  1327.         }catch(NotFoundException e){
  1328.             this.logDebug(e); throw e;
  1329.         }catch(Exception e){
  1330.             this.logError(e); throw new ServiceException("findId(tableId,throwNotFound) not completed: "+e.getMessage(),e);
  1331.         }finally{
  1332.             if(connection!=null){
  1333.                 this.jdbcServiceManager.closeConnection(connection);
  1334.             }
  1335.         }
  1336.     }
  1337.     
  1338.     @Override
  1339.     public void disableSelectForUpdate() throws ServiceException,NotImplementedException {
  1340.         this.jdbcSqlObjectFactory.setSelectForUpdate(false);
  1341.     }

  1343.     @Override
  1344.     public void enableSelectForUpdate() throws ServiceException,NotImplementedException {
  1345.         this.jdbcSqlObjectFactory.setSelectForUpdate(true);
  1346.     }
  1347.     
  1348.     
  1349.     @Override
  1350.     public List<List<Object>> nativeQuery(String sql,List<Class<?>> returnClassTypes,Object ... param) throws ServiceException,NotFoundException,NotImplementedException{
  1351.     
  1352.         Connection connection = null;
  1353.         try{
  1354.             
  1355.             // check parameters
  1356.             if(returnClassTypes==null || returnClassTypes.isEmpty()){
  1357.                 throw new ServiceException("Parameter 'returnClassTypes' is less equals 0");
  1358.             }
  1359.             
  1360.             // ISQLQueryObject
  1361.             ISQLQueryObject sqlQueryObject = this.jdbcSqlObjectFactory.createSQLQueryObject(this.jdbcProperties.getDatabase());
  1362.             sqlQueryObject.setANDLogicOperator(true);
  1363.             // Connection sql
  1364.             connection = this.jdbcServiceManager.getConnection();

  1366.             return this.serviceSearch.nativeQuery(this.jdbcProperties,this.log,connection,sqlQueryObject,sql,returnClassTypes,param);       
  1367.     
  1368.         }catch(ServiceException | NotImplementedException e){
  1369.             this.logError(e); throw e;
  1370.         }catch(NotFoundException e){
  1371.             this.logDebug(e); throw e;
  1372.         }catch(Exception e){
  1373.             this.logError(e); throw new ServiceException("nativeQuery not completed: "+e.getMessage(),e);
  1374.         }finally{
  1375.             if(connection!=null){
  1376.                 this.jdbcServiceManager.closeConnection(connection);
  1377.             }
  1378.         }
  1379.     
  1380.     }
  1381.     
  1382. }
Created with JaCoCo 0.8.8.202204050719