[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2403) Support multi-line import.sql files

[Lukasz Antoniak (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lukasz Antoniak resolved HHH-2403.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 4.0.0.CR6

I haven't noticed that semicolon is not mandatory at the end of each SQL statement.

Since version 4.0.0.CR6 {{hibernate.hbm2ddl.import_files_sql_extractor}} configuration parameter has been introduced. See Hibernate documentation and JavaDoc of {{org.hibernate.tool.hbm2ddl.ImportSqlCommandExtractor}} interface and two implementations: {{org.hibernate.tool.hbm2ddl.SingleLineSqlCommandExtractor}} (default) and {{org.hibernate.tool.hbm2ddl.MultipleLinesSqlCommandExtractor}}. You can register your own implementation through configuration parameter or {{ServiceRegistryBuilder}}.

> Support multi-line import.sql files
> -----------------------------------
>
>                 Key: HHH-2403
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2403
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.2.2
>            Reporter: Christian Bauer
>            Assignee: Lukasz Antoniak
>             Fix For: 4.0.0.CR6
>
>         Attachments: org.hibernate.tool.hbm2ddl.SchemaExport_patch.txt
>
>
> I leave this as Major, because it most likely breaks all existing import.sql's.
> The statement delimiter in import.sql is currently a newline. We need to change that to:
> - delimiter is semicolon, so users can copy/paste stuff from and to SQL consoles
> - newline is a real newline, allows users to enter newlines into larger text columns without a 5000 character wide line

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira