Ah, I see the problem.
Instead of doing
INSERT INTO ... VALUES (SELECT ...)
do
INSERT INTO ... SELECT ...
At the moment your VALUES clause is generating a single-column,
single-row result which is itself a "table" :-)
You research sounds very cool, it would be nice to have some of those
pieces incorporated into the main distribution.
In particular, our clustering could do with some love, so your asynch
replication looks very interesting.
The resource usage and latency monitoring also looks lke it could be
useful to others.
But only if you want to, of course.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.