Subject Re: [Firebird-Java] Database replication with Firebird
Author Philippe Makowski
Roman Rokytskyy [08-04-02 11.10] :
> As I understand, Myosotis is an emulation of the MySQL and PostgreSQL
> wire protocols. A limited one, since it has to perform the JDBC calls
> afterwards. What is accessible via JDBC can be accessed via wire
> protocol, what is not - can't. We could provide a limited Firebird wire
> protocol implementation which would then call the Sequoia JDBC driver.
> That is not that hard, requires some work.
>
It would be a nice first step

> However I suggest to dig deeper, e.g. extend the Sequoia JDBC API to
> expose all our custom JDBC extensions (current and future) and then have
> "complete" support for wire protocol.
>
> Much more complex, but, in my opinion, the only possible solution in our
> case. The second choice would be ODBC as more portable/complete solution
> for client application. And only after that comes extension of the
> Myosotis with Firebird protocol handler.
>
> And before that, I would definitely investigate how much work would be
> to implement ADO.NET and OLE DB APIs on top of Sequoia JDBC.
>
perhaps with the help of the Carob part of the puzzle ?
http://carob.continuent.org/HomePage