title: PWS - Unable to connect UAA to database
body: <p>I am having an issue on Pivotal Web Services where I am unable to get a connection to the Postgres SQL database for UAA.</p>
  
  <p>I have the service defined and bound to the application, but am putting the credentials in manually (Not sure if param replacement happens in the an Env variable)</p>
  
  <p>The relevant section of the UAA.yaml file:</p>
  
  <pre><code>database:
      driverClassName: org.postgresql.Driver
      url: jdbc:postgresql://babar.elephantsql.com:5432/db
      username: db
      password: randomPass
      maxactive: 15
      maxidle: 5
      minidle: 0
      removeabandoned: false
      logabandoned: true
      abandonedtimeout: 300
      evictionintervalms: 15000
      caseinsensitive: false 
  </code></pre>
  
  <p>I am bound to the ElephantSQL's "Panda" plan which limits me to 20 concurrent connections. This is the error I generally receive in UAA on startup:</p>
  
  <p>java.sql.SQLException: Driver:org.postgresql.Driver@112ab411 returned null for URL:postgres://db:randomPass@babar.elephantsql.com:5432/db
  2017-01-28T14:15:57.43-0500 [APP/PROC/WEB/0]OUT     at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:296)</p>
  
  <p>I am not sure why it is returning null, the credentials and url are correct. </p>