Re: [h2] H2 database connection pool issue

1. Hmm, I get connection from the pool and I close it in the finally block. How can a leak occur? 2. I did at one point print the active connections(in the getConnection method) and the max I saw was 3. I have set 100 as max. On Tuesday, April 24, 2018 at 2:09:59 PM UTC-5, Noel Grandin wrote:

[h2] What is the behavior of deleting an index and adding a new one?

Hi, I have a production database and due to some changes I want to delete the existing index and add a new one on a specific table. Will the new index be automatically built from the past data or will it be only effective for new data? Thanks, Imran. -- You received this message because

[h2] Very large database created during test

Hi, After inserting about 50,000 records the database size grew to 114 GB and our virtual machine crashed as the disk ran out of memory. The data in each row is very small in size but inserted and queried very rapidly. No blobs or clobs. H2 version is 1.4.196. This is very concerning as

[h2] Same database but different data?

This is a very strange problem. I have a prior application that is being ported. There is data for that application. When the prior database is opened the new application, the old data does not show. I can add data to the same tables that existed in the previous application. However, when I

[h2] How to delete duplicate rows?

Greetings, How do I go about deleting duplicate rows? In other words, if multiple rows have a same value for a specific column, how do I go about deleting all but one rows? Thanks, Imran. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To