[Solved] Deploy War Application Request

[blister2]

Hi,

 

Could you please deploy my war package?

username: blister2

war file: metrolotto

Thanks!

 

[Luigi123]

This support request is being escalated to our root admin.

[Krydos]

That .war file cannot be deployed.

FAIL - Application at context path /blister2_metrolotto could not be started
FAIL - Encountered exception org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/blister2_metrolotto]]

[blister2]

Thanks for trying. Is there any log I can use to resolve this issue? I'm guessing this is a JDBC issue. Below is my JDBC details. I made the program on Spring Boot using Java 1.7. It runs just fine on my local machine tomcat 8.5.

 

spring.mvc.view.prefix: /WEB-INF/views/

spring.mvc.view.suffix: .jsp

spring.datasource.url=jdbc:mysql://localhost:3306/blister2_metrolotto?createDatabaseIfNotExist=true&useSSL=false

spring.datasource.username=blister2_metro

spring.datasource.password=thisisnotapassword

Thanks again for your help.

 

PS. I'm a newbee trying to learn some programming.

[Krydos]

It just gives this error over and over, and it blocks it from starting:

org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User blister2_metro already has more than 'max_user_connections' active connections

[blister2]

I upload new metrolotto.war file with some changes. Could you please try deploying again? I appreciate your help.

[Krydos]

Same error. Still won't start.

[blister2]

I added the below code that should take care of max_user_connection issue on a Production DB (source)

 

spring.datasource.tomcat.test-on-borrow=true

spring.datasource.tomcat.max-active=20

spring.datasource.tomcat.max-wait=10000

I uploaded a new metrolotto.war. Could you please try deploying again at your convenience? Thank you!

[Krydos]

Same error.

spring.datasource.tomcat.max-active=20

Try setting that to 4 instead of 20.