ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: ScriptRunner question
Date Fri, 26 Jun 2009 00:11:16 GMT
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, <slayer81@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message