El 31/01/10 09:34, Sergi Vladykin escribió: > I have some data integration tasks too, and I agree that creating > linked table for any simple thing is not very convenient especially > when parametrized queries needed.
Yes it's, and many sources need setup after connection and before can be used properly. Not all databases support that setup via connection URL. Ex. SET ISOLATION LEVEL , COLLATING , CLIENT ENCODING, etc. > Direct access to external data sources would be much better. This way don't have restrictions to do anything you can do via direct jdbc but inside H2. DBLINK as a datasource bookmark on H2 that can be activated or de-activated as needed or on access sound very promising. > Also I think linked tables should be done over dblink to have ability to > change parameters only for dblink > but not to all linked tables if something changed. This is a plus , I had not thought of that. > H2 can become mega-cool data integration solution then:) > DBLINK could implement a getConnection() method to open the door to use many wonderful H2's tools over external data too ( Csv , RunScript ). -- 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.
