Hi,
auto-commit was just for demonstration purpose.
So you think about adding a term in the parser to write
CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:./test2', 'sa', 'sa',
'TEST') FETCH_SIZE 1000;
CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:./test2', 'sa', 'sa',
'TEST') EMIT UPDATES FETCH_SIZE 1000;
CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:./test2', 'sa', 'sa',
'TEST') READONLY FETCH_SIZE 1000;
Best regards
Erwan
Le jeudi 31 décembre 2020 à 16:20:32 UTC+1, Evgenij Ryazanov a écrit :
> On Thursday, 31 December 2020 at 22:55:44 UTC+8 bocher wrote:
>
>> It would be better to specify the new additional parameters of Connection
>> and Statement outside of these parentheses.
>>
>> Do you have an idea in mind ? I'd like to set the parameters from the
>> SQL engine.
>>
> I think you can add some optional clauses at the end of this command,
> something like FETCH SIZE something.
>
> I also don't understand why do you want to play with auto-commit in them.
> Linked tables in H2 didn't belong to H2's own sessions / transactions. They
> reside on the database level. H2 handles possible rollback in them by
> itself in its own sessions. Without auto-commit in the driver of the table
> you'll just break updatable linked tables, H2 needs to commit changes to
> them immediately. If you want to change it, most likely you will need to
> reimplement linked tables in H2, it's a large complicated work.
>
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/80bb852e-20be-4786-970d-e2f86ff1acdan%40googlegroups.com.
