Hello,
I've been following the advance of this project for more than one year
and now using it in some projects.
Let me tell you that I'm very impressed with H2's features and
performance.
I will be glad in colaborate with you in anything I can do.
I'm particularly interested in H2 LINKED tables feature for ETL and
replication purposes from other datasources;
and for cross DB simple copyTable procedures.
My questions/suggestions are:
(1) It's planned a "SELECT INTO new_table" or "CREATE TABLE as
( select_resultset )" or materialized views aka DB2 ?
(2) If I have many LINKED TABLES defined to the same database, with
the same driver and with the same user ,
same connection settings (isolation level, autocommit, etc.),
can I be sure that only one connection will be done for all this
linked tables ?
can I be sure that only one copy of JDBC driver will be loaded ?
Can this mono/multi connection behavior controlled in some way ?
(3) From (2) , When and How long will be connected the other
datasource ?
It's connected at startup or lazy until this linked table is used in
some query ?
Can this behavior be controlled in some way ?
Thanks in advance, and best regards,
Dario Fassi.
On 26 sep, 11:49, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> A new version of H2 is available for download athttp://www.h2database.com
> (you may have to click 'refresh').
>
> Changes and new functionality:
> -Linkedtables can now share the connection.
> -Linkedtables can now be read-only.
> -Linkedtables: the schema name can now be set.
> -Linkedtables: worked around a bug in Oracle with the CHAR data type.
> - Temporarylinkedtables are now supported.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
