> Yes, one transaction that is still open can cause this. When you say
> "atomic", do you mean that the transaction is opened then comitted for
> each request and/or insert!

Exactly. We are using JDBC in auto-commit mode, I mean, all SQL statements
will be executed and committed as individual transactions. So, how come it
is possible to have an openned transaction? Do you know any other possible
reason for the indefinite growth of the database?

>One thing that you also have to remember,
> that a select that is still open is keeping a transaction open.

What do you mean exactly by that? Could it be happenning with JDBC?

Diego Moreira da Rosa

DataCom Telemática
Av França, 735 - Porto Alegre, RS - 90230-220
PBX: 51 3358 0100
DDR: 51 3358 01xx
Fax: 513358 0101
www.datacom-telematica.com.br



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.486 / Virus Database: 284 - Release Date: 29/5/2003