Hello!!
We have had problems with H2 Index. We discovered that it occurs in
two tables with composed primary key.
Different process are executing a lot of inserts and deletes in this
tables at same time. We try excludes the primary key and the index.bd
file stop to increase. We don´t know why, we just know that its
happens when the tables are access at same time to different actions
(Include by one process and delete by other). Maybe some problem with
the way we used the primary key. Does anybody have any idea about
this?
Thank you very much who could help us or share same problem!
PS - The table structures are below:
public final static String CREATE_PENDENCYFIELD_TABLE = //
"CREATE TABLE PendencyField (" + //
" Card INT8 NOT NULL," + //
" Field SMALLINT NOT NULL," + //
" Date TIMESTAMP NOT NULL," + //
" PRIMARY KEY (Card, Field)" + //
");";
public final static String CREATE_PENDENCYDEVICE_TABLE = //
"CREATE TABLE PendencyDevice (" + //
" Card INT8 NOT NULL," + //
" Device INTEGER NOT NULL," + //
" Date TIMESTAMP NOT NULL," + //
" PRIMARY KEY (Device, Card)" + //
");";
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
