Spring Boot gives an error of URL must start with 'jdbc'

Question

I am trying to configure a Postgres database in spring boot using annotation configuration. I have all the database credentials in a file named database.properties and the configuration file is called DBconfig.java

database.url= jdbc:postgresql://localhost/mydb 
database.driverClassName= com.postgresql.jdbc.Driver
database.username= postgres
database.password= password

The dbConfig file -

@Configuration
@PropertySource("classpath:databaseAccess/database.properties")

public class DBconfig {

  @Value("${username}")
  private String username;

  @Value("${password}")
  private String password;

  @Value("${url}")
  private String url;

  @Bean
  @Qualifier("postgresDB")
  public DataSource dataSource() {
    DataSourceBuilder dataSource = DataSourceBuilder.create();
    dataSource.url(url);
    dataSource.password(password);
    //dataSource.driverClassName(driverClassName);
    dataSource.username(username);
    return dataSource.build();
  }

  @Bean
  @Qualifier("jdbcTemplate")
  public JdbcTemplate jdbcTemplate() {
      return new JdbcTemplate(dataSource());
  }
}

This is my main file

     @SpringBootApplication
     public class GetNotificationsApplication {

        public static void main(String[] args) {

           ApplicationContext ctx = new AnnotationConfigApplicationContext(DBconfig.class);
           JdbcTemplate template= ctx.getBean("jdbcTemplate", JdbcTemplate.class);
           template.execute("CREATE TABLE TEST( test VARCHAR(20))");

        }

     }

I keep getting the error Factory method 'dataSource' threw exception; nested exception is java.lang.IllegalArgumentException: URL must start with 'jdbc'

Does value in url has proper value as it's in properties file? — Yogendra Mishra, Jul 11 '20 at 01:53
Yup I started a Postgres server on my computer at port 8080. — JavaMachine42, Jul 11 '20 at 02:00
Postgres server at 8080 then which port your spring app is running? — Yogendra Mishra, Jul 11 '20 at 02:31

Alien · Accepted Answer · 2020-07-11T03:21:35.957

0

Try to change value for url parameter by defining port number for postgres. Assuming that postgres is running on 5432 which is the default port.

Change

jdbc:postgresql://localhost/mydb

To

jdbc:postgresql://localhost:5432/mydb

For port number check Find the host name and port using PSQL commands

UPDATE:

Also change @Value("${username}") to @Value("${database.username}") and other properties too by prefix database.

edited Jul 11 '20 at 03:21

answered Jul 11 '20 at 02:40

Alien

15,141
6
37
57

I did change it but It still is giving the same error. – JavaMachine42 Jul 11 '20 at 03:09
Got the issue...check answer now. – Alien Jul 11 '20 at 03:22

Spring Boot gives an error of URL must start with 'jdbc'

1 Answers1