我已经使用Java和Maven创建了一个web应用程序(这是我的项目:https://github.com/lkobylanski/Parking_Book_System_Java)。其简单的停车位预订系统。它在我本地的tomcat上运行得很好。但是,当我使用WAR部署在Heroku上部署它时:https://devcenter.heroku.com/articles/war-deployment
应用程序运行,但每次我尝试使用DB做任何事情时,都会收到500服务器错误,例如添加新的预订或获取API,无论它是特定的停车点还是全局所有预订。下面是错误:
HTTP Status 500 – Internal Server Error
Type Exception Report
Message java.lang.IllegalStateException: Could not initialize database
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
javax.servlet.ServletException: java.lang.IllegalStateException: Could not initialize database
com.pbs.web.jdbc.ParkingBookSystem.BookControllerServlet.init(BookControllerServlet.java:40)
javax.servlet.GenericServlet.init(GenericServlet.java:158)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
Root Cause
java.lang.IllegalStateException: Could not initialize database
com.pbs.web.jdbc.ParkingBookSystem.BookDbUtil.<init>(BookDbUtil.java:27)
com.pbs.web.jdbc.ParkingBookSystem.BookControllerServlet.init(BookControllerServlet.java:37)
javax.servlet.GenericServlet.init(GenericServlet.java:158)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
Root Cause
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:662)
javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:313)
javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:350)
javax.naming.InitialContext.lookup(InitialContext.java:417)
com.pbs.web.jdbc.ParkingBookSystem.BookDbUtil.<init>(BookDbUtil.java:24)
com.pbs.web.jdbc.ParkingBookSystem.BookControllerServlet.init(BookControllerServlet.java:37)
javax.servlet.GenericServlet.init(GenericServlet.java:158)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/8.5.33
这就是我连接数据库的方式:我在根目录/src/main/webapp/META-INF中放置了一个context.xml文件
看起来像(用户名和通行证不是真实的):
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xml>
<Context path="/ParkingSystem">
<Resource
name="jdbc/ParkingBookSystem"
auth="Container"
type="javax.sql.DataSource"
maxTotal="20"
maxIdle="5"
maxWaitMillis="10000"
username="username"
password="password"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://sql2.freemysqlhosting.net:3306/sql2226123"
/>
</Context>
下面是连接构造函数方法:
public BookDbUtil() {
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
dataSource = (DataSource) envContext.lookup("jdbc/ParkingBookSystem");
} catch (NamingException e) {
throw new IllegalStateException("Could not initialize database", e);
}
}
编辑:我已经完成了以下步骤:
heroku config:set WEBAPP_RUNNER_OPTS="--enable-naming --context-xml=C:\context\context.xml
为我的context.xmlheroku war:deploy D:\Luki\Archiwum\WARfiles\ParkingBookSystem.war --includes context.xml
并得到以下错误:
Uploading ParkingBookSystem.war
-----> Packaging application...
- app: parking-booking
- including: context.xml
! ERROR: There was an error packaging the application for deployment.
! Re-run with HEROKU_DEBUG=1 for more info.
! There was a problem deploying to parking-booking.
! Make sure you have permission to deploy by running: heroku apps:info -a parking-booking
https://stackoverflow.com/questions/52708762
复制相似问题