+ Start a Discussion
Pierre-Emmanuel GrosPierre-Emmanuel Gros 

Salesforce Integration Workbook issue with heroku App

I am currently trying to follow the guidelines of the Salesforce "Integration Workbook" (https://resources.docs.salesforce.com/sfdc/pdf/integration_workbook.pdf) for the Summer 15 release on my Mac.

Everything worked well until Step 3 of Tutorial 1 (test of the Heroku App).
When clicking on the "Ajax @Controller Example" link of the application home page, I get a HTTP-500 error.
 
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.

exceptionorg.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

Am I the only one encountering the issue ?
Has anyone any clue ?
Best Answer chosen by Pierre-Emmanuel Gros
Pierre-Emmanuel GrosPierre-Emmanuel Gros
Work-around found : There is a SSL statement to change in the applicationContext.xml source file.
Only one line to change to activate SSL for the DB connection:
            <property name="url" value="#{ 'jdbc:postgresql://' + @dbUrl.getHost() + @dbUrl.getPath() + '?ssl=true&amp;sslfactory=org.postgresql.ssl.NonValidatingFactory'}"/>