I have a doubt on how to define the fetch_size from the create linked table 
signature. What do you think about adding an option like this 

CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:./test2',
    'sa', 'sa', 'TEST', parameters);

where parameters is  a string that contains the connection parameters as

CREATE LINKED TABLE LINK('org.h2.Driver', 'jdbc:h2:./test2',
    'sa', 'sa', 'TEST', 'FETCH_SIZE=1000; AUTO_COMMIT=FALSE');

Best regards

Erwan

Le mercredi 30 décembre 2020 à 19:30:37 UTC+1, Noel Grandin a écrit :

>
> Sounds possible and reasonable to me.
>

-- 
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/e0f36cc8-9c76-4231-b82d-51ebde1141d8n%40googlegroups.com.

Reply via email to