Re: [JDBC] Ant installation (and other) issues!

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

Seems like the debate has flared again.

- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Gunnar Rønning [EMAIL PROTECTED]
Cc: Peter Eisentraut [EMAIL PROTECTED]; Per-Olof Norén [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 1:22 AM
Subject: Re: [JDBC] Ant installation (and other) issues!


 Gunnar =?iso-8859-1?q?R=F8nning?= [EMAIL PROTECTED] writes:
  But anyway this off topic, what need to have is a build process that
works
  nicely and I think including the ant binaries(around 500k) would be the
  best solution here.

 500k of binaries?  You just lost the argument.  That's not an acceptable
 amount of overhead to add to the Postgres distribution.

I don´t see why the size of ant will be a problem. Could you please explain
to me?



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



[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.3jdbc built on jdk 1.3 on linux. Same error 
appears on win2000 (using the same driver)

Regards,
Per-Olof Norén
Stockholm, Sweden


[JDBC] Ant installation (and other) issues!

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



Hi all,
I have been listening to the discussions about Ant 
and the build system.
I think that the discussion is missing a point, 
which I will try to make here :-)

1. Standard
The Ant build system is making its way to be a "de 
facto" standard for building java applications as
it is built for the purpose.

2. Integration
In the apache cocoon project, the ant build system 
jar is shipped along with the distribution 
and
does not require a separate installation of Ant 
onthe target system. The Ant shell 
script is customized
so that the JAVA_HOME environment is the only 
parameter to set.
In the case of postgreSQL driver this could 
be done by invoking the "pgcustom" ant build from the gnu configure/make 

when configuring with the "--with-java" parameter. 

3. Platforms
I´m sure everyone agrees that providing a working 
java compiler should be out of scope for the 
build system.
Since the ant jar is shipped along, with its own 
build scripts (.bat and .sh) the build of the driver need not to 
differ
for the platform used.

4. Other things not particulary related to the 
build
The build script should, IMHO, NOT replace good 
implementation and structured design of the driver packages.


Alittle note on the server and the driver as 
a substitute for Oracle.
Everytime a get a chance, I spread the word of this 
wonderful database and people wonder "why not 
MySQL?" 
I tell them to look a the benchmarking test made by 
different users, to look at the SQL 9x compliance and
to realize the size of the devel community for 
pgsql and the jdbc driver. 
As the postgis project evolves with its spatially 
enabling extension to the driver, the 
driver´s compliance
to the API compared to commercial dmses will 
be IMHO one of the success factors for providing a rock solid
open source alternative. I Can´t help it, I Just 
love this Server AND Driver.

Thanx for listening :-)

Per-Olof Norén
Stockholm



Re: [JDBC] J2SE 1.4 and other patches

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


- Original Message -
From: Dave Cramer [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 17, 2001 1:29 PM
Subject: Re: [JDBC] J2SE 1.4 and other patches


 Ok, what specifically in jdbc 3.0 do people want implemented?

I personally would like the java.sql.Blob.getBinaryStream() to actually
return a Stream with content.
Right now I havn´t got the time to investigate further, but code working
against Oracle, returns -1 from the first read() from the stream when run
agains pgsql.
This is probably not the correct forum, but perhaps someone could forward
this problem to initiated source

Regards
Per-Olof Norén


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster