Hello all again. Just wanted to remind that the problem was transferring data from Oracle to SQL Server. After comming accross with the Heap Size of JVM I decided to make a procedure on the Oracle side which reads data from it's own tables and writes lines to a text file on the server. After I move the file onto the SQL server where I load data from it with the aid of BULK INSERT. This method works with any number of rows( nearly 15 million in my case) and there is no any load on the client running the soft. Bye all.
Rob, request turns into this. I know beforehand that the ResultSet stores nearly 120.000 rows. How can I read part by part(say by 10.000) rows from this result set so that there is no need to increase the JVM Heap Size? PLease suggest. Thanks.
I'm an ordinary memeber and I cannot move it "Only administrators or moderators may perform this action" is displayed when trying to move. Could you please move it?
Hello! Well, with getString() hangs as well. Could you please say what do you mean by "moving to JDBC"? As far as I know the code I use to connect to the database is a part of it, isnt it?
Hi, Running it outside IntelliJ was the first thing I did, which was giving the same result. As you could see from the code I'm using JDBC and nothing else.
Thanks for suggestions. selectStat is a simple SELECT that reads data from Oracle tables. Placing close() and flush() in the finally block didnt help. I removed PrintWriter and put System.out.println() instead, the result is the same. The matter is not in the server memory for sure, because in PL/SQL developer this query executes good returning 1.5 million of rows. Even with System.out.println() the query stops after the 92000th (plus mines 5 rows) row. "Stop" in the direct sense: System.out.println() suspends (IntelliJ IDEA) and no exception is thrown. Thanks for the reply.
Hello! I'm writing a ResultSet data delmited by '*' into a text file using the PrintWriter. The ResultSet is ok, but when writing nearly 45.000 it's fine, when two times larger it's all right, but when three times seems PrintWriter doesnt want to go on writing for some reason and stops without any exception. Cannot really find out why. Please suggest what could be the possible reasons? Thanks!!!