Re: [h2] Null Compression Algorithm

Hi, I would have a look at the existing compression features, and read the source code. I guess this is homework, right? Regards, Thomas On Wednesday, November 18, 2015, krishna teja wrote: > Hi, I am trying to implement Simple Null compression algorithm in H2. Can > you give me Information r

Re: [h2] Thread remain after deleting database

Hi, The problem is the "shutdown". Without it, the thread will go away. Simply close the connection (all connections). Regards, Thomas On Thursday, November 19, 2015, wrote: > I want to know workaround. > > I measured the leak amount. > Each leaked thread uses 100~200KB. > > My system repeat

Re: [h2] Check for cancel statement into user defined function

Hi, One way would be to use Thread.interrupt, but I think that's rather ugly. Another idea is to use a ThreadLocal, not sure about that either... Regards, Thomas On Tuesday, November 17, 2015, Nicolas Fortin (OrbisGIS) < nico.de...@gmail.com> wrote: > Hi, > > We write some user defined h2 funct

[h2] Expression in linked table

Hi, What about (I didn't test): SET @WHERE_CODE='44109'; DROP TABLE IF EXISTS DATA_POSTGRES; CREATE FORCE LINKED TABLE DATA_POSTGRES ('org.orbisgis.postgis_jts_osgi.Driver', 'jdbc:postgresql_h2://', 'login', 'pass', 'db', '(SELECT * POSTGRES_TABLE WHERE CODE=' || @WHERE_CODE || ')'); Regard

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

Hi, Thanks a lot for the test case! Yes, I see there is a LOB remaining. I think I know the problem, but will need some more time to test this. Regards, Thomas On Thursday, November 19, 2015, ZHENCAI WANG wrote: > Hi Thomas, > Please look at the attached test case with 1.4.190. It will run 20

Re: [h2] Thread remain after deleting database

I want to know workaround. I measured the leak amount. Each leaked thread uses 100~200KB. My system repeat to create and delete database files. It may adversely affect my system. Is there any way to avoid this issue from current version? I tried to stop thread from outer. ( I know java doesn't r

[h2] Null Compression Algorithm

Hi, I am trying to implement Simple Null compression algorithm in H2. Can you give me Information regarding which files to edit and any other points? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receivi