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.be...@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 <slaye...@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 <clinton.be...@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, <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 > > > > > > > > > > > > -- > > 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 > > > > -- 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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org