无法将Appfuse Spring应用程序连接到Heroku Postgres数据库
问题描述：
我试图将基本的Appfuse Spring应用程序部署到heroku。当我将代码推送到heroku时，它成功构建，但是当我尝试打开页面时，我得到一个“应用程序错误”页面。我相信问题是连接到heroku的postgres数据库和应用程序休息时刻第一次请求数据库，但我真的不知道如何解决这个问题。无法将Appfuse Spring应用程序连接到Heroku Postgres数据库
我加入这个豆到我的applicationContext.xml：
<bean class="java.net.URI" id="dbUrl">
<constructor-arg value="#{systemEnvironment['DATABASE_URL']}"/>
</bean>
<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource">
<property name="driverClassName" value="${org.postgresql.Driver}"/>
<property name="url" value="#{ 'jdbc:postgresql://' + @dbUrl.getHost() + ':' + @dbUrl.getPort() + @dbUrl.getPath() }"/>
<property name="username" value="#{ @dbUrl.getUserInfo().split(':')[0] }"/>
<property name="password" value="#{ @dbUrl.getUserInfo().split(':')[1] }"/>
<property name="connectionProperties" value="ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory;"/>
</bean>
，这些都是成功构建后的日志：
←[36m2015-06-14T14:30:10.945012+00:00 app[web.1]:←[0m Jun 14, 2015 2:30:10 PM org.apache.catalina.startup.ContextConfig processAnnotationsJar
←[36m2015-06-14T14:30:10.959377+00:00 app[web.1]:←[0m at org.apache.tomcat.util.bcel.classfile.ClassParser.readID(ClassParser.java:200)
←[36m2015-06-14T14:30:10.963840+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.processAnnotationsStream(ContextConfig.java:2071)
←[36m2015-06-14T14:30:10.968017+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.webConfig(ContextConfig.java:1330)
←[36m2015-06-14T14:30:10.964296+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.processAnnotationsUrl(ContextConfig.java:1913)
←[36m2015-06-14T14:30:10.969138+00:00 app[web.1]:←[0m at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
←[36m2015-06-14T14:30:10.987850+00:00 app[web.1]:←[0m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
←[36m2015-06-14T14:30:10.974187+00:00 app[web.1]:←[0m at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
←[36m2015-06-14T14:30:10.968449+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:386)
←[36m2015-06-14T14:30:10.972076+00:00 app[web.1]:←[0m at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
←[36m2015-06-14T14:30:10.948152+00:00 app[web.1]:←[0m java.io.EOFException
←[36m2015-06-14T14:30:10.948084+00:00 app[web.1]:←[0m SEVERE: Unable to process Jar entry [org/hibernate/type/descriptor/java/CalendarTimeTypeDescriptor.class] from Jar [jar:jndi:/localhost/WEB-INF/lib/hibernate-core-4.3.6.Final.jar!/] f
←[36m2015-06-14T14:30:10.959147+00:00 app[web.1]:←[0m at org.apache.tomcat.util.bcel.classfile.FastDataInputStream.readInt(FastDataInputStream.java:145)
←[36m2015-06-14T14:30:10.959589+00:00 app[web.1]:←[0m at org.apache.tomcat.util.bcel.classfile.ClassParser.parse(ClassParser.java:78)
←[36m2015-06-14T14:30:10.964066+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.processAnnotationsJar(ContextConfig.java:1947)
←[36m2015-06-14T14:30:10.964540+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.processAnnotations(ContextConfig.java:1898)
←[36m2015-06-14T14:30:10.968231+00:00 app[web.1]:←[0m at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:889)
←[36m2015-06-14T14:30:10.968679+00:00 app[web.1]:←[0m at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
←[36m2015-06-14T14:30:10.971888+00:00 app[web.1]:←[0m at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5380)
←[36m2015-06-14T14:30:10.972496+00:00 app[web.1]:←[0m at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
←[36m2015-06-14T14:30:10.982160+00:00 app[web.1]:←[0m at java.util.concurrent.FutureTask.run(FutureTask.java:266)
←[36m2015-06-14T14:30:10.988068+00:00 app[web.1]:←[0m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
←[36m2015-06-14T14:30:10.988211+00:00 app[web.1]:←[0m
←[36m2015-06-14T14:30:10.988181+00:00 app[web.1]:←[0m at java.lang.Thread.run(Thread.java:745)
←[33m2015-06-14T14:30:19.107425+00:00 heroku[router]:←[0m at=error code=H12 desc="Request timeout" method=GET path="/" host=iin.herokuapp.com request_id=d9f43955-4856-49fd-99e3-acb2a8726026 fwd="193.135.254.174" dyno=web.1 connect=1ms se
bytes=0
←[36m2015-06-14T14:30:21.083301+00:00 app[web.1]:←[0m Jun 14, 2015 2:30:21 PM org.apache.catalina.core.ApplicationContext log
←[36m2015-06-14T14:30:21.124977+00:00 app[web.1]:←[0m Jun 14, 2015 2:30:21 PM org.apache.catalina.core.ApplicationContext log
←[36m2015-06-14T14:30:21.084386+00:00 app[web.1]:←[0m INFO: No Spring WebApplicationInitializer types detected on classpath
←[36m2015-06-14T14:30:21.125377+00:00 app[web.1]:←[0m INFO: Initializing Spring root WebApplicationContext
←[36m2015-06-14T14:30:36.555192+00:00 app[web.1]:←[0m DEBUG [localhost-startStop-1] StartupListener.contextInitialized(47) | Initializing context...
←[36m2015-06-14T14:30:36.556130+00:00 app[web.1]:←[0m DEBUG [localhost-startStop-1] StartupListener.contextInitialized(84) | Password Encoder: BCryptPasswordEncoder
←[36m2015-06-14T14:30:36.658863+00:00 app[web.1]:←[0m Jun 14, 2015 2:30:36 PM org.apache.catalina.core.StandardContext listenerStart
←[36m2015-06-14T14:30:36.659668+00:00 app[web.1]:←[0m org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: C
←[36m2015-06-14T14:30:36.660282+00:00 app[web.1]:←[0m at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
←[36m2015-06-14T14:30:36.661208+00:00 app[web.1]:←[0m at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
←[36m2015-06-14T14:30:36.661799+00:00 app[web.1]:←[0m at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
←[36m2015-06-14T14:30:36.662348+00:00 app[web.1]:←[0m at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
←[36m2015-06-14T14:30:36.662761+00:00 app[web.1]:←[0m at com.sun.proxy.$Proxy126.getAllRoles(Unknown Source)
←[36m2015-06-14T14:30:36.663245+00:00 app[web.1]:←[0m at com.isitnormal.webapp.listener.StartupListener.contextInitialized(StartupListener.java:89)
←[36m2015-06-14T14:30:36.663643+00:00 app[web.1]:←[0m at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492)
←[36m2015-06-14T14:30:36.663434+00:00 app[web.1]:←[0m at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994)
←[36m2015-06-14T14:30:36.664073+00:00 app[web.1]:←[0m at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
←[36m2015-06-14T14:30:36.664524+00:00 app[web.1]:←[0m at java.util.concurrent.FutureTask.run(FutureTask.java:266)
←[36m2015-06-14T14:30:36.664705+00:00 app[web.1]:←[0m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
←[36m2015-06-14T14:30:36.664920+00:00 app[web.1]:←[0m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
←[36m2015-06-14T14:30:36.665040+00:00 app[web.1]:←[0m at java.lang.Thread.run(Thread.java:745)
←[36m2015-06-14T14:30:36.665279+00:00 app[web.1]:←[0m Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
←[36m2015-06-14T14:30:36.665769+00:00 app[web.1]:←[0m at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
←[36m2015-06-14T14:30:36.666251+00:00 app[web.1]:←[0m at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
←[36m2015-06-14T14:30:36.666737+00:00 app[web.1]:←[0m at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
←[36m2015-06-14T14:30:36.667673+00:00 app[web.1]:←[0m at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
←[36m2015-06-14T14:30:36.668124+00:00 app[web.1]:←[0m at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
←[36m2015-06-14T14:30:36.668940+00:00 app[web.1]:←[0m at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
←[36m2015-06-14T14:30:36.669947+00:00 app[web.1]:←[0m at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
←[36m2015-06-14T14:30:36.555875+00:00 app[web.1]:←[0m DEBUG [localhost-startStop-1] StartupListener.contextInitialized(82) | Remember Me Enabled? true
←[36m2015-06-14T14:43:25.025089+00:00 app[web.1]:←[0m Jun 14, 2015 2:43:25 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
←[36m2015-06-14T14:43:25.042250+00:00 app[web.1]:←[0m INFO: Starting ProtocolHandler ["http-nio-49034"]
←[33m2015-06-14T14:43:25.708538+00:00 heroku[router]:←[0m at=error code=H13 desc="Connection closed without response" method=GET path="/" host=iin.herokuapp.com request_id=f3e08c1f-6dbc-41a2-b3f8-4458acdcb759 fwd="193.135.254.174" dyno=w
=10090ms status=503 bytes=0
←[36m2015-06-14T14:43:26.819183+00:00 heroku[web.1]:←[0m State changed from up to crashed
←[36m2015-06-14T14:43:26.806604+00:00 heroku[web.1]:←[0m Process exited with status 0
另外，如果我尝试使用localy运行：
foreman start web
我成功构建，但应用程序中断：
17:11:11 web.1 | Jun 14, 2015 5:11:11 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
17:11:11 web.1 | SEVERE: The web application [] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistere
17:11:11 web.1 | Jun 14, 2015 5:11:11 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
17:11:11 web.1 | SEVERE: The web application [] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistere
17:11:11 web.1 | Jun 14, 2015 5:11:11 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
17:11:11 web.1 | SEVERE: The web application [] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak.
17:11:11 web.1 | Jun 14, 2015 5:11:11 PM org.apache.coyote.AbstractProtocol start
17:11:11 web.1 | INFO: Starting ProtocolHandler ["http-nio-8080"]
17:11:11 web.1 | Jun 14, 2015 5:11:11 PM org.apache.coyote.AbstractProtocol pause
17:11:11 web.1 | INFO: Pausing ProtocolHandler ["http-nio-8080"]
17:11:11 web.1 | exited with code 0
17:11:11 system | sending SIGKILL to all processes
答
我已经使用了JHipster的HerokuDatabaseConfiguration.java类，它对我来说工作得很好。