#5 jmbase import terminates abruptly

[Helmut Leininger]

Hi,

After importing of between 6500 and 8000 CDs of 46000,
the import process terminates without appearent reason.

ImportWorker.construct is left although the count is
not reached. There is no Exception seen and "finally"
is entered.

During clear() (called by close()) there is an
OutOfMemory exception.

The problem does not always come up at exactly the same
position, but it is reproduceable.

System environment:
Windows2000 SP4
Java 1.4.2_03
MySQL 4.1.1a-alpha
Connector/J 3.1 nightly 20040213

Regards

[Nobody/Anonymous]

Logged In: NO

Memory leak ?

[Helmut Leininger]

Logged In: YES
user_id=976100

Statements created in cddbMysqlInterface must be closed
before leaving the method to free the resources (ResultSet etc.)

It would be an even better idea to pool (cache) the
Statements to avoid the costly createStatement for every item.

Besides that, the error handling could be improved (if the
connection to the databse is lost during the import, the
import is not stopped).

[Ivan Mirisola]

Logged In: YES
user_id=177511

Hi Helmut Leininger,

I am no expert in Java, but I was experiencing the exactly
same problem here.

Did you manage to make JMBase work? If so, can you provide
us the code part that you have changed in cddbMysqlInterface?

Thanks in advance,
Ivan Mirisola
Sao Paulo, Brazil.

[Helmut Leininger]

Logged In: YES
user_id=976100

Ivan,
I made it run for my purposes. I did several changes, not
all of them necessary for fixing the problem. I used some
methods of a small library of my own.
So, it might be some work to do to compare with the original
to see the changes.
I attach the sources of the running version and my library.

Regards

[Helmut Leininger]

contains sources of jmbase and hltools

[Helmut Leininger]