For clarity this is my situation:
CREATE TABLE all_cap (
id_cap INT IDENTITY,
prov VARCHAR(45),
city VARCHAR(45),
cap VARCHAR(45)
);
CREATE TABLE municplaity (
id INT IDENTITY,
prov VARCHAR(45),
city VARCHAR(45),
cap VARCHAR(45)
)
all_cap has 85000 records
municiplaity has 16000 records
My query is:
"UPDATE municipality AS m
SET m.cap=(
SELECT c.cap
FROM all_cap AS c
WHERE
m.city=c.city
AND
m.prov=c.prov
LIMIT 1
); "
When i lunch this query after few minute H2 stop to works (although i
cancel the query) and then is impossibile to connect or query an H2
table.
I have to kill the javaw process of H2 Database Engine.
Thank again.
On 30 Mag, 20:51, blow <[email protected]> wrote:
> Hi all, sometimes with a greedy query H2 server stop to work.
> In this case H2 don't accept no other connections.
> Why this happen?
>
> Thanks.
>
> Blow
--
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.
