Add configurable SQL statement delimiter to ResourceDatabasePopulator and JDBC XML namespace. [SPR-7700]

[spring-projects-issues]

Kyrill Alyoshin opened SPR-7700 and commented

It sure would be nice if org.springframework.jdbc.datasource.init.ResourceDatabasePopulator provided a way to configure its SQL statement delimiter. Currently it is hard-coded to ';'. It works great for simple statements, but what if need to load a stored-procedure where ';' cannot be stripped out?

Also, the delimiter configuration should probably be extended to the XML namespace too, as in:

<jdbc:embedded-database>
     <jdbc:script location="..." delimiter="/"/>
</jdbc:embedded-database>

---

Affects: 3.0.4

Issue Links:

• Support per-script statement separator configuration for SQL scripts [SPR-8817] #13459 Support per-script statement separator configuration for SQL scripts ("duplicates")

[spring-projects-issues]

Chris Beams commented

See #13459