Configure Resources for JDBC Connections

Configure new Resources for the JDBC with the following settings:

1. Add a new Connection Pools entry:
   • Name: dvnDbPool
   • Resource Type: javax.sql.DataSource
   • Database Vendor: PostgreSQL
   • DataSource ClassName: org.postgresql.ds.PGPoolingDataSource
   • Additional Properties:
     • ConnectionAttributes: ;create=true
     • User: dvnApp
     • PortNumber: 5432 (Port 5432 is the PostgreSQL default port.)
     • Password: <DVN application database password>
     • DatabaseName: <your database name>
     • ServerName: localhost
     • JDBC30DataSource: true
2. Configure a new JDBC Resources entry:
   • JNDI Name: jdbc/VDCNetDS
   • Pool Name: dvnDbPool
3. To verify connectivity to the database, for the new Connection Pool use the
   General functions and perform a Ping operation.
   If the Ping succeeds, you see the message Ping Succeeded.
   If the Ping does not succeed, you see an error message. Verify the database
   configuration, existence, and user account, and confirm access to port 5432.