Subject | Re: [Firebird-Java] Native OpenOffice database driver forFirebird (SDBC) |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-11-11T09:17:11Z |
KAMI,
you plan to implement it in Java. Right?
Does SDBC component becomes a part of the OpenOffice.org suite? If not, does
it need less configuration than JDBC? How is SDBC component installed?
I suspect that SDBC component in C++ would not require JRE to be installed.
But if the implementation language is Java, what's the difference?
absence of autoincrement field, absence of scrollable and updatable cursors,
etc.). Because of this, JayBird does not provide full JDBC implementation,
some parts are missing (like getting the auto-generated PK on INSERT,
updatable cursors). If additional features declared in SDBC are going to
provide access to the functionality that is not present in Firebird anyway,
I doubt that implementing SDBC component in Java brings any advantage
compared to JDBC.
When JayBird was started, we had already a JDBC driver called InterClient.
That was a type 3 JDBC driver that required a server-side component to be
installed on the same host with server. In addition to the configuration
burden, there were some other issues associated with it - multithreading
performance, etc. Creating a pure Java implementation of wire protocol
brought an advantage of having a lightweight type 4 JDBC driver that does
not have issues present in InterClient (though we have lost in some other
places, for example, "wire" protocol of InterClient was better optimized for
JDBC calls compared to native Firebird wire protocol - performance of
InterClient in some cases was better). Same happened with type 2 JDBC driver
(driver that accesses Firebird through JNI layer) - we gained ~30% when
connecting to a server running on the same machine via IPC and we have a
possibility to use an embedded Firebird.
Similarly, if you want to implement SDBC "driver" for Firebird, I would try
to answer first the question "What does it bring?". An answer "Because it
would be native OpenOffice.org component" is not good enough for me (though
I do not mind if it satisfies you :) ).
Roman
> Currently there are complete UNO language bindings for:Probably I was not precise enough... As I understand, you post it here since
> * C
> * C++ (compiler dependent, please see http://porting.openoffice.org
> for a list of supported platforms)
> * Java
> * Python
you plan to implement it in Java. Right?
> Built in support for database. You doesn't need external module.What's wrong with such wrapper layer?
> The SDBC Driver allows to use the database from OpenOffice.org
> without any wrapper layer such as odbc or jdbc.
Does SDBC component becomes a part of the OpenOffice.org suite? If not, does
it need less configuration than JDBC? How is SDBC component installed?
I suspect that SDBC component in C++ would not require JRE to be installed.
But if the implementation language is Java, what's the difference?
> I don't know anything about new features. But I don't have knowedgeLet me explain why I ask this. Firebird has some internal limitations (like
> about component modells. But from Frank Schönheit:
> "
> Additionally, SDBC (more precise: its extensions SDBCX and SDB) provide
> additional features which are not present in JDBC, or were not
> present at the time SDBC was invented.
> "
absence of autoincrement field, absence of scrollable and updatable cursors,
etc.). Because of this, JayBird does not provide full JDBC implementation,
some parts are missing (like getting the auto-generated PK on INSERT,
updatable cursors). If additional features declared in SDBC are going to
provide access to the functionality that is not present in Firebird anyway,
I doubt that implementing SDBC component in Java brings any advantage
compared to JDBC.
When JayBird was started, we had already a JDBC driver called InterClient.
That was a type 3 JDBC driver that required a server-side component to be
installed on the same host with server. In addition to the configuration
burden, there were some other issues associated with it - multithreading
performance, etc. Creating a pure Java implementation of wire protocol
brought an advantage of having a lightweight type 4 JDBC driver that does
not have issues present in InterClient (though we have lost in some other
places, for example, "wire" protocol of InterClient was better optimized for
JDBC calls compared to native Firebird wire protocol - performance of
InterClient in some cases was better). Same happened with type 2 JDBC driver
(driver that accesses Firebird through JNI layer) - we gained ~30% when
connecting to a server running on the same machine via IPC and we have a
possibility to use an embedded Firebird.
Similarly, if you want to implement SDBC "driver" for Firebird, I would try
to answer first the question "What does it bring?". An answer "Because it
would be native OpenOffice.org component" is not good enough for me (though
I do not mind if it satisfies you :) ).
> Please contact with Frank (Frank.Schoenheit*nospam*Sun.COM)If you're going to implement SDBC, you have to do this :)
> *nospam* means @
>
> or you may write to users@... (project's users
> mailing list)
Roman