Re: [h2] Re: Where the heck is my database????

Hi, Worth a try, I'll check it out! Thanks! Alejandro On Fri, Feb 28, 2014 at 8:20 AM, Thotheolh wrote: > I have created a tool called 'localdb' specifically for handling such a > case a few years back (and should still be compatible with current H2 > versions since no protocol changes were m

Re: [h2] Where the heck is my database????

Hello Thomas, Yeah, I realised about that afterwards...that approach is not feasible since I'm embedding h2 in a OSGi bundle (not using H2 as an OSGi bundle, but embedding it in a bundle, since I don't need other bundles to be wary of the H2 service). Thus, I'm just storing the db in the home fold

[h2] Re: Where the heck is my database????

I have created a tool called 'localdb' specifically for handling such a case a few years back (and should still be compatible with current H2 versions since no protocol changes were made for the filesystem jdbc access). Link: https://code.google.com/p/localdb The wiki page contains the how-to

[h2] Re: H2 in-memory performance issue(slower than postgres).

On Wednesday, February 26, 2014 6:36:08 PM UTC+5:30, padmalochan pramanik wrote: > > Hi All, > > I am using : > > //H2 version: > Version 1.3.174 > //URL: > ("jdbc:h2:mem:test123;OPTIMIZE_REUSE_RESULTS=0", "test", "password") > //Test Machine : > OS - Ubuntu , RAM - 4GB , Max Heap Size - 2048 m

[h2] Re: .net jdbc issue

> > By the way my H2 version is 1.3.175 > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send e

[h2] Re: .net jdbc issue

Where can I get an updated one ? I checked from here and 1.1.0.0 is the latest src : https://code.google.com/p/h2sharp/downloads/list my H2Sharp dll is indeed 1.1.0.0 version. Please advise -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To un

Re: [h2] Re: Iterative GRANTs ignored

Thanks, Thomas. Appreciate you proposing a fix, too! It will help in the interim :) W dniu czwartek, 27 lutego 2014 21:30:31 UTC użytkownik Thomas Mueller napisał: > > Hi, > > Yes, this looks like a bug. Thanks a lot for reporting it! It looks like > additions to existing rights are not persist

Re: [h2] Re: Iterative GRANTs ignored

Hi, Yes, this looks like a bug. Thanks a lot for reporting it! It looks like additions to existing rights are not persisted. I have a potential patch, but I will first need to write a complete unit test: --- src/main/org/h2/command/ddl/GrantRevoke.java (revision 5422) +++ src/main/org/h2/command/

[h2] Re: Iterative GRANTs ignored

Any ideas why such behaviour? Seems like a basic functionality is flawed but happy to be proven wrong. Thanks for any inputs! W dniu środa, 26 lutego 2014 17:30:57 UTC użytkownik Konrad Palczewski napisał: > > Hi H2 Group, > > This is a very strange one but my investigation proves this may be a

[h2] .net jdbc issue

Hi, If you get a file named "test.data.db", then you are using a _very_ old version of H2 (version 1.1.x., from 2009 I believe). Regards, Thomas On Thu, Feb 27, 2014 at 10:01 AM, Chen Wei loong > wrote: > From H2 database file layout, the db filename is xxx.h2.db > > I have tried H2Sharp and

[h2] H2 in-memory performance issue(slower than postgres).

Hi, Yes, I would need a complete test case, if possible in the form of a script, similar to this: create table test(id int primary key, name varchar(255)); insert into test select x, 'hello ' || x from system_range(1, 10); select id, count(*) from test group by id; Regards, Thomas On Wednes

[h2] .net jdbc issue

Hi, If you get a file named "test.data.db", then you are using a _very_ old version of H2 (version 1.1.x., from 2009 I believe). Regards, Thomas On Thu, Feb 27, 2014 at 9:24 AM, Chen Wei loong > wrote: > Given that JDBC URL access from H2 terminal jdbc:h2:C:\test , the output > physical file

[h2] duplicate DB files created at root drive

Hi, im new on H2, im using java and hiberate as ORM. Every is working fine, but the problem i have is that when a i run the app a duplicate of the DB is created at the root drive directory. Example, if i run the app in F:\test, and the DB file exists in the same dir the app runs well but a copy

[h2] how do i stop in-memory h2 instance (in junit)

Hi, I am using h2 in-memory for junit (4.x) tests. Basically, i'm expecting the following pattern: 1- have a jdbc connect url like: "jdbc:h2:mem" 2- @Before: get jdbc connection, then create schema / tables / indexes / ... insert rows 3- run the test 1- @After: close jdbc connection I noticed

[h2] .net jdbc issue

>From H2 database file layout, the db filename is xxx.h2.db I have tried H2Sharp and Java IKVM, both produce a db filename follow this rule xxx.data.db This make .net project not able to connect to xxx.h2.db, any workaround ? Please advise and thanks. -- You received this message because yo

[h2] .net jdbc issue

Given that JDBC URL access from H2 terminal jdbc:h2:C:\test , the output physical file is test.h2.db But the same URL access from .net, the output file is test.data.db This causes my .net connector cannot connect to the db i create in h2 terminal, any advise ? Thanks. -- You received this me