ScriptRunner trims symbols the end of a line.

[GoogleCodeExporter]

If sql the command in a file consists from some lines, after executing 
this command by ScriptRunner sql presented as one line. It worsens sql 
readability of created db objects.

This was tested on the 0.9.2 build.

Probably these changes are planned in the next release?

ReleaseNotes   
v0.9.3 - NOT YET RELEASED
ScriptRunner improvements for MySQL (functions, stored procs, and comments)

Variant of resolving this issue:
in com.carbonfive.db.jdbc.ScriptRunner replace 2 matches
command.append(" ");
to 
command.append(" \n");

Original issue reported on code.google.com by tumakha on 8 Oct 2008 at 12:53

[GoogleCodeExporter]

My resolving for this issue in attachment ScriptRunner.java

Original comment by tumakha on 8 Oct 2008 at 1:27

Attachments:

• ScriptRunner.java

[GoogleCodeExporter]

Original comment by christia...@gmail.com on 21 Oct 2008 at 3:32

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by christia...@gmail.com on 21 Oct 2008 at 3:32

[GoogleCodeExporter]

tumakha: I'm not going to fix this one.  It's cosmetic really, as it's just in 
the
log.  It's also consistent with some what other frameworks are doing.  For 
example,
if you look at the SQL hibernate spits out during the hbm2ddl process, it's also
condensed down to one line.  Take care, Christian

Original comment by christia...@gmail.com on 19 Jan 2009 at 5:33

• Changed state: WontFix