Hi,
You can also use JDBC inside H2, using customer functions. Example:
create alias query as 'ResultSet query(Connection conn, String sql)
throws SQLException { return conn.createStatement().executeQuery(sql);
}';
call query('select * from dual');
drop alias query;
If needed, this can be extended to access external databases.
Regards,
Thomas
On Thu, Feb 4, 2010 at 4:27 PM, Dario Fassi <[email protected]> wrote:
> El 03/02/10 20:55, Ryan How escribió:
>> Do you mean like Access, where you can access heterogeneous data
>> sources like they are one database, but also have the ability to
>> "pass-through" to the originating data source?
>>
>> Ryan
>
> We don't use Access, but yes, that's the idea.
> In MS world you have some interesting artifacts to support data
> exchange, integration and ETL applications like DTSs , but it's very
> common that this type of apps use as intermediary and access db and VB.
>
> Because our main target are *nix+java server environments and
> heterogeneous db vendor + legacy , H2 fill this role very well as dbm
> and as ETL tool.
> An LINK DATABASE feature and LINKED_QUERY() functions it's all we need
> to remove some uncomfortable limitations of Linked tables.
>
> Dario.
>
> --
> 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.
>
>
--
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.
