Re: full text search errors

This solution works good on my Win 7 PC, as well as my OSX 10.5 laptop On Aug 17, 2:22 pm, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, Caused by: org.apache.lucene.store.LockObtainFailedException: Lock obtain timed out: simplefsl...@c:\Users\Clinton Hyde\mag-db\write.lock It

Re: Error creating view

Hi, This bug will be fixed 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 to

Re: H2 embedded Java suggestion

Hi, I think it's somewhat unlogical (at least inconsistent) that a module doesn't have a name when you create it, but has a name when you drop it. I would prefer it having a name in both cases. The name doesn't need to match the class name. You have used an unnamed package. Does this mean the

Re: LOCK_MODE

Hi, My question is this: If I connect with url jdbc:h2:test;LOCK_MODE=0 does it also affect other connections (and transactions) or only the one connection that set the mode in it's url? This is documented: This setting affects all connections. Regards, Thomas -- You received this

Re: [bug report] MULTI_THREADED=1 and rowCount exception

Hi, with LOCK_MODE set to READ_UNCOMMITTED. N threads This is not supported. See http://h2database.com/html/grammar.html#set_lock_mode : The value 0 means no locking (should only be used for testing; also known as READ_UNCOMMITTED). Please note that using SET LOCK_MODE 0 while at the same time

Re: Hibernate Search / Slow OR Operations

Hi, where (key1 = ? and key2 = ?) OR (key1 = ? and key2 = ?) H2 currently doesn't use an index for such queries. I will add a feature request, however I'm not sure when I have time to implement an optimization for it. Regards, Thomas -- You received this message because you are subscribed to

Re: LOCK_MODE

But in JDBC api Connection interface has method void setTransactionIsolation(int level) So it is clearly against the JDBC api if this setting affects all the other connections also. - Rami Ojares Thomas Mueller wrote: Hi, My question is this: If I connect with url jdbc:h2:test;LOCK_MODE=0

Re: H2 embedded Java suggestion

Hi Thomas, On Thu, Aug 19, 2010 at 5:35 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I think it's somewhat unlogical (at least inconsistent) that a module doesn't have a name when you create it, but has a name when you drop it. I would prefer it having a name in both cases.

Re: H2 embedded Java suggestion

I've thought about this a bit more, and wanted to advocate for including the module name in the CREATE MODULE command, and for ignoring the actual class name that will exist in the code. Therefore commands like CREATE TRIGGER will be referring to MODULE names, not classnames. This is primarily so

Dropping anonymous indexes?

Hello all, Is there a way to drop indexes that were created without a given name? I have a test table with indexes named 'Index_4C etc etc, and I can't drop them. Those indexes using create index on TABLE(COLUMN) and unnamed. Thanks. Duncan. -- You received this message because you are

Question about h2 test case

Hi, We have had database corruption problem and I try to use org.h2.test.TestAll API to validate our system. We use 1.2.128 version now and plan to migrate upper version. I built 1.2.135 version with ant and copied output files to our system and typed command below. java -cp .

Re: H2 embedded Java suggestion

OMG! Are you seriously planning to support some other languages? I mean ... wtf?!? Seriously, you guys are arguing about syntax sugaring. And it is no shame to place the name in a natural place from sql point of view. What you are dong is mixing two languages so it is clear that there can arise

Re: H2 embedded Java suggestion

Hi rami, On Thu, Aug 19, 2010 at 12:47 PM, Rami Ojares rami.oja...@gmail.com wrote: OMG! Are you seriously planning to support some other languages? No, but it might be nice one day :-) Seriously, you guys are arguing about syntax sugaring. Yes, but doesn't that matter? What I am

Re: Dropping anonymous indexes?

What happens when you try to drop them? Do you get an error message? This works ok for me: create table blah(id int, name varchar); create index on blah(name); select INDEX_NAME from INFORMATION_SCHEMA.indexes where table_name = 'BLAH' drop index INDEX_1 -- (where INDEX_1 is the value returned

Insert Performance In Embedded application

I am using H2 as an embedded database in a Java 1.6 application. The Database is in-memory. I create a single table using 'CREATE MEMORY TABLE TestTable'. I have an index on what we call our ID field and put this at the end of the table creation sql: 'PRIMARY KEY (id)' The purpose of the

Re: Insert Performance In Embedded application

Hi, 1) try HashSet instead of List for id storing (for faster lookups); 2) try to use MERGE command instead of seeking ids in your collection (instead of previous suggestion) 3) try PRIMARY KEY HASH (it also uses HashMap for lookups); 4) try to add heap memory as much as possible (to decrease GC