[h2] Please suggest, I am getting this error while I am doing Maven clean install on my project. Thanks in advance.

2015-01-06 Thread Saransh Tripathi
[java] generateScript: [java] [eclipse.buildScript] Some inter-plug-in dependencies have not been satisfied. [java] [eclipse.buildScript] Bundle org.h2: [java] [eclipse.buildScript] Unsatisfied import package javax.servlet_0.0.0. [java] [eclipse.buildScript] Unsatisfied i

[h2] Please suggest for this error, When I am doing Maven clean install on my project getting this error. Thanks in advance.

2015-01-06 Thread Saransh Tripathi
[java] generateScript: [java] [eclipse.buildScript] Some inter-plug-in dependencies have not been satisfied. [java] [eclipse.buildScript] Bundle org.h2: [java] [eclipse.buildScript] Unsatisfied import package javax.servlet_0.0.0. [java] [eclipse.buildScript] Unsatisfied import

[h2] Pivot Request

2015-01-06 Thread Philbat
Hello, I have a table LINE(ID, NAME) AND a table TAG(ID, LINEID, TAG, VAL). Here is a example of content : - Table LINE ID|NAME | 1 |TEST1| 2 |TEST2| - Table TAG ID|LINEID|TAG|VAL| 1 |1 |A |ABC| 2 |1 |B |456| 3 |1 |E |789| 4 |2 |A |123| 5 |2 |B |147| 6 |2 |C |25

[h2] What is kept in PageStores and when is it released ?

2015-01-06 Thread Rinse Lemstra
We have put a new (H2-based) product live. Now the numbers of users are growing, the memory consumption also grows. JVisualVM learns us that the top 20 memory consuming objects are org.h2.store.PageStore#xx and org.h2.util.CacheLRU#xx Could someone explain what is kept in these objects ? when

Re: [h2] ALTER TABLE ADD uses too much memory

2015-01-06 Thread Noel Grandin
On 2015-01-06 12:50 PM, Steve McLeod wrote: When our users update to the latest version of our desktop software that uses H2, we need to add several columns to a table with many columns that may have millions of rows. Some people have been getting an OutOfMemoryException during this process.

[h2] ALTER TABLE ADD uses too much memory

2015-01-06 Thread Steve McLeod
When our users update to the latest version of our desktop software that uses H2, we need to add several columns to a table with many columns that may have millions of rows. Some people have been getting an OutOfMemoryException during this process. I've analysed this problem, and checked the H2