ScriptRunner isn't really a supported feature of iBATIS. It's meant for
utilities and unit tests only.
Its API may change significantly in the future without warning.
Clinton
On Thu, Jun 25, 2009 at 12:47 PM, <slaye...@gmx.de> wrote:
> Hello!
>
> Using iBatis 2.3.4.726.
> Had some problems with transfering a SQL script (a Oracle package) to
> Oracle database with iBatis' ScriptRunner.
> The SQL script file looked smth like this:
>
>
>
> -- MYPACKAGE package specification
> create or replace package MYPACKAGE as
>
> -- commentary here
> procedure PROCEDURE1 (
> PARAMETER1 in number
> );
>
> -- insert GVC rule
> procedure PROCEDURE2 (
> PARAMETER1 in number
> );
>
>
> end MYPACKAGE;
> /
>
>
>
>
>
> I called ScriptRunner method "setDelimiter("/", true)" to set single line
> delimiter to "/". The script was tranfered to database, but on a single line
> with over 20k length, which isnt easy to read or decipher.
>
> Mot sure about that, but shouldnt there be a NEWLINE character appended
> after each line read from the script by ScriptRunner.runScript(Connection
> conn, Reader reader) ?
>
> Another thing is: The if-then-else block starting at line 147 looks weird.
> I dont understand why some comments are left out (or: written to log writer)
> while others are not. Are "//" and "--" comment types database
> system-dependent? And isnt the LineNumberReader supposed to return the
> current line number on errors?
>
>
> Thank you for your time!
> Paule
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
