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