"Wrong database fle version" when creating new file

2009-12-15 Thread marcus.wolschon
When I open a not-yet-existing database in an existing directory jdbc:h2:file:d:\osm\streets;shutdown=true I keep getting a "Wrong database fle version". any ideas as to the possible reason? I know my code worked before. Marcus -- You received this message because you are subscribed to the

java.io.IOException: Insufficient system resources exist to complete the requested service during connection

2009-12-15 Thread oxj
I'm running H2 (v1.1.118 and I tried v1.2.125) as an embedded database in a Java application and the current size is about 24GB. I've installed our application onto 10 HP laptops and 6 of the 10 get the following error during establishing a JDBC connection to this database: org.h2.jdbc.JdbcSQLExce

Documentation Tools

2009-12-15 Thread Todd Stout
Thomas, I love the H2 documentation. What tools do you use? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr..

Re: Question concerning record positions

2009-12-15 Thread Ryan How
Do you mean like a clustered index? Is that what it is called?. Like in MS SQL doesn't it return result sets in the order specified by the clustered index? Ryan Serg wrote: > I've noticed that H2 manipulates positions of records after executing > UPDATE and INSERToperations. > > In other words

Query optimizer patch

2009-12-15 Thread Jan Kotek
Hi all, I found one case where H2 query optimizer does not work. I created patch which solve it My application is using this type of query: create table star ( starId int primary key AUTO_INCREMENT, ipix long ); create index star_ipix on star(ipix); //insert 100 000 records /

Re: Question on LZF block identifiers

2009-12-15 Thread Tatu Saloranta
On Tue, Dec 15, 2009 at 7:46 AM, Sam Van Oort wrote: > On Dec 10, 6:26 pm, Tatu Saloranta wrote: ... >> Also: using chunk identifiers like command-line tools has one nice >> benefit; that is, you can just sequence blocks without restrictions as >> there is no initial header (which can be downside

Re: Question on LZF block identifiers

2009-12-15 Thread Thomas Mueller
Hi, >> I think it'd be nice to be compatible, especially if a separate >> library was carved out. > I'm talking with Mr. Mueller about this, but it could take some time > to work out.  We'll see where it goes? I have no problem if you create a special project for the LZF tool. Apache license if f

Re: no data found

2009-12-15 Thread Thomas Mueller
Hi, This is a bug in version 1.2.x. I will fix in in the next release. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email

Re: ChangeFileEncryption Error while renaming

2009-12-15 Thread Thomas Mueller
Hi, Please don't post the same message twice. > java -cp h2*.jar org.h2.tools.ChangeFileEncryption -cipher "XTEA" -dir "~" > -db "test" Are you sure? If I run that, I get the following exception: "Encryption or decryption password not set, or cipher not set" Do you already know about the "Error

Re: Encryption error

2009-12-15 Thread Thomas Mueller
Hi, > java -cp h2*.jar org.h2.tools.ChangeFileEncryption -cipher "XTEA" -dir "~" > -db "test" Are you sure? If I run that, I get the following exception: "Encryption or decryption password not set, or cipher not set" Do you already know about the "Error Analyzer"? The link is on the H2 main page

Re: H2 performance in sun solaris

2009-12-15 Thread Sam Van Oort
Some just have to pay homage more than others; the windows filesystems are *dreadfully* slow at times, especially NTFS. Y'know, I don't think anyone has done a comparison of H2 performance b/ w the different filesystems. I also wouldn't be surprised to find that the right filesystem block size mak

Re: Question on LZF block identifiers

2009-12-15 Thread Sam Van Oort
On Dec 10, 6:26 pm, Tatu Saloranta wrote: > On Thu, Dec 10, 2009 at 1:34 PM, Sam Van Oort wrote: > > > Hi, > > I can add this to a list of extensions to theLZFcode.  It's not a > > bad idea to have a version which is fully binary compatible, which can > > be used as a compatibility option in the

Re: database 900 MB slow to open, is it normal?

2009-12-15 Thread Sylvain Pointeau
yes it is a new database it is called .h2.db and I am sure to use the latest one... don't know what happens. Is there something I could test? On Mon, Dec 14, 2009 at 8:52 PM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > > now I am sure I am using the latest version, and it

Re: Question concerning record positions

2009-12-15 Thread Sergi Vladykin
There is no such ability because in cases when you need to get a query result in some specific order the right solution is to use ORDER BY clause. You are looking for a some kind of hack instead. AFAIK most of databases (if not all) do not guarantee the order of records too. -- You received this

Question concerning record positions

2009-12-15 Thread Serg
I've noticed that H2 manipulates positions of records after executing UPDATE and INSERToperations. In other words after executing the script CREATE TABLE INVOICE(ID INT PRIMARY KEY, AMOUNT DECIMAL); INSERT INTO INVOICE VALUES(1, 10.0); INSERT INTO INVOICE VALUES(2, 19.95); INSERT INTO INVOICE VAL