Re: [JDBC] Compliance? Plans?

2001-10-24 Thread Barry Lind

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



[JDBC] Compliance? Plans?

2001-10-23 Thread Per-Olof Norén




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