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
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
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
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
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
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
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
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.
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
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
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 .
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
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
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
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
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
16 matches
Mail list logo