R
Railway12mo ago
Audry

Failing to connect Spring Boot with PostgreSQL with jdbc

Hello all! I am having issues trying to deploy my spring boot project. Everything works fine on localhost. The issue seems to be with jdbc when trying to deploy. I made sure to create a postgreSQL project and provide the DATABASE_PRIVATE_URL variable to the spring boot project, and the following is the error message I get through the logs: ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dataSourceScriptDatabaseInitializer' defined in class path resource [org/springframework/boot/autoconfigure/sql/init/DataSourceInitializationConfiguration.class]: Unsatisfied dependency expressed through method 'dataSourceScriptDatabaseInitializer' parameter 0: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception with message: Failed to determine a suitable driver class Description: Failed to configure a DataSource: no embedded datasource could be configured. Reason: Failed to determine a suitable driver class Here it is the section of the properties file that's relevant to the datasource spring.datasource.url=jdbc:${DATABASE_PRIVATE_URL} spring.datasource.username=${POSTGRES_USER} spring.datasource.password=${POSTGRES_PASSWORD} spring.jpa.generate-ddl=true spring.jpa.hibernate.ddl-auto=update spring.jpa.show-sql=true javax.persistence.schema-generation.scripts.action=drop-create spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect server.error.include-message = "always" spring.jpa.properties.hibernate.jdbc.time_zone=UTC spring.mvc.format.date-time=iso spring.jackson.serialization.FAIL_ON_EMPTY_BEANS=false Any help will be really appreciated !
6 Replies
Percy
Percy12mo ago
Project ID: fcc8b408-8ee0-4c61-9fff-e395f93c2d56
Audry
Audry12mo ago
Guessing the project ID is the same as Service ID project ID: fcc8b408-8ee0-4c61-9fff-e395f93c2d56 Just as a side note; I am still under the hobby plan which offers only 512mb of ram, and I can see the build of my app is about 1.1 Gb. Could this issue be somehow related ?
Brody
Brody12mo ago
DATABASE_PRIVATE_URL is not in the correct format that spring expects, please read the spring documentation on how that variable should be formatted
Audry
Audry12mo ago
the DATABASE_PRIVATE_URL is a reference variable from a postgreSQL service(id: fcc8b408-8ee0-4c61-9fff-e395f93c2d56), I didn't format it manually. I only added the "jdbc" prefix to the DATABASE_PRIVATE_URL to form the url to be used for datasource purposes. it looks like this: spring.datasource.url=jdbc:${DATABASE_PRIVATE_URL} Is there something I am missing ? Again, I didn't manually format the variable, but refered to it.
Brody
Brody12mo ago
right, it comes with the wrong format, please reference spring's docs for the correct format
Want results from more Discord servers?
Add your server