Class PostgresqlAdapter


public class PostgresqlAdapter extends AbstractDatabase
The PostgreSQL db adapter implementation.
  • Constructor Details

    • PostgresqlAdapter

      public PostgresqlAdapter()
  • Method Details

    • getUniqueID

      public long getUniqueID(Connection conn, String tableName) throws SQLException
      The PostgreSQL unique ID /sequence generator The name of the sequence used to generate the unique id is made from the name of the table that uses the id by appending "_id_seq" to it. When record is inserted in the table and insert trigger gets a nextval from that sequence, select currval of that sequence can return the generated key in the same db connection.
      Specified by:
      getUniqueID in class AbstractDatabase
      conn - db connection in which the unique id was generated
      tableName - the name of table which unique id was generate
      return the generated unique id as a long type
      SQLException - any SQLException that can be thrown during the db operation
    • getDateTimeFunction

      public String getDateTimeFunction()
      The PostgreSQL function name that gets the current date and time from the database server
      Specified by:
      getDateTimeFunction in class AbstractDatabase
      return the current date and time function name: "now()"
    • getIsNULLFunction

      public String getIsNULLFunction()
      The PostgreSQL function name that is used to return non-NULL value
      Specified by:
      getIsNULLFunction in class AbstractDatabase
      return the non-NULL function name: "coalesce"
    • getStringDelimiter

      public String getStringDelimiter()
      PostgreSQL's string delimiter character: single quote (')
      Specified by:
      getStringDelimiter in class AbstractDatabase
      return the string delimiter: single quote (')
    • getLeftJoinQuery

      public String getLeftJoinQuery(String selectFields, String tableA, String tableB, String joinCriteria, String nonJoinCriteria)
      PostgreSQL's syntax for doing a left join Add 'a.' in front of the fields for first table and 'b.' in front of the fields for the second table
      Specified by:
      getLeftJoinQuery in class AbstractDatabase
      selectFields - fields that you want to be selected
      tableA - first table in the join
      tableB - second table in the join
      joinCriteria - the criteria based on which the join will be made
      nonJoinCriteria - all other criterias
      return the string for teh select query
    • getReplicationDocumentListSQL

      public String getReplicationDocumentListSQL()
      Return a hard code string to get xml_document list in timed replcation
      Specified by:
      getReplicationDocumentListSQL in class AbstractDatabase
    • getPagedQuery

      public String getPagedQuery(String queryWithOrderBy, Integer start, Integer count)
      Description copied from class: AbstractDatabase
      for generating a query for paging
      Specified by:
      getPagedQuery in class AbstractDatabase
      queryWithOrderBy - - the complete query with SELECT, FROM, WHERE and ORDER BY clauses
      start - the row number to start from
      count - the number of records from start to return
      query specific to the RDBMS in use