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