Hibernate cannot parse connection String

Question

According to Mysql documentation, this connection string from xml configuration file is correct:

<property name="hibernate.connection.url">jdbc:mysql:///database?useSSL=false&allowPublicKeyRetrieval=true</property>

And Mysql Connector/J parses the query parameters correctly.

However same connection string fails to be parsed correctly when Hibernate configures StandardServiceRegistryBuilder as the parser expects that that "&" is a start of an entity name. I found another suggestion to replace "&" with "&" but this doesn't work either.

So what is the correct way of providing more than 1 parameter in hibernate xml configuration file? I'm using Mysql 8, Connector 8.0.13, Java 11 and Hibernate 5.3.7.

Could you post the error you get when you use the '&' variant? — schtever
– schtever, Commented Mar 10, 2019 at 18:09
With the &' connection string cannot be parsed in Connector/J. When getting query properties,you end up with amp key with no value. — Enzomatric
– Enzomatric, Commented Mar 10, 2019 at 20:56

romeucr · Accepted Answer · 2020-07-30 08:34:15Z

4

I had the same problem and it worked to me using & to concatenate parameters:

<property name="javax.persistence.jdbc.url" 
                value="jdbc:mysql://localhost/pbdatabase?useSSL=false&amp;serverTimezone=UTC&amp;allowPublicKeyRetrieval=true" />

answered Jul 30, 2020 at 8:34

romeucr

2295 silver badges14 bronze badges

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

Comments

Latera · Accepted Answer · 2019-03-10 17:01:40Z

0

Would you try below?

<property name="hibernate.connection.url" value="jdbc:mysql:///database?useSSL=false&allowPublicKeyRetrieval=true" />

answered Mar 10, 2019 at 17:01

Latera

281 gold badge1 silver badge7 bronze badges

2 Comments

Enzomatric Over a year ago

Unfortunately, it is same problem "The reference to entity "allowPublicKeyRetrieval" must end with the ';' delimiter."

Latera Over a year ago

How about

<property name="hibernate.connection.url" value="jdbc:mysql:///database?useSSL=false&amp;allowPublicKeyRetrieval=true" />

?

Collectives™ on Stack Overflow

Hibernate cannot parse connection String

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related