Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of slayer81@gmx.de designates
 213.165.64.20 as permitted sender)
Content-Type: text/plain; charset="iso-8859-1"
Date: Sat, 27 Jun 2009 21:29:53 +0200
From: "Matthias Paul" <slayer81@gmx.de>
In-Reply-To: <16178eb10906251711q380feaabj4b564b077944c5b0@mail.gmail.com>
Message-ID: <20090627192953.186040@gmx.net>
MIME-Version: 1.0
References: <20090625184709.148300@gmx.net>
 <16178eb10906251711q380feaabj4b564b077944c5b0@mail.gmail.com>
Subject: Re: ScriptRunner question
To: user-java@ibatis.apache.org
Content-Transfer-Encoding: 8bit

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@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, <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
> >
> >

-- 
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