AppletTalk.com

Thijs David · Guest

Hey all,

As said in the subject, I'm a newbie with a problem on an Interbase
connection.
I'm writing a converter, to put a standard text-file into a table of a
database.
Therefor I first need to do some operations on the text, these work well.
For the moment I put every line of the database into a HashMap, when the
whole text-file has been converted I want to put the content of the HashMap
into a table of the database. All works fine, when I do this one record at a
time (so for each record, I open a connection and after the insertion I
close it again).
I triead to keep the connection open while inserting all the records one by
one, but each time I get a socket connection error, from Interbase.
Is there a solution for this.
Note that I can't use a ResultSet to put my data in, because my
InterbaseDriver isn't JDBC 2 compatible (I know this because I allready
tried it).
So what I need to know is, if there's a way to keep the connection open
until the insertion of records is finished.
Is there a better way to temporary store the lines of the text-files and to
finally insert them into a Interbase-table.

Greetings,

David