Announcement Announcement Module
Collapse
No announcement yet.
SQLITE and foreign key support Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLITE and foreign key support

    Anyone had any success in getting sqlite and spring working with foreign key support enabled? By default foreign key support is disabled in sqlite. The documentation at http://www.sqlite.org/foreignkeys.html mentions that you have to enable it for each database connectiion separately. I am sure that the version of sqlite I have got supports foreign keys (downloaded it only last week).

    to test: If I key in PRAGMA foreign_keys; I get back 0. Which means foreign keys is switched off but support for it exists.

    My datasource is defined in spring as :
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driverclass}"/>
    <property name="url" value="${jdbc.url}"/>
    </bean>


    How do I enable foreign keys through spring configuration?

  • #2
    Can you try adding <property name="enforceForeignKeys" value="true"/> ?

    I hope this work.

    Comment


    • #3
      Originally posted by m_auro1 View Post
      Can you try adding <property name="enforceForeignKeys" value="true"/> ?

      I hope this work.
      That did not work as I expected. The BasicDataSource class does not have a setter for enforceForeignKeys therefore you cannot inject it.

      Comment


      • #4
        Maybe this:

        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name = "connectionInitSqls">
        <list><value>PRAGMA foreign_keys = ON</value></list>
        </property>
        ...
        </bean>

        Sorry but i can't try it now.

        Comment


        • #5
          Originally posted by m_auro1 View Post
          Maybe this:

          <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
          <property name = "connectionInitSqls">
          <list><value>PRAGMA foreign_keys = ON</value></list>
          </property>
          ...
          </bean>

          Sorry but i can't try it now.
          Thanks, that worked perfectly.

          Comment

          Working...
          X