ScriptRunner question
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
ScriptRunner question
by Paule-5
::
Rate this Message:
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@... For additional commands, e-mail: user-java-help@... |
|
|
Re: ScriptRunner question
by Clinton Begin
::
Rate this Message:
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@...> wrote: Hello! |
|
|
Re: ScriptRunner question
by Paule-5
::
Rate this Message:
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 <clinton.begin@...> > An: user-java@... > 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, <slayer81@...> 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@... > > For additional commands, e-mail: user-java-help@... > > > > -- 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@... For additional commands, e-mail: user-java-help@... |
|
|
Re: ScriptRunner question
by Clinton Begin
::
Rate this Message:
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 <slayer81@...> wrote: Thank you for your reply, Clinton :) |
|
|
Re: ScriptRunner question
by Paule-5
::
Rate this Message:
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 <clinton.begin@...> > An: user-java@... > 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 <slayer81@...> 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 <clinton.begin@...> > > > An: user-java@... > > > 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, <slayer81@...> 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@... > > > > For additional commands, e-mail: user-java-help@... > > > > > > > > > > > > -- > > 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@... > > For additional commands, e-mail: user-java-help@... > > > > -- 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@... For additional commands, e-mail: user-java-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
