You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by sl...@gmx.de on 2009/06/25 20:47:09 UTC
ScriptRunner question
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
Re: ScriptRunner question
Posted by Matthias Paul <sl...@gmx.de>.
Then I'm looking forward to iBatis 3 :)
Doesnt depend on setDelimiter(), it looks as if the newline character is trimmed from input script in any case. Patched the file and it works now.
Thank you!
Paule
-------- Original-Nachricht --------
> Datum: Sat, 27 Jun 2009 13:52:38 -0600
> Von: Clinton Begin <cl...@gmail.com>
> An: user-java@ibatis.apache.org
> Betreff: Re: ScriptRunner question
> No, but in iBATIS 3 there is. :-)
>
> It looks to me that in the example below, you possibly didn't
> setFullLineDelimiter(true);
>
> There's a difference in parsing if the delimiter is the whole line.
>
> Cheers,
> Clinton
>
> On Sat, Jun 27, 2009 at 1:29 PM, Matthias Paul <sl...@gmx.de> wrote:
>
> > Thank you for your reply, Clinton :)
> >
> > Is there another supported way to transfer scripts to database yet? Or
> isnt
> > iBatis meant to do such tasks?
> >
> >
> > Paule
> >
> >
> > -------- Original-Nachricht --------
> > > Datum: Thu, 25 Jun 2009 18:11:16 -0600
> > > Von: Clinton Begin <cl...@gmail.com>
> > > An: user-java@ibatis.apache.org
> > > Betreff: Re: ScriptRunner question
> >
> > > 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, <sl...@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
> > > >
> > > >
> >
> > --
> > 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
> >
> >
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: ScriptRunner question
Posted by Clinton Begin <cl...@gmail.com>.
No, but in iBATIS 3 there is. :-)
It looks to me that in the example below, you possibly didn't
setFullLineDelimiter(true);
There's a difference in parsing if the delimiter is the whole line.
Cheers,
Clinton
On Sat, Jun 27, 2009 at 1:29 PM, Matthias Paul <sl...@gmx.de> wrote:
> Thank you for your reply, Clinton :)
>
> Is there another supported way to transfer scripts to database yet? Or isnt
> iBatis meant to do such tasks?
>
>
> Paule
>
>
> -------- Original-Nachricht --------
> > Datum: Thu, 25 Jun 2009 18:11:16 -0600
> > Von: Clinton Begin <cl...@gmail.com>
> > An: user-java@ibatis.apache.org
> > Betreff: Re: ScriptRunner question
>
> > 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, <sl...@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
> > >
> > >
>
> --
> 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
>
>
Re: ScriptRunner question
Posted by Matthias Paul <sl...@gmx.de>.
Thank you for your reply, Clinton :)
Is there another supported way to transfer scripts to database yet? Or isnt iBatis meant to do such tasks?
Paule
-------- Original-Nachricht --------
> Datum: Thu, 25 Jun 2009 18:11:16 -0600
> Von: Clinton Begin <cl...@gmail.com>
> An: user-java@ibatis.apache.org
> Betreff: Re: ScriptRunner question
> 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, <sl...@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
> >
> >
--
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
Re: ScriptRunner question
Posted by Clinton Begin <cl...@gmail.com>.
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, <sl...@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
>
>