Fadai Ganjaliyev

Greenhorn
+ Follow
since May 19, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Fadai Ganjaliyev

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.
Hi, Rob.
Finally got that
"Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space".

But yet dont know what is the general solution of it.
Thanks for all anyway. I also hope that someone else will suggest smth.
Hi, Rob!
I was wondering if there were any other suggestions?
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?
Well, noticed another thing.
In the following loop this

woks fine, but this

hangs.


Turns out the reason is in retrieving data.
Hi, strange might seem, this works



but this


on a ceratin step stops.
PLease suggest.
Thanks for the reply.
Here what selectStat is
I could completely understand what you mean by this
"What does selectStat do that just plain JDBC classes don't do?"
PLease clarify.
Thanks!!!
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.
Hi, yes the PrintWriter is closed at the end.
This is the sample code



No exception is thrown.
Writes about 45000 records, 90.000 as well, but more than 92.000 does not.
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!!!