Class HibernatePersistentObjectDAO<T extends PersistentObject>

java.lang.Object
com.logicaldoc.core.HibernatePersistentObjectDAO<T>
All Implemented Interfaces:
PersistentObjectDAO<T>
Direct Known Subclasses:
HibernateAttributeOptionDAO, HibernateAttributeSetDAO, HibernateBookmarkDAO, HibernateContactDAO, HibernateDashletDAO, HibernateDeviceDAO, HibernateDocumentDAO, HibernateDocumentHistoryDAO, HibernateDocumentLinkDAO, HibernateDocumentNoteDAO, HibernateFolderDAO, HibernateFolderHistoryDAO, HibernateGenericDAO, HibernateGroupDAO, HibernateMenuDAO, HibernateMessageTemplateDAO, HibernatePasswordHistoryDAO, HibernateRatingDAO, HibernateSearchDAO, HibernateSequenceDAO, HibernateSessionDAO, HibernateSystemMessageDAO, HibernateTemplateDAO, HibernateTenantDAO, HibernateTicketDAO, HibernateUserDAO, HibernateUserHistoryDAO, HibernateVersionDAO, HibernateWebserviceCallDAO

public abstract class HibernatePersistentObjectDAO<T extends PersistentObject> extends Object implements PersistentObjectDAO<T>
Hibernate implementation of PersistentObjectDAO
Since:
4.0
Author:
Marco Meschieri - LogicalDOC
  • Method Details

    • setSessionFactory

      public void setSessionFactory(org.hibernate.SessionFactory sessionFactory)
    • delete

      public void delete(long id, int code) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      This method deletes an entity and you can give a deletion code
      Specified by:
      delete in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      id - ID of the entity which should be deleted
      code - Deletion code
      Throws:
      PersistenceException - raised in case of errors in the database
    • delete

      public void delete(long id) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      This method deletes an entity. Same as delete(id, 1)
      Specified by:
      delete in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      id - ID of the entity which should be deleted.
      Throws:
      PersistenceException - raised in case of errors in the database
    • findAll

      public List<T> findAll() throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities in the database
      Specified by:
      findAll in interface PersistentObjectDAO<T extends PersistentObject>
      Returns:
      The list of all entities
      Throws:
      PersistenceException - Error in the database
    • findAll

      public List<T> findAll(long tenantId) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities in a specific tenant.
      Specified by:
      findAll in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      tenantId - Identifier of the tenant to search in
      Returns:
      The list of all entities
      Throws:
      PersistenceException - Error in the database
    • findAllIds

      public List<Long> findAllIds() throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities ids
      Specified by:
      findAllIds in interface PersistentObjectDAO<T extends PersistentObject>
      Returns:
      The list of all entities ids
      Throws:
      PersistenceException - Error in the database
    • findAllIds

      public List<Long> findAllIds(long tenantId) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities ids in a specific tenant.
      Specified by:
      findAllIds in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      tenantId - Identifier of the tenant to search in
      Returns:
      The list of all entities ids
      Throws:
      PersistenceException - Error in the database
    • findById

      public T findById(long id, boolean initialize) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      This method finds an entity by ID
      Specified by:
      findById in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      id - ID of the entity
      initialize - True if the instance's lazy collections have to be initialized
      Returns:
      Entity with given ID
      Throws:
      PersistenceException - raised in case of errors in the database
    • findById

      public T findById(long id) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      This method finds an entity by ID
      Specified by:
      findById in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      id - ID of the entity
      Returns:
      Entity with given ID
      Throws:
      PersistenceException - raised in case of errors in the database
    • findByWhere

      public List<T> findByWhere(String where, String order, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities by the given expression. Use "_entity" alias to reference attributes in the where expression.
      Specified by:
      findByWhere in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      where - The where clause expression
      order - The order clause expression
      max - Maximum results number (optional)
      Returns:
      The list of marching entities
      Throws:
      PersistenceException - raised in case of errors in the database
    • findByWhere

      public List<T> findByWhere(String where, Map<String,Object> parameters, String order, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities by the given expression. Use "_entity" alias to reference attributes in the where expression.
      Specified by:
      findByWhere in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      where - The where clause expression
      parameters - Parameters used in the where expression
      order - The order clause expression
      max - Maximum results number (optional)
      Returns:
      The list of marching entities
      Throws:
      PersistenceException - raised in case of errors in the database
    • findByObjectQuery

      public List<T> findByObjectQuery(String query, Map<String,Object> parameters, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities by the given object query.
      Specified by:
      findByObjectQuery in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      query - The query expression
      parameters - Parameters used in the where expression
      max - Maximum results number (optional)
      Returns:
      The list of matching entities
      Throws:
      PersistenceException - raised in case of errors in the database
    • findByQuery

      public List findByQuery(String query, Map<String,Object> parameters, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Find everything you want from the DB using the ORM query language
      Specified by:
      findByQuery in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      query - The query to execute
      parameters - The map of the parameters
      max - Maximum results number (optional)
      Returns:
      Query result
      Throws:
      PersistenceException - raised in case of errors in the database
    • findIdsByWhere

      public List<Long> findIdsByWhere(String where, String order, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities ids by the given expression. Use "_entity" alias to reference attributes in the where expression.
      Specified by:
      findIdsByWhere in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      where - The where clause expression
      order - The order clause expression
      max - Maximum results number (optional)
      Returns:
      The list of marching entities ids
      Throws:
      PersistenceException - raised in case of errors in the database
    • findIdsByWhere

      public List<Long> findIdsByWhere(String where, Map<String,Object> parameters, String order, Integer max) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Finds all entities ids by the given expression. Use "_entity" alias to reference attributes in the where expression.
      Specified by:
      findIdsByWhere in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      where - The where clause expression (for parameters, please use JPA-style: :paramA, :paramB ...)
      parameters - The map of the parameters
      order - The order clause expression
      max - Maximum results number (optional)
      Returns:
      The list of marching entities ids
      Throws:
      PersistenceException - raised in case of errors in the database
    • store

      public void store(T entity) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      This method persists the entity object
      Specified by:
      store in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      entity - entity to be stored
      Throws:
      PersistenceException - raised in case of errors in the database
    • initialize

      public void initialize(T entity)
      Doesn't do anything by default
      Specified by:
      initialize in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      entity - The entity to be initialised
    • query

      public List query(String sql, org.springframework.jdbc.core.RowMapper rowMapper, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping each row to a Java object via a RowMapper.
      Specified by:
      query in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      rowMapper - object that will map one object per row
      maxRows - the new max rows limit; null means there is no limit
      Returns:
      the result List, containing mapped objects
      Throws:
      PersistenceException - raised in case of errors in the database
    • query

      public List query(String sql, Map<String,Object> parameters, org.springframework.jdbc.core.RowMapper rowMapper, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping each row to a Java object via a RowMapper.
      Specified by:
      query in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      parameters - Parameters used in the where expression (map name-value)
      rowMapper - object that will map one object per row
      maxRows - the new max rows limit; null means there is no limit
      Returns:
      the result List, containing mapped objects
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForList

      public List queryForList(String sql, Class elementType) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list. The results will be mapped to a List (one entry for each row) of result objects, each of them matching the specified element type.
      Specified by:
      queryForList in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      elementType - the required type of element in the result list (for example, Integer.class)
      Returns:
      a List of objects that match the specified element type
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForList

      public List queryForList(String sql, Class elementType, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query for a result list, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForList method with null as argument array. The results will be mapped to a List (one entry for each row) of result objects, each of them matching the specified element type.
      Specified by:
      queryForList in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      elementType - the required type of element in the result list (for example, Integer.class)
      maxRows - maximum number of returned records
      Returns:
      a List of objects that match the specified element type
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForList

      public List queryForList(String sql, Map<String,Object> prameters, Class elementType, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, expecting a result list. The results will be mapped to a List (one entry for each row) of result objects, each of them matching the specified element type.
      Specified by:
      queryForList in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      prameters - Parameters used in the where expression (map name-value)
      elementType - the required type of element in the result list (for example, Integer.class)
      maxRows - maximum number of returned records
      Returns:
      a List of objects that match the specified element type
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForRowSet

      public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(String sql, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, returns a navigable RowSet
      Specified by:
      queryForRowSet in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      maxRows - the new max rows limit; null means there is no limit
      Returns:
      the result row set
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForRowSet

      public org.springframework.jdbc.support.rowset.SqlRowSet queryForRowSet(String sql, Map<String,Object> parameters, Integer maxRows) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, returns a navigable RowSet
      Specified by:
      queryForRowSet in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      parameters - Parameters used in the where expression (map name-value)
      maxRows - the new max rows limit; null means there is no limit
      Returns:
      the result row set
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForInt

      public int queryForInt(String sql) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in an int value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in an int value.
      Specified by:
      queryForInt in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      Returns:
      the int value, or 0 in case of SQL NULL
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForLong

      public long queryForLong(String sql) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in an long value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a long value.
      Specified by:
      queryForLong in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      Returns:
      the long value, or 0 in case of SQL NULL
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForLong

      public long queryForLong(String sql, Map<String,Object> parameters) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in an long value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a long value.
      Specified by:
      queryForLong in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      parameters - Parameters used in the where expression (map name-value)
      Returns:
      the long value, or 0 in case of SQL NULL
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForDouble

      public double queryForDouble(String sql) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in a double value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a long value.
      Specified by:
      queryForDouble in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      Returns:
      the double value, or 0 in case of SQL NULL
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForDouble

      public double queryForDouble(String sql, Map<String,Object> parameters) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in a double value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a long value.
      Specified by:
      queryForDouble in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      parameters - Parameters used in the where expression (map name-value)
      Returns:
      the double value, or 0 in case of SQL NULL
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForString

      public String queryForString(String sql) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in an string value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForInt method with null as argument array. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a string value.
      Specified by:
      queryForString in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      Returns:
      the string value
      Throws:
      PersistenceException - raised in case of errors in the database
    • queryForObject

      public Object queryForObject(String sql, Class type) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Execute a query that results in a Object value, given static SQL. Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement. This method is useful for running static SQL with a known outcome. The query is expected to be a single row/single column query that results in a object value.
      Specified by:
      queryForObject in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      sql - SQL query to execute
      type - The type of the returned value
      Returns:
      the object value
      Throws:
      PersistenceException - raised in case of errors in the database
    • jdbcUpdate

      public int jdbcUpdate(String statement) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Executes the given SQL update statement
      Specified by:
      jdbcUpdate in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      statement - the SQL statement to execute against the database
      Returns:
      the value returned by the database after execution
      Throws:
      PersistenceException - raised in case of errors in the database
    • deleteAll

      public void deleteAll(Collection<T> entities, int code) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Deletes all entries form the database giving a specific deletion code
      Specified by:
      deleteAll in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      entities - The entities to be deleted
      code - The deletion code
      Throws:
      PersistenceException - raised in case of errors in the database
    • deleteAll

      public void deleteAll(Collection<T> entities) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Deletes all entries form the database
      Specified by:
      deleteAll in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      entities - The entities to be deleted
      Throws:
      PersistenceException - raised in case of errors in the database
    • bulkUpdate

      public int bulkUpdate(String expression, Map<String,Object> parameters) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Executes a bulk update as specified by the given expression
      Specified by:
      bulkUpdate in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      expression - The update expression.
      parameters - Optional map of parameters
      Returns:
      the number of modified records
      Throws:
      PersistenceException - raised in case of errors in the database
    • jdbcUpdate

      public int jdbcUpdate(String statement, Map<String,Object> parameters) throws PersistenceException
      Description copied from interface: PersistentObjectDAO
      Issue a single SQL update operation (such as an insert, update or delete statement) via a prepared statement, binding the given arguments
      Specified by:
      jdbcUpdate in interface PersistentObjectDAO<T extends PersistentObject>
      Parameters:
      statement - SQL statement to execute (for parameters please use JPA-style: :paramA, :paramB ...)
      parameters - Parameters used in the where expression (map name-value)
      Returns:
      the number of rows affected
      Throws:
      PersistenceException - raised in case of errors in the database
    • getDbms

      public String getDbms()
      Description copied from interface: PersistentObjectDAO
      Get the DBMS name currently connected(possible values are: mysql, mariadb, postgresql, hsqldb, oracle, mssql)
      Specified by:
      getDbms in interface PersistentObjectDAO<T extends PersistentObject>
      Returns:
      the database identifier
    • isOracle

      public boolean isOracle()
      Specified by:
      isOracle in interface PersistentObjectDAO<T extends PersistentObject>
    • getSessionFactory

      public org.hibernate.SessionFactory getSessionFactory()
    • getDatabaseMetadata

      public Map<String,String> getDatabaseMetadata()
      Description copied from interface: PersistentObjectDAO
      Retrieves the metadata from the database
      Specified by:
      getDatabaseMetadata in interface PersistentObjectDAO<T extends PersistentObject>
      Returns:
      a map of metadata from the database driver