Hi all,
I have this table definition:
CREATE TABLE IF NOT EXISTS VERSION_NUM (
LOCK char(1) DEFAULT 'X' not null PRIMARY KEY,
VERSION BIGINT,
LOADED_FLAG boolean,
constraint CK_T1_Locked CHECK (
We have a table containing approx. 500k entries. Each time our server is
restarted we need to reset all the records, to do so we use a query like:
UPDATE VARIABLE_NODE SET NODE_VALUE = DEFAULT_VALUE,
SUPPRESSION_STATE=FALSE,
SUPPRESSION_RELEASE_TIME=0,
This morning I tried to open my test database to make some tests there and
I couldn't open it anymore; even tried the recover tool. When I try to open
it using the h2 console I am getting this exception:
Unique index or primary key violation: "PRIMARY KEY ON .PAGE_INDEX";
SQL statement:
ALT
In jdbc/mysql there is the option to include the flag *useAffectedRows=true
*in the connection url to force update statements returning the number of
actually rows changed, not the rows that matched the update criteria. Is
there such a similar thing for h2?
*Thanks,Dani.*
--
You received th
It would super useful if one could just drag and drop an .h2 file onto the
browser with the h2 console application opened and the path would be set
there automatically.
Just an idea.
Dani.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsub