Using Postgres driver on Glassfish 4 / Payara

Using Postgres driver on Glassfish 4 / Payara

  July 24, 2015    Suraj Chhetry

---

Installing Driver

1. Download Postgres JDBC driver
2. Copy the driver to GLASS_FISH_HOME/domains/YOUR_DOMAIN/lib , for example /opt/java_tools/payara41/glassfish/domains/domain1/lib/
3. Restart Server 

Creating Connection Pool

1. Goto Resource >> JDBC >> JDBC Connection Pools
2. Press New Button
3. Give Pool Name say TEST_POOL
4. Select Resource Type to  javax.sql.ConnectionPoolDataSource
5. Select Vendor as Postgres
6. Press Next
7. Goto Additional Properties 
8. Select all and remove
9.  Add  properties as shown below

   
    10.  Press Finish

    11.  Select Pool
    12.  Click on Ping . If everything is correctly entered, it shows Ping Succeeded

Adding JDBC Resources

1. Click " New "
2. Give JNDI Name say "jdbc/TEST"
3. Select Pool Name which is created earlier " TEST_POOL " 
4. Press OK

Now, JDBC datasource is created . 

Happy Coding...