Heroku Postgres 9.3 JDBC Datasource

[jwworth]

I've seen this question a few times, but no solution so far has worked for me.

I'm trying to connect a Heroku Postgres 9.3 datasource to JasperReports Server 4.5.  When I test the connection, it fails.

I downloaded postgresql-8.3-607.jdbc4.jar and postgresql-9.3-1102.jdbc3.jar to /opt/bitnami/apache-tomcat/webapps/jasperserver/WEB-INF/lib/ and restarted the server.

This is my driver setting from the config page: org.postgresql.Driver

Here is the log output when I test the connection:

 

 2014-07-22 15:29:46,722  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.name]. Using default validation on input=[PHS_Platform__Staging_].

2014-07-22 15:29:46,723  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.label]. Using default validation on input=[PHS Platform (Staging)].

2014-07-22 15:29:46,724  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.parentFolder]. Using default validation on input=[/datasources].

2014-07-22 15:29:46,724  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [_eventId_testDataSource]. Using default validation on input=[].

2014-07-22 15:29:46,725  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.username]. Using default validation on input=[<removed by question poster>].

2014-07-22 15:29:46,725  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.driverClass]. Using default validation on input=[org.postgresql.Driver].

2014-07-22 15:29:46,725  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.description]. Using default validation on input=[].

2014-07-22 15:29:46,726  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.password]. Using default validation on input=[<removed by question poster>].

2014-07-22 15:29:46,726  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.timezone]. Using default validation on input=[].

2014-07-22 15:29:46,727  WARN ValidatorImpl,http-80-1:259 - No rule for parameter [reportDataSource.connectionUrl]. Using default validation on input=[<removed by question poster>].

 

Any help would be greatly appreciated!

[jwworth]

I figured it out.

Heroku database URLs begin with postgres://.  JasperReports Server needed that datasource URL to contain postgresql://.  I was able to connect after making that change.