Re: [JDBC] Re: PostgreSQL and PHP persistent connections

2001-03-20 Thread Gunnar R|nning
Bruce Momjian <[EMAIL PROTECTED]> writes: > > Well, I think most connection pools people use are database independent - > > when it comes to JDBC this is the case at least. > > So what platform-indendent method do they use to see that the passed > connection doesn't have an open transaction or

Re: [JDBC] get the query created by PreparedStatement

2001-03-20 Thread Garry Thuna
Eric, I have always wanted the same thing for both debugging as well as logging. The best I have been able to come up with is a wrapper class to PreparedStatement. This works well with the exception that some of the methods of PreparedStatement are depreciated and you will always get a compiler

Re: [JDBC] get the query created by PreparedStatement

2001-03-20 Thread Peter T Mount
Quoting Garry Thuna <[EMAIL PROTECTED]>: > Eric, > > I have always wanted the same thing for both debugging as well as > logging. How about the toString() method ;-) Ok, may not be standard JDBC, but: PreparedStatement ps = ; // later org.postgresql.jdbc2.PreparedStatement ps2 = (o

[JDBC] pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()

2001-03-20 Thread Julian Richardson
Hi all, maybe this one's been asked before but I've just found this list (if it's archived & searchable someplace then let me know) I just installed Postgres 7.0.3 the other day (Redhat 7.0) and was trying to insert binary data into the DB via JDBC using the standard PreparedStatement.setBinaryS

Re: [JDBC] reteptools.jar

2001-03-20 Thread Peter Eisentraut
Bruce Momjian writes: > > The only one of my tools that will not go in is the pdf library. One because > > it's pretty big, but mainly because It's the only one previously released and I > > put that one out on the LGPL (the rest are fresh - never been released, so > > theres no Licence problems)

Re: [JDBC] pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()

2001-03-20 Thread Peter T Mount
Quoting Julian Richardson <[EMAIL PROTECTED]>: > I didn't study the code in detail but it looked like there's stuff > missing > in the Large Objects API too, so it may not even be possible to use that > as > an alternative (I'd rather not anyway, but may have been able to make > the > setBinarySt

Re: [JDBC] reteptools.jar

2001-03-20 Thread Ross J. Reedstrom
On Tue, Mar 20, 2001 at 05:00:12PM +0100, Peter Eisentraut wrote: > Bruce Momjian writes: > > > > I am told you can re-release LGPL stuff with a BSD license. You just > > need to up the version number and put a BSD license on it. > > I don't think so. But since Peter M. is the author of the lib

Re: [JDBC] reteptools.jar

2001-03-20 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Bruce Momjian writes: > > > > The only one of my tools that will not go in is the pdf library. One > because > > > it's pretty big, but mainly because It's the only one previously > released and I > > > put that one out on the LGPL (the rest are fr

Re: [JDBC] reteptools.jar

2001-03-20 Thread Peter T Mount
Quoting "Ross J. Reedstrom" <[EMAIL PROTECTED]>: > On Tue, Mar 20, 2001 at 05:00:12PM +0100, Peter Eisentraut wrote: > > Bruce Momjian writes: > > > > > > I am told you can re-release LGPL stuff with a BSD license. You > just > > > need to up the version number and put a BSD license on it. > >

Re: [JDBC] reteptools.jar

2001-03-20 Thread Bruce Momjian
> Bruce Momjian writes: > > > > The only one of my tools that will not go in is the pdf library. One because > > > it's pretty big, but mainly because It's the only one previously released and I > > > put that one out on the LGPL (the rest are fresh - never been released, so > > > theres no Licen

Re: [JDBC] reteptools.jar

2001-03-20 Thread Peter T Mount
Quoting Bruce Momjian <[EMAIL PROTECTED]>: > > Bruce Momjian writes: > > > > > > The only one of my tools that will not go in is the pdf library. > One because > > > > it's pretty big, but mainly because It's the only one previously > released and I > > > > put that one out on the LGPL (the rest

[JDBC] Re: [INTERFACES] Trouble with JDBC2 ResultSet.getDate()

2001-03-20 Thread Barry Lind
Actually it was the changes in version 1.21 on 2/13 that broke this. The cvs log for that change includes the following comment: - Removed need for SimpleDateFormat in ResultSet.getDate() improving performance. My guess is the the code as written would work correctly for a 'date' column, but

Re: [JDBC] get the query created by PreparedStatement

2001-03-20 Thread Eric Frazier
Hi, This does work, both with the postgress and mysql drivers. But I do need to make SURE it will work no matter the driver, so it sounds like Garry's code would be the best bet for that. Thoughts? Thanks, Eric >How about the toString() method ;-) > >Ok, may not be standard JDBC, but: > >P

Re: [JDBC] pg703: support for Large objects via JDBC PreparedStatement.setBinaryStream()

2001-03-20 Thread selvam
I do not understand when people say that pg7.03 is out and some are talking about 7.1. What is the difference anyway? As far as I know 7.03 is the latest. What about 7.1? I am new to postgreSQL. Can someone please clarify me? And added to that, if 7.03 is out, does the jdbc support calling stored

Re: [JDBC] get the query created by PreparedStatement

2001-03-20 Thread Garry Thuna
Eric, I have always wanted the same thing for both debugging as well as logging. The best I have been able to come up with is a wrapper class to PreparedStatement. This works well with the exception that some of the methods of PreparedStatement are depreciated and you will always get a com

[JDBC] Trouble with JDBC2 ResultSet.getDate()

2001-03-20 Thread Juhan-Peep Ernits
System is Debian "woody" java is IBM SDK1.3 Source is CVS from March 20, 2001. Trouble is the following, that org.postgresql.jdbc2.ResultSet.getDate(int) Started to generate errors java.lang.NumberFormatException: 15 14:25:17+02 at java.lang.Integer.parseInt(Integer.java:415)