How to configure postgres sql URL in JDBC using spring.xml

We are using Spring mvc for our project. In Spring.xml we want to use our newly migrated postgres db. But we are not being able to configure the url.

<property name="url" value="jdbc:postgresql://ea957de9-2271-4d6c-999e-f2c250575850.budepemd0im5pmu4u60g.private.databases.appdomain.cloud:30352/ibmclouddb?sslmode=verify-full;sslrootcert=/resources/iitStaticContent/root.crt"></property>  <property name="username" value=""></property>  <property name="password" value=""></property>    <bean id="jt" class="org.springframework.jdbc.core.JdbcTemplate">  <property name="dataSource" ref="ds"></property>  </bean>  

This gives us an error: [err]

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: Invalid sslmode value: verify-full;sslrootcert=/opt/ibm/wlp/usr/servers/defaultServer/resources/iitStaticContent/root.crt  [err]   at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)  [err]   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:390)  

https://stackoverflow.com/questions/67294408/how-to-configure-postgres-sql-url-in-jdbc-using-spring-xml April 28, 2021 at 01:48PM