Memory problems with Derby / Cloudscape Network Server
$30-40 USD
Fechado
Publicado há mais de 18 anos
$30-40 USD
Pago na entrega
I am having problems while using the Derby database as a network server. It seems to be using more and more memory and then finally aborts with an Out of Memory condition. This situation can easily be recreated by loading a database multiple times, doing deletes, etc and then finally, it runs out of memory. It may be that the routines I am using have a memory leak. I have attached the routines I use for JDBC access and to create the Derby Network Server. The command [login to view URL]() will print out what the server has in memory as far as preparedStatements, etc. I have tried changing the Max Heap for Java on the derby call. This only delays the inevitable. I have tried doing a compress of the table to recover memory. This does not seem to help particularly.
public void compressPkDetail(Connection Conn)
{ CallableStatement cs = null;
try
{ cs = [login to view URL]("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE (?, ?, ?)");
}
catch (Exception e) {
[login to view URL]("Exception");
[login to view URL]("Creating callable compress statement");
}
compressTable(cs, "test");
try {
[login to view URL]();
}
catch (Exception e) {
[login to view URL]("Exception");
[login to view URL]("Closing callable compress statement");
}
}
public void compressTable(CallableStatement cs, String TableName)
{
try
{ [login to view URL](1, "schema");
[login to view URL](2, TableName);
[login to view URL](3, (short) 1);
[login to view URL]();
}
catch (Exception e) {
[login to view URL]("Exception");
[login to view URL]("Compressing table " + TableName);
}
}
I need help to resolve the memory leak on Derby either by helping to look at my code or providing code which does not have such a leak.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows, Linux