Hi Sergei, Now I'm in a project that make intensive use of linked tables and I can see many things that can be done to make more powerful the actual implementation.
El 29/01/10 16:15, Sergi Vladykin escribió: > I'm now investigating linked tables for my use case. And I thought > about such "pass-through" optimization too if query has no > dependencies on H2 db objects other than the linked table itself and > the table has no per-row triggers. I think the pass-through mode have very little to do to improve the current implementation. Now many uses of linked tables fail but many of them don't have with a valid / real cause. Because lack of implementation of some command or because H2 don't understand some syntax that is targeted to destination database. In such cases H2 simple need to know if it will get an ResultSet or scalar result or nothing , and just do plain jdbc execute( ) handling. If H2 instead of failing in advance when don't understand a sentence (in pass-t mode) just allow the other database handle the sentence for and act in regard of remote db exceptions or results, many things would work. In case some operation don't fill the conditions needed on H2 for handling such situation or results , at the end they will fail in the same way they fail now - so no loss. Think about minor sql grammar differences, DDL sentences , void stored procedures calls and how many thing can be working if h2 simple forward any sentence and fail upon remote failure. It may be promiscuous, but very useful. > May be I'll try to implement it a little later. > I have some time for programming but not enough to research the full context for that. You could give me some directions or starting points in order to be helpful. Let me know if I can help or collaborate with you in this matter. 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.
