Re: [JDBC] JDBC SQLCodes or Error Numbers - Or how to handle errors

2001-10-28 Thread Henry D.
n DB2 to know that the row I'm trying to insert already exists. > > > >Is there an easy way to do this using Postgresql and JDBC? > > I'm afraid not. > > "SQLException.getErrorCode() always returns 0. The PostgreSQL > backend currently doesn't provide error

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
:34 AM To: Dave Cramer Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] DatabaseMetaData.getTables() On Sun, Oct 28, 2001 at 07:14:42AM -0500, Dave Cramer wrote: > It appears the getBytes was previously being used to return a byte > array of any arbitrary column. > > Fixes for blobs seem to

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Jason Davies
On Sun, Oct 28, 2001 at 07:14:42AM -0500, Dave Cramer wrote: > It appears the getBytes was previously being used to return a byte array > of any arbitrary column. > > Fixes for blobs seem to have broken this. The question is as Jason > pointed out which do we fix. > > It doesn't seem unreasonabl

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Jason Davies
I forgot to mention I'm using the current CVS. On Sun, Oct 28, 2001 at 10:07:06AM +0100, Rene Pijlman wrote: > On Sat, 27 Oct 2001 19:25:49 -0500, you wrote: > >There seems to be a problem with DatabaseMetaData.getTables() > [...] > >It throws a NullPointerException: > > This may have been fixed

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
other hand is this the intended use? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jason Davies Sent: October 27, 2001 8:26 PM To: [EMAIL PROTECTED] Subject: [JDBC] DatabaseMetaData.getTables() Hi, There seems to be a problem

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Dave Cramer
: October 27, 2001 8:26 PM To: [EMAIL PROTECTED] Subject: [JDBC] DatabaseMetaData.getTables() Hi, There seems to be a problem with DatabaseMetaData.getTables() when I do the following: ResultSet R=conn.getMetaData().getTables(null, null, "%", null); It throws a NullPointe

Re: [JDBC] JDBC SQLCodes or Error Numbers - Or how to handle errors

2001-10-28 Thread Rene Pijlman
On Sun, 28 Oct 2001 00:33:07 -0700, you wrote: >I'm used to just doing the insert and catching the SQLCODE -803 >on DB2 to know that the row I'm trying to insert already exists. > >Is there an easy way to do this using Postgresql and JDBC? I'm afraid not. "SQ

Re: [JDBC] DatabaseMetaData.getTables()

2001-10-28 Thread Rene Pijlman
On Sat, 27 Oct 2001 19:25:49 -0500, you wrote: >There seems to be a problem with DatabaseMetaData.getTables() [...] >It throws a NullPointerException: This may have been fixed by now: http://fts.postgresql.org/db/mw/msg.html?mid=1021572 Regards, René Pijlman <[EMAIL PROTECTED]>

[JDBC] JDBC SQLCodes or Error Numbers - Or how to handle errors

2001-10-28 Thread User One
I'm new to postgresql and it's JDBC driver, although an old hand a relation databases. I'm trying to rely on past practices in developing some code using Java and postgresql. I'm trying to do a INSERT into a table with the full knowledge that I might be trying to insert a

[JDBC] DatabaseMetaData.getTables()

2001-10-27 Thread Jason Davies
Hi, There seems to be a problem with DatabaseMetaData.getTables() when I do the following: ResultSet R=conn.getMetaData().getTables(null, null, "%", null); It throws a NullPointerException: java.lang.NullPointerException at org.postgresql.jdbc2.DatabaseMetaData.getTables(DatabaseMetaDa

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

2001-10-27 Thread Barry Lind
Because many developers of postgres work over dialup modems at speeds of 32k. 500KB over a 32Kb line is a problem. Especially if you aren't even planning on using jdbc, you still pay the price when doing a CVS checkout. --Barry Rene Pijlman wrote: > On Mon, 22 Oct 2001 19:22:

Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected

2001-10-27 Thread Robert Dyas
ubject: Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected Robert, What version of the driver and database are you using? I have code that gets the update count back from executeUpdate(). So I suspect this may be fixed in a more recent version. thanks, --Barry Robert

Re: [JDBC] PostgreSQL, JDBC, and Druid

2001-10-27 Thread Rene Pijlman
On Fri, 26 Oct 2001 10:30:25 -0700, you wrote: >I use Druid to design my PG database. >I never got the jdbc driver to work. >Any idea of what's going on? It seems that the PostgreSQL JDBC driver doesn't work with various applications (Druid, StarOffice, DbVisualizer,...) beca

Re: [JDBC] alternative driver jxDBCon

2001-10-27 Thread Rene Pijlman
On Wed, 24 Oct 2001 12:58:55 +0200, you wrote: >has anyone made some experience using the jdbc driver jxDBCon for PostgreSQL? >it is an alternative to the driver released by PostgreSQL. >(http://jxdbcon.sourceforge.net) Its been mentioned a couple of times on this list, but I haven&#

Re: [JDBC] Error: ClassNotFoundException

2001-10-27 Thread Rene Pijlman
On Fri, 26 Oct 2001 21:34:37 -0600, you wrote: >I have successfully installed >PostgreSQL on my Mac G4 running Mac OS X 10.1. I have no experience with this platform, but... >"Class.forName("org.postgresql.Driver");" returns the error >"java.lang.ClassNotFoundException: org.postgresql.Driver

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

2001-10-27 Thread Rene Pijlman
On Mon, 22 Oct 2001 19:22:19 -0400, Tom Lane wrote: >500k of binaries? You just lost the argument. That's not an acceptable >amount of overhead to add to the Postgres distribution. Why? 500K can easily fit on a floppy, and that's technology from the 1980's. Regards, René Pijlman <[EMAIL PROTEC

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-27 Thread Gunnar Rønning
* Ned Wolpert <[EMAIL PROTECTED]> wrote: | Humm... are you saying that the class PostgresqlDataSource doesn't work? I | guess I'm not sure what doesn't work with the driver. (Course, I've been using | PoolMan as the datasource to wrap the postgresql default connection rather than | using the da

Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Justin Clift
grams (for example the ERD tool "DbDesigner", etc) to work correctly with PostgreSQL. Given that these are the methods I'm thinking about, I hope this patch is completed properly and accepted into the JDBC driver asap, even though we are in beta. We have plenty of time to ensure th

[JDBC] Error: ClassNotFoundException

2001-10-26 Thread Craig Lawton
Hello All, I'm a fairly experienced developer, however, a complete newbie when it comes to using PostgreSQL and JDBC. I have successfully installed PostgreSQL on my Mac G4 running Mac OS X 10.1. I'm able to start the DB daemon (with -i extension), I've created and populated

Re: [JDBC] JDBC executeUpdate() does not return the number of rows effected

2001-10-26 Thread Barry Lind
Robert, What version of the driver and database are you using? I have code that gets the update count back from executeUpdate(). So I suspect this may be fixed in a more recent version. thanks, --Barry Robert Dyas wrote: > Hi all, > > I have been using the JDBC driver for a

[JDBC] JDBC executeUpdate() does not return the number of rows effected

2001-10-26 Thread Robert Dyas
Hi all, I have been using the JDBC driver for a couple of months now. The only limitation I have run into for my own uses is that calling executeUpdate() does not return the number of rows effected by update or delete statement -- it always returns 0. Is this a limitation of Postgresql (i.e

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Barry Lind
wrote: > >>Ned, >> >>It may or may not work. That file hasn't been changed in a long time, >>so I doubt anyone is using it and therefore it may no longer work. >> >>I don't want to give people the false impression that the javax.sql set >>

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26-Oct-2001 Barry Lind wrote: > This is a community of volunteers. So if someone wants to work on JDBC3 > that is fine. We don't have the option of telling people how they > should spend their time. My bad. I didn't mean to alienate. Sorry i

Re: [JDBC] JDBC driver implementation

2001-10-26 Thread Barry Lind
The jdbc driver does not support updateable result sets. If you want to update the data you need to do it the old fashioned way (i.e. use update SQL statements). thanks, --Barry Robinson wrote: > Hello, > > I have a situation where I just want the changes to be made temporarily

[JDBC] JDBC driver implementation

2001-10-26 Thread Robinson
Hello, I have a situation where I just want the changes to be made temporarily in the ResultSet.   I don't want to commit the changes to the database.   When I use the ResultSet.updateString(...), ResultSet.updateBoolean(...), or ResultSet.updateObject(...) methods;  I get the message "This method

Re: [JDBC] PostgreSQL, JDBC, and Druid

2001-10-26 Thread Dave Cramer
It is a problem with some of the metadata calls, I am looking into it -Original Message- From: Dado Feigenblatt [mailto:[EMAIL PROTECTED]] Sent: October 26, 2001 1:30 PM To: [EMAIL PROTECTED]; pgsql-jdbc; [EMAIL PROTECTED] Subject: PostgreSQL, JDBC, and Druid Hi Rene. Hi Dave. (No

Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Jason Davies
OTECTED] > > > > > > > > > > Index: jdbc1/DatabaseMetaData.java > > === > > RCS file: >/projects/cvsroot/pgsql/src/interfaces/jdbc/org/postgresq

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
; so I doubt anyone is using it and therefore it may no longer work. > > I don't want to give people the false impression that the javax.sql set > of extensions to JDBC2 is supported by the jdbc driver by providing a > jdbc7.2-1.2ee.jar file when we only implement 1 interface o

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Barry Lind
Ned, It may or may not work. That file hasn't been changed in a long time, so I doubt anyone is using it and therefore it may no longer work. I don't want to give people the false impression that the javax.sql set of extensions to JDBC2 is supported by the jdbc driver by providing

Re: [JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Barry Lind
Please check that it works :) > > Thanks, > Jason Davies > > [EMAIL PROTECTED] > > > > > Index: jdbc1/DatabaseMetaData.java > =

[JDBC] PostgreSQL, JDBC, and Druid

2001-10-26 Thread Dado Feigenblatt
Hi Rene. Hi Dave. (No, you don't know me :) I use Druid to design my PG database. I never got the jdbc driver to work. Have you? I'm using this URL jdbc:postgresql://:/ then I get this message Trying to connect... Raised SQL Exception: Message: postgresql.stat.ma

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-26 Thread Ned Wolpert
> --Barry > > > > Ned Wolpert wrote: > >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Folks- >> >> I checked out the jdbc driver for 7.2b1 on the jdbc.postgresql.org website >> (http://jdbc.postgresql.org/download/jdb

[JDBC] versions/changelogs

2001-10-26 Thread Glenn Holmer
I'm about to upgrade to the new release of SuSE, which will take me from 7.0 to 7.1 of Postgres. Which is the best JDBC driver to use, and where is the best place to look for a list of what changed between 7.0 and 7.1? --

[JDBC] DatabaseMetaData.getImported/ExportedKeys() patch

2001-10-26 Thread Jason Davies
/cvsroot/pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/DatabaseMetaData.java,v retrieving revision 1.35 diff -c -r1.35 DatabaseMetaData.java *** jdbc1/DatabaseMetaData.java 2001/10/25 05:59:59 1.35 --- jdbc1/DatabaseMetaData.java 2001/10/26 01:21:02 *** *** 2260,2345

Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-25 Thread Barry Lind
n the web site. The only difference is some code that I consider questionable, and I don't think even works. thanks, --Barry Ned Wolpert wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Folks- > > I checked out the jdbc driver for 7.2b1 on the jd

[JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?

2001-10-25 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Folks- I checked out the jdbc driver for 7.2b1 on the jdbc.postgresql.org website (http://jdbc.postgresql.org/download/jdbc7.2b1-1.2.jar) and I was going to submit it for testing with the castor project. One problem... it's only the de

Re: [JDBC] "No Suitable Driver"

2001-10-25 Thread Dave Cramer
Guy, Send me the pertinent code where you are loading the driver Dave -Original Message- From: Guy McArthur [mailto:[EMAIL PROTECTED]] Sent: October 25, 2001 6:28 PM To: Dave Cramer Cc: [EMAIL PROTECTED] Subject: RE: [JDBC] "No Suitable Driver" Huh. Well I have set up J

[JDBC] 7.2beta1 Jar files available for download from jdbc.postgresql.org

2001-10-25 Thread Barry Lind
Subject pretty much says it all. I have posted the 7.2beta1 jar files up on the web site (jdbc.postgresql.org) for people to test if you don't want to built it yourselves. thanks, --Barry ---(end of broadcast)--- TIP 5: Have you checked our ext

[JDBC] Logging in the driver

2001-10-25 Thread Dave Cramer
I am looking at trying to debug the driver for staroffice. Unless someone can tell me otherwise, this requires logging. Currently the driver has a rudimentary mechanism for logging DriverManager.println() This is ok, but it doesn't provide for various levels of debugging. One possibility is to

Re: [JDBC] Code Fixes

2001-10-25 Thread Barry Lind
> In trying to use your driver along with PostgreSQl 7.1 I have found some > problems and fixed them in the DatabaseMetaData class. > > I am not an expert on Postgres, JDBC drivers or open source but I have been > around the coding block a few times. Anyway Transparent Persisten

Re: [JDBC] Logging in the driver

2001-10-25 Thread Gunnar Rønning
* "Dave Cramer" <[EMAIL PROTECTED]> wrote: | | This is ok, but it doesn't provide for various levels of debugging. | | One possibility is to use something like log4j, but given the recent | distaste for adding binaries to the download I am reluctant to add a | library. log4j support would have b

[JDBC] Logging in the driver

2001-10-25 Thread Dave Cramer
I am looking at trying to debug the driver for staroffice. Unless someone can tell me otherwise, this requires logging. Currently the driver has a rudimentary mechanism for logging DriverManager.println() This is ok, but it doesn't provide for various levels of debugging. One possibility is t

[JDBC] Proposal to remove Serialize from the JDBC driver

2001-10-25 Thread Dave Cramer
Hi folks I would like to propose removing the Serialize code from the driver. My reasons for doing so include: 1) It adds unnecessary complexity to the driver 2) I don't think this is the correct place for this code 3) There are much better ways to achieve persistence available. http://www.amb

Re: [JDBC] Code Fixes

2001-10-25 Thread Dave Cramer
Paul, Please send a patch to this list Thanks, Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Paul Sent: October 24, 2001 8:47 PM To: [EMAIL PROTECTED] Subject: [JDBC] Code Fixes Hi, I have been working with your driver along with Forte for

[JDBC] Code Fixes

2001-10-25 Thread Paul
Hi, I have been working with your driver along with Forte for Java and it's not so Transparent Persistence. In trying to use your driver along with PostgreSQl 7.1 I have found some problems and fixed them in the DatabaseMetaData class. I am not an expert on Postgres, JDBC drivers or

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-25 Thread Mark Lillywhite
JDBC1 patch attached. I don't have a JDBC1 environment (that I know of) so I haven't even compiled this... sorry :( I also attach a very small patch to correct my email address in the JDBC 2 patch. Apply it or not, it's not important, I just noticed it. Thanks again Cheers

Re: [JDBC] Accents bug ?

2001-10-25 Thread Jean-Christophe ARNU
On 24 Oct 2001 17:51:56 +0200, Denis Bucher wrote: > You exactely have the same problem as I have. > And my base is also UNICODE... > Well, are you sure ? With *all* tools, that can be psql or pgdump_all, > everything seems > right, look at an extract of a dump : > 6 6 PPN Nigiri

Re: [JDBC] "No Suitable Driver"

2001-10-24 Thread Dave Cramer
And then Connection db = DriverManager.getConnection("jdbc:postgresql://hostname/test"test",test" ); Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Guy McArthur Sent: October 24, 2001 7:13 PM To: [EMAIL PROTECTED] Subject: [JDBC] &quo

[JDBC] "No Suitable Driver"

2001-10-24 Thread Guy McArthur
Hi, I'm trying to get a small test program going. I have built PostgreSQL 7.1.3 on RedHat 6.2 with --java, installed and created databases, verified with psql. The postgresql.jar is on my classpath. My pg_hba.conf has: localall password host

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
> The patch is missing the corresponding fix for > jdbc1/DatabaseMetaData.java. Can you resubmit the patch with a fix for > both occurances of the problem? Otherwise the fix looks fine. I have applied the jdbc2 version. It would be nice to have a jdbc1 version too. Thanks. -- Bruce Momj

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Barry Lind
The patch is missing the corresponding fix for jdbc1/DatabaseMetaData.java. Can you resubmit the patch with a fix for both occurances of the problem? Otherwise the fix looks fine. thanks, --Barry Bruce Momjian wrote: > Here is a patch for DatabaseMetaData to show precision properly. It is

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
Patch applied. Thanks. If you can send a jdbc1 version, that would be great. --- > Here is a patch for DatabaseMetaData to show precision properly. It is > from Mark Lillywhite. I am adding to the patch queue. > > --

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > + tuple[8] = > +Integer.toString((attypmod & 0x) - VARHDRSZ).getBytes(); In the backend sources, we subtract VARHDRSZ *first* and then AND with . Not sure if this will ever yield a different result, but I'd say it should be

Re: [JDBC] Accents bug ?

2001-10-24 Thread Denis Bucher
At 16:15 04.10.01 -0700, you wrote: Hello ! Not reading the mailing-list very often I only answer now. I suppose I started the thread about this bug... >This is a follow-up to my post a few days ago about the JDBC driver >chopping of strings at non-ASCII characters. First a brief summ

Re: [JDBC] StarOffice question

2001-10-24 Thread tony
On Wed, 2001-10-24 at 12:53, Dave Cramer wrote: > It has to go into the staroffice/lib directory if you are using > staroffice6. > > I quickly tried it and it fails due to a nullpointer exception. It is on > my todo list to figure out. > > If you get it working let me know The message says "una

Re: [JDBC] StarOffice question

2001-10-24 Thread Antonio Fiol Bonnín
I'm afraid you should use ODBC instead of JDBC with StarOffice. See http://odbc.postgresql.org I have just checked it out, and have been unable to find what I had found about StarOffice. Hope that helps. Antonio tony wrote: > where do I put the postgresql.jar to connect StarO

Re: [JDBC] StarOffice question

2001-10-24 Thread Dave Cramer
]] On Behalf Of tony Sent: October 24, 2001 4:58 AM To: [EMAIL PROTECTED] Subject: [JDBC] StarOffice question where do I put the postgresql.jar to connect StarOffice to Postgres? I have it in the /usr/java/jdk1.3/lib directory on the client machine (the one running staroffice) Cheers Tony Grant

[JDBC] alternative driver jxDBCon

2001-10-24 Thread Chantal Ackermann
dear all, has anyone made some experience using the jdbc driver jxDBCon for PostgreSQL? it is an alternative to the driver released by PostgreSQL. (http://jxdbcon.sourceforge.net) chantal ---(end of broadcast)--- TIP 3: if posting/reading

[JDBC] StarOffice question

2001-10-24 Thread tony
where do I put the postgresql.jar to connect StarOffice to Postgres? I have it in the /usr/java/jdk1.3/lib directory on the client machine (the one running staroffice) Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with Po

Re: [JDBC] Compliance? Plans?

2001-10-24 Thread Barry Lind
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

Re: [JDBC] JDBC issues for JDK1.4

2001-10-24 Thread Barry Lind
Mark, Any help on moving the jdbc code base forward is more than welcome. In briefly looking over your suggestions below they all seem fine to me. (Of course the devil is in the details). I would also suggest looking at http://lab.applinet.nl/postgresql-jdbc for a list of where we are

Re: [JDBC] [PATCHES] Ant configuration

2001-10-24 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23-Oct-2001 Peter Eisentraut wrote: > Gunnar Rønning writes: >> | * In numerous attempts I have failed to convince Ant to place the built >> | files in a tree different from the source tree. This really makes it a >> | pain to build for multiple

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-24 Thread Bruce Momjian
Here is a patch for DatabaseMetaData to show precision properly. It is from Mark Lillywhite. I am adding to the patch queue. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Bl

Re: [JDBC] [PATCHES] DatabaseMetadata patch

2001-10-23 Thread Bruce Momjian
> Attached is a unified diff to DatabaseMetadata from the jdbc2 interface. > It fixes a bug where the metadata does not include the scale/precision > of the database columns. > > We have been using this patch successfully for about 2 years, it would > be great to finally get it into the sources.

Re: FW: Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Bruce Momjian
can it use native MSWin buildfiles? I see win32.mak but that looks like a standard Makefile. If we require gmake on Win32 to build ODBC, can't we require it for jdbc? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 +

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Bruce Momjian
ote: > > Just a thought. Why not separate postgres and postgres jdbc in that > > case? > > To be honest, this is the one thing I want to avoid if possible. Its important > that the postgres build system builds the 'official' interfaces as well, since > it keeps t

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23-Oct-2001 Shevland, Joseph (AU - Hobart) wrote: >> Does anyone know if we could include ANT into our CVS and >> redistribute it in order to build the jdbc code? Are their license >> incompatibilities between the Apac

Re: FW: Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Gunnar Rønning
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | > Seriously would installing GNU Make be enough, or would you need to install | > Cygwin and other packages as well ? | | GNU make runs natively on Windows. I know and I've used GNU Make when working with Windows, but that taught me that you ofte

[JDBC] gcj

2001-10-23 Thread Jayesh K. Parayali
I compiled postgres jdbc jar into jdbc.so using gcj and moved it into usr/local/gcc/lib which is in my LD_LIBRARY_PATH Then I created an application which uses jdbc and compiled it to native code using gcj now when I run the application, it's not able to find(load) the jdbc driver. Note tha

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23-Oct-2001 Jayesh K. Parayali wrote: > Just a thought. Why not separate postgres and postgres jdbc in that > case? To be honest, this is the one thing I want to avoid if possible. Its important that the postgres build system buil

[JDBC] DatabaseMetadata patch

2001-10-23 Thread Mark Lillywhite
Hi Attached is a unified diff to DatabaseMetadata from the jdbc2 interface. It fixes a bug where the metadata does not include the scale/precision of the database columns. We have been using this patch successfully for about 2 years, it would be great to finally get it into the sources. Suggest

Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Peter Eisentraut
Ned Wolpert writes: > Actuall, it does. peter ~$ ant -version Ant version 1.3 compiled on March 22 2001 peter ~$ echo $? 0 peter ~$ ant Buildfile: build.xml does not exist! Build failed peter ~$ echo $? 0 -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter --

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Shevland, Joseph (AU - Hobart)
T into our CVS and > redistribute > it in order to build the jdbc code? Are their license > incompatibilities > between the Apache License and the PostgreSQL license that > would prevent > this? Should be fine to do, as long as we include the Apache license that comes with Ant along w

Re: FW: Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Peter Eisentraut
Gunnar Rønning writes: > Seriously would installing GNU Make be enough, or would you need to install > Cygwin and other packages as well ? GNU make runs natively on Windows. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadca

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Barry Lind
Tom, My reasons for not wanting to depend on Ant are: Many binary distributions of Postgres are not including the JDBC code because of the added overhead of the jdbc build process (i.e. getting Ant installed). Users have complained to the mail lists in the past about the requirement for Ant

Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Peter Eisentraut
Gunnar Rønning writes: > | * In numerous attempts I have failed to convince Ant to place the built > | files in a tree different from the source tree. This really makes it a > | pain to build for multiple architectures (in Java, architecture = > | different jdk). > > destdir="${build}"

Re: [JDBC] [PATCHES] Ant configuration

2001-10-23 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm using ant 1.4.1 Also, try using it with a valid build.xml file and see how that works when the build fails or succedes On 23-Oct-2001 Peter Eisentraut wrote: > Ned Wolpert writes: > >> Actuall, it does. > > peter ~$ ant -version > Ant versio

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Peter Eisentraut
Barry Lind writes: > If we can include the ANT libraries in our CVS then my > objection to ANT (requiring users to trackdown and download ANT) goes > away, and I would then suggest we continue to use ANT for the other > reasons you mention. My problem with Ant isn't primarily the availability or

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-23 Thread Jayesh K. Parayali
Just a thought. Why not separate postgres and postgres jdbc in that case? Jayesh > -Original Message- > From: Bruce Momjian [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 5:56 PM > To: Barry Lind > Cc: [EMAIL PROTECTED] > Subject: Re: [JDBC] FW:

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

2001-10-23 Thread Michael Ansley (UK)
Title: RE: [JDBC] Ant installation (and other) issues! Why is this such a big issue?  Shipping the Ant binary would be like shipping the make binary, which seems silly to me.  However, I would far prefer to use Ant to build the JDBC driver.  So, is it not possible to simply maintain a

[JDBC] JDBC issues for JDK1.4

2001-10-23 Thread Lillywhite (pg-jdbc)
Hi folks I'd like to make the JDBC driver comple with JDK1.4. I've got the following list of errors and potential remedies. Does anyone have any objections if I start work on this? The following are the methods defined in JDK1.4 which are not currently implemented in the J

[JDBC] Compliance? Plans?

2001-10-23 Thread Per-Olof Norén
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

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

2001-10-23 Thread Per-Olof Norén
;[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 > > nic

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

2001-10-22 Thread Gunnar Rønning
n here. | | 500k of binaries? You just lost the argument. That's not an acceptable | amount of overhead to add to the Postgres distribution. Maybe another reason to look into less monolithic approaches. Both in terms of project distribution and release cycles, I still think a decoupling t

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-22 Thread Tom Lane
the ANT libraries rules that out, even if there weren't a management/synchronization issue: do you want a PG release to be using an older ANT than what you have already installed locally? On the other hand, I can see no reason why we shouldn't say that you *must* have ANT installed to bu

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

2001-10-22 Thread Bruce Momjian
> 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.

Re: [JDBC] Does PG's JDBC support prepared statements at all?

2001-10-22 Thread Thomas O'Dowd
On Sun, Oct 21, 2001 at 02:06:21PM +0200, Rene Pijlman wrote: > On Sun, 21 Oct 2001 11:37:29 +0900, you wrote: > >So I guess what is happening is that the preparedstatement parser > >ignores quoted question marks > > I hope not. I hope it sets the field to a literal '?' :-) I meant ignores them

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

2001-10-22 Thread Ned Wolpert
-standard makefile > solution. Yes, which goes back to my original question. Would someone want to build the JDBC driver without building the rest of postgresql? If this is the case, then we need to make sure that we provide the tools needed build the JDBC driver in this type of environment. If

[JDBC] JDBC build - take 2

2001-10-22 Thread Marko Kreen
,10 +409,8 @@ AC_MSG_CHECKING([whether to build Java/JDBC tools]) PGAC_ARG_BOOL(with, java, no, [ --with-java build JDBC interface and Java tools], [AC_MSG_RESULT(yes) -PGAC_PATH_ANT -if test -z "$ANT"; then - AC_MSG_ERROR([Ant is required to build Java components]) -fi], +PGAC_

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

2001-10-22 Thread Tom Lane
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 a

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-22 Thread Bruce Momjian
S and redistribute > it in order to build the jdbc code? Are their license incompatibilities > between the Apache License and the PostgreSQL license that would prevent > this? I don't think we want to go there. Too much bloat to add it. Looks like 600k. -- Bruce Momjia

Re: [JDBC] FW: Re: [PATCHES] Ant configuration

2001-10-22 Thread Barry Lind
order to build the jdbc code? Are their license incompatibilities between the Apache License and the PostgreSQL license that would prevent this? thanks, --Barry Ned Wolpert wrote: > I meant to send this to the group... > > -FW: <[EMAIL PROTECTED]>- > > Date: Fri,

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

2001-10-22 Thread Marko Kreen
On Sat, Oct 20, 2001 at 03:54:12PM +0200, Per-Olof Norén wrote: > 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 :-) [ points for using Ant ] I would describe current J

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

2001-10-22 Thread Gunnar Rønning
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | Per-Olof Norén writes: | | > 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. | | Make as been the standard for building any application for about 30 years. |

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

2001-10-22 Thread Bruce Momjian
> Per-Olof Nor?n writes: > > > 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. > > Make as been the standard for building any application for about 30 years. > GNU-style configure has been the standard for co

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

2001-10-22 Thread Barry Lind
e as problematic because it isn't a standard for building java applications (although I know of as many java apps built with make as with Ant personally). But the jdbc driver for postgres is both a postgres component and in java. thanks, --Barry ---(end of broadcast)

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

2001-10-22 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 21-Oct-2001 Peter Eisentraut wrote: > Per-Olof Norén writes: >> 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. > > Make as been the standard for building any ap

Re: [JDBC] Whatever ... JDBC build patch

2001-10-22 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 20-Oct-2001 Peter Eisentraut wrote: >> How do distributors that need to build all driver types proceed ? > > I haven't seen one yet, but theoretically they should configure several > different build trees from one source tree. Of course, this do

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

2001-10-22 Thread Peter Eisentraut
Per-Olof Norén writes: > 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. Make as been the standard for building any application for about 30 years. GNU-style configure has been the standard for configuration ma

Re: [JDBC] [PATCHES] Ant configuration

2001-10-22 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 20-Oct-2001 Gunnar Rønning wrote: >| * Ant doesn't provide an exit status; you have to watch the build to see >| if it works. This is unacceptable. > > Hmm. Anybody with a solution here ? Actuall, it does. Example: [wolpert@wolpert configTest

  1   2   3   4   5   6   7   8   9   10   >