How to enforce foreign keys using Xerial SQLite JDBC?
- by Space_C0wb0y
According to their release notes, the Xerial SQLite JDBC driver supports foreign keys since version 3.6.20.1. I have tried some time now to get a foreign key constraint to be enforced, but to no avail. Here is what I came up with:
public static void main(String[] args) throws ClassNotFoundException, SQLException {
…