Spring Framework
  1. Spring Framework
  2. SPR-7700

Add configurable SQL statement delimiter to ResourceDatabasePopulator and JDBC XML namespace.

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 3.0.4
    • Fix Version/s: None
    • Component/s: Core
    • Labels:
      None
    • Last commented by a User:
      false

      Description

      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>
      

        Issue Links

          Activity

          Hide
          Chris Beams added a comment -
          Show
          Chris Beams added a comment - See SPR-8817

            People

            • Assignee:
              Chris Beams
              Reporter:
              Kyrill Alyoshin
              Last updater:
              Trevor Marshall
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 21 weeks ago