Hi Thomas. I did not have the time to review the relevant code yet, but since you will add a feature request, I'm thinking that instead of giving specific treatment for every possible sql sentence, it might be more productive to add an option to linked tables creation such as "pass-through" or something like that. In pass-through mode, sql sentences that don't have a specific treatment for a linked table, are simply forwarded to linking jdbc connection as-is.
Other wish / alternative, can be add a generalization of linked tables as LINKED or FEDERATED CONNECTION , to use others jdbc sources integrated into database context, for send commands and cross using of result sets in both directions, but not constrained to a particular table or query: What do you think of these ideas , it's too crazy ? Do you think are feasible with reasonable effort? I'm convinced that H2's linked tables are a very useful feature, that every day I found in a new use case and has become an important reason for choosing this database. This feature effectively extends the power and scope of use of H2 to the tooling domain, but with many context and integration advantages over most ETL toolboxs. ETL, integration, data provisioning and exchange are some common areas that benefit greatly from this feature. Today we are using H2 even in many projects which are restricted to use another database as backend because of its speed, ubiquity and its value as a tool. thanks for your great work. Dario. El 24/01/10 13:30, Thomas Mueller escribió: > Hi, > > TRUNCATE is only supported for 'regular' tables. For linked tables, > you need to use DELETE FROM ... > > I will document that, and I will add a feature request. > > Regards, > Thomas > > > On Fri, Jan 22, 2010 at 7:47 PM, Dario Fassi <[email protected]> wrote:Hi, >> CREATE LINKED TABLE IF NOT EXISTS TLKT.EMPLOYEE('org.postgresql.Driver', >> 'jdbc:postgresql://127.0.0.1/hrla', 'postgres', '***','NOMINA.EMPLOYEE'); >> >> TRUNCATE TABLE TLKT.EMPLOYEE; >> commit; -- 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.
<<attachment: cleardot.gif>>
