Per-Olof, Thanks for the constructive feedback.
Let me try to answer your questions: > 1. How is the driver compliance tests carried out? The test harness from > sun? The sun test harness has been run. However the sun test harness is only for jdbc2 + the enterprise extensions. As far as I know there isn't a test suite for plane jdbc2. Little if any work has been done to support the enterprise extensions to jdbc2, however a quite a bit of work has gone into the vanilla jdbc2 stuff. There is a list of non-compiance issues at http://lab.applinet.nl/postgresql-jdbc > > 2. How often is compliance tests carried out? Not that frequently since we know what the existing issues are and are working to address them as contributors contribute fixes. > > 3. Is there a policy for those issues where postgres has limited backend > support for the jdbc API functions? > If the server is lacking a feature, this would get added to the general todo list for the server. And when that feature is implemented in the server, then it could be added to the jdbc client. > 4. Is there a development plan for the jdbc package, similar to that of > the server itself? > Both the server and the jdbc driver have todo lists. These are as much of a development plan as exists. Anyone who wants to contribute can sign up to do a todo item. Things get done as volunteers work on todo items. > > > lastly, while I´m at it :-) > > Is there a known problem with the implementation of > java.sql.Blob.getBinaryStream() implmentation? > > I get the size of the blob with length() and its correct > > While reading the Stream I get returncode -1 immediatly > > server is 7.1.3 jdbc built on jdk 1.3 on linux. Same error appears on > win2000 (using the same driver) I don't know of any bugs in this code. Do you have a test case you could submit for someone on the list to look at? thanks, --Barry Per-Olof Norén wrote: > Hi again all, > > > > First off, I´d like to declare that my intention is not to be a pain in > the B** :-) > > > > Working on customer´s campuses equipped with laptop and a viennaSQL (a > pure java sql client) i have had > > the need for many different drivers for different dbmses. The effort > involved getting a working jdbc driver > > for the dbms at hand has varied; from extremely easy to almost impossible. > > As I´m currently promoting postgreSQL as an Orcacle alternative, I have > been working in parallell with both > > drivers and the driver´s compliance to the api differs, which has really > been a hazzle. > > > > My questions to the people actively developing the driver is: > > > > 1. How is the driver compliance tests carried out? The test harness from > sun? > > 2. How often is compliance tests carried out? > > 3. Is there a policy for those issues where postgres has limited backend > support for the jdbc API functions? > > 4. Is there a development plan for the jdbc package, similar to that of > the server itself? > > > > lastly, while I´m at it :-) > > Is there a known problem with the implementation of > java.sql.Blob.getBinaryStream() implmentation? > > I get the size of the blob with length() and its correct > > While reading the Stream I get returncode -1 immediatly > > server is 7.1.3 jdbc built on jdk 1.3 on linux. Same error appears on > win2000 (using the same driver) > > > > Regards, > > Per-Olof Norén > > Stockholm, Sweden > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
