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.
