iReport - Enabling Client Access To A PostgreSQL Database

1. Open the pg_hba.conf file in your database server. The path is as below :
  
       /var/lib/psql/data/pg_hba.conf

2. Append the following line in the pg_hba.conf file

      host    wsemp       jboss       xxx.xxx.xxx.xxx/32     255.255.255.255     trust

3. Restart postgres

     /etc/init.d/postgres restart

4. Restart jboss on your application server

     jboss-start

5. Test whether EMP is running alright

6. Test whether you configuration is correct by trying to access the database. Do this in your database server

     psql wsemp

7. Put in the necessary configurations in iReport and click on the Test button to check the connection