How do you enforce foreign key constraints in SQLite through Java?

by

Code like this:

DriverManager.getConnection("jdbc:sqlite:some.db;foreign keys=true;")

Does not work.
You have to create org.sqlite.SQLiteConfig and set it as properties when call getConnection from DriverManager.

public static final String DB_URL = "jdbc:sqlite:database.db";  
public static final String DRIVER = "org.sqlite.JDBC";  

public static Connection getConnection() throws ClassNotFoundException {  
    Class.forName(DRIVER);  
    Connection connection = null;  
    try {  
        SQLiteConfig config = new SQLiteConfig();  
        config.enforceForeignKeys(true);  
        connection = DriverManager.getConnection(DB_URL,config.toProperties());  
    } catch (SQLException ex) {}  
    return connection;  
}

This code taken from this.

More Related Contents:

  1. Foreign key constraints in Android using SQLite? on Delete cascade
  2. How to connect SQLite with Java?
  3. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  4. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  5. Java and SQLite [closed]
  6. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  7. Efficient way to do batch INSERTS with JDBC
  8. Java: Insert multiple rows into MySQL with PreparedStatement
  9. SQLite in Android How to update a specific row
  10. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  11. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  12. java.util.stream with ResultSet
  13. JDBC ResultSet get columns with table alias
  14. How to start a transaction in JDBC?
  15. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  16. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  17. Populating jTable using database data
  18. How to simulate a DB for testing (Java)?
  19. SQLiteOpenHelper failing to call onCreate?
  20. is there a standard way to define a JDBC Datasource for Java EE containers?
  21. How to get *everything* back from a stored procedure using JDBC
  22. Using a prepared statement and variable bind Order By in Java with JDBC driver
  23. Light weight alternative to Hibernate? [closed]
  24. How do I unit test jdbc code in java? [closed]
  25. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  26. Why do we use a DataSource instead of a DriverManager?
  27. Do I need to close ‘PreparedStatement’? [closed]
  28. hibernate two tables per one entity
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment