El 03/02/10 15:41, Thomas Mueller escribió: >> DBLINK could implement a getConnection() method >> > This sounds like DriverManager. You can register you own custom JDBC driver > that returns the 'right' connection. >
Of course you can in java , but not in middle of an sql script. I just thinking in the possibility of using Csv, and other H2 tools over an external connection. >> Not all databases support that setup via connection URL. >> Ex. SET ISOLATION LEVEL , COLLATING , CLIENT ENCODING, etc. >> > So far nobody requested such features. Could you provide more details > about what you need? > By example, a concrete real case I have to query data from a legacy database in ISOLATION LEVEL UNCOMMITED READ , to create a H2 table using a query that mix data from that linked table and other H2's tables. That database don't accept setup isolation level via jdbc URL, so I can use linked tables for this case. Other case, I need/wish define a linked table with a query that use a sql grammar that H2 don't accept. >> Direct access to external data sources would be much better. >> > Do you mean by setting a connection _object_ versus declarative > (database URL and so on like now)? > > No I mean to get an ResultSet from an external source in such a way that H2 don't parse the sql destinated to linked database, just use the returning ResultSet. >> change parameters only for dblink >> but not to all linked tables if something changed. >> > I will add a feature request for "Support CREATE DATABASE LINK". Regards, 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.
