How to reproduce ? any code example ? 在 2015年3月31日星期二 UTC+8下午4:02:02，LL写道： > > Hi, I'm new to java and h2 database. > I'm making an application to insert many data. > I'm using h2-1.4.186 currently. > > The application flow of my application is check if the data is already > inserted before, if not, insert the data. > > First time running the application, database size is around 4mb, no trace > db. > Second time running, all the datas are already inserted so it's only > checking on the db, size still same, 1.3mb trace db. > Third time running, size reduced to arround 2mb even though there's > deletion or change to the data, 2.5mb trace db. > Fourth time running, size reduced to 276kb(what??), 3.8mb trace db. > Fifth time running, size is reduced to 128kb, 5.2mb trace db. > > After that, the size will keep changing around 100 - 200kb even though > there's no changes or deletion made to the data. > > In the trace db, all the errors are 'org.h2.message.DbException: The > connection was not closed by the application and is garbage collected > [90018-186]'. > In every database operation, I always create connection and statement then > close them immediately, it's weird that I got that error. > > The trace db keeps increasing, and have no sign or creating new file. > Currently it's 21mb, while in the site it said that trace db default limit > is 16mb. I'm mostly afraid of trace db continuining to increase until gb > size. > > I posted in other thread with similiar post before this, you can delete > that :) > > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
