{{theTime}}

Search This Blog

Total Pageviews

java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint xxxxx

Quick Fix:

Delete the referred record in child table.  Or implement Cascade delete feature.

No comments:

Mysql - java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed

Add allowPublicKeyRetrieval=true to the JDBC URL. jdbc:mysql://localhost:3306/db?allowPublicKeyRetrieval=true&useSSL=false