SQLITE and foreign key support

[gurps]

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?

[m_auro1]

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

I hope this work.

[gurps]

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.

[m_auro1]

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.

[gurps]

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.