Java Method to get postgresql server version by using an hibernate session.

GetPostgresVersion.java

private static boolean validatePostresqlServerVersionGreaterOrEqualTo(short major, short minor) {

     short actualMajor = 0;
     short actualMinor = 0;

     try {
         Session session = HibernateUtil.getSession();
         session.beginTransaction();
         SQLQuery query = session.createSQLQuery("SELECT VERSION()");
         query.setReadOnly(true);
         query.setFetchSize(1);
         ScrollableResults results = query.scroll(ScrollMode.FORWARD_ONLY);
         results.next();
         String postgresVersionResult = (String) results.get(0);
         // Expected to have something like:
         // PostgreSQL 9.2.23 on x86_64-unknown-linux-gnu....
         // Get the second string and parse major and minor
         postgresVersionResult = postgresVersionResult.split(" ")[1].trim();
         String[] temp = postgresVersionResult.split("\\.");
         actualMajor = Short.parseShort(temp[0]);
         actualMinor = Short.parseShort(temp[1]);
         if (actualMajor >= major && actualMinor >= minor)
             return true;
     }
     catch (Exception ex) {

         logger.info("Unable to get PostgreSQL Server Version.");
     }
     return false;

 }