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

Question

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.

<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)

try reading the error message Invalid sslmode value: verify-full — Scary Wombat
– Scary Wombat, Commented Apr 28, 2021 at 5:55
but as far as i understand sslmode=verify-full is a valid option. — Akancha Singh
– Akancha Singh, Commented Apr 28, 2021 at 5:56
Maybe it is what comes next - the format is jdbc:postgresql://<instance_ip>:<instance_port>/<database_name>?sslmode=verify-full&sslrootcert=<ca.pem> — Scary Wombat
– Scary Wombat, Commented Apr 28, 2021 at 6:02

Laurenz Albe · Accepted Answer · 2021-04-28 06:08:00Z

2

You use an ampersand (&), not a semicolon (;), to separate options in an URL.

You may need to encode that as & in XML.

edited Apr 28, 2021 at 6:08

answered Apr 28, 2021 at 5:56

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Akancha Singh Over a year ago

Whenever i use an '&' i am getting a compilation error in eclipse saying Multiple annotations found at this line: - Start tag of element <property> - The reference to entity "sslcert" must end with the ';' delimiter. - End tag of element <property>

Laurenz Albe Over a year ago

Try encoding it, as suggested in my extended answer.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related