how to read multiple (binary) lines from text file / stdin?

[armin walland]

hi group!
i am writing a small tool to dump data from oracle databases and i want
to implement the possibility to execute sql statements read from stdin
or from a file. i have so far managed to do so, but every sql statement
must be on a single line with no ";" at the end of each line.

i would like to use an input file like this:
-- file statement.sql --
select * from table
where thing = "something" ;
------------------------
or

-- file statement.sql --
update table
set image = '<binary data>'
where thing = otherthing;
------------------------

this is how the code looks so far:
// code start

BufferedReader in = new BufferedReader( new FileReader(file name));

while (((statement=in .readLine())!= null) &&(!statement.e quals(""))){
try {
ResultSet rset = stmt.executeQue ry(statement);
[...]
}
}

// code end
i would like 'statement' to contain the multiline sql statement
including all newlines so that also binary data may be inserted into the
db so i tried to use

System.setPrope rty("line.separ ator", ";");

but that didn't help and also doesn't seem the right way for what i want
to achieve. could someone please point me into the right direction on
how to do that? the variety of different stream classes is somewhat
confusing in terms of finding the right class for the right job.
big TIA, armin
--
armin walland

focusmr.com
maculangasse 8
1220 wien

[FISH]

armin walland <ge******@gmx.a t> wrote in message news:<sl******* **************@ armin.focusmr.c o.at>...

hi group!
i am writing a small tool to dump data from oracle databases and i want
to implement the possibility to execute sql statements read from stdin
or from a file. i have so far managed to do so, but every sql statement
must be on a single line with no ";" at the end of each line.

Take a look at the StreamTokenizer class in java.io . It is quite
daunting for beginners, so you might want to Google around for a good
tutorial on how to use it. It is designed to parse language source
code, and has a few handy in-built features for handling comments and
string literals, etc.
-FISH- ><>

[armin walland]

On 2004-01-27, FISH <jo*****@mersey mail.com> wrote:

armin walland <ge******@gmx.a t> wrote in message news:<sl******* **************@ armin.focusmr.c o.at>...

i am writing a small tool to dump data from oracle databases and i want
to implement the possibility to execute sql statements read from stdin
or from a file. i have so far managed to do so, but every sql statement
must be on a single line with no ";" at the end of each line.

Take a look at the StreamTokenizer class in java.io . It is quite
daunting for beginners, so you might want to Google around for a good
tutorial on how to use it. It is designed to parse language source
code, and has a few handy in-built features for handling comments and
string literals, etc.

thanx a lot :)
rgds, armin
--
armin walland

focusmr.com
maculangasse 8
1220 wien
[phone]