Re: [GENERAL] [JDBC][INTERFACES][NOVICE] Postgresql inteface to Star Office using JDBC

2001-02-07 Thread Peter T Mount
Quoting R9Pilot <[EMAIL PROTECTED]>: > Has anyone had any luck interfacing StarOffice to PostgreSQL using > JDBC? So far, I've not managed it. I'm going to have another crack at it before 7.1 is released, but I'm getting exactly the same result as you. It might be the same problem that JBuilde

Re: [JDBC] Re: [ADMIN]

2001-02-07 Thread Peter T Mount
Quoting Bruce Momjian <[EMAIL PROTECTED]>: > [ Charset ISO-8859-1 unsupported, converting... ] > > Attached is a modified version of Field.java for the JDBC driver. > > I think types were not so correctly defined, and that this version > > should be more well suiting last version of postgres. > >

[JDBC] Re: [INTERFACES] Q on JDBC's resultset

2001-02-07 Thread Peter T Mount
Quoting Greg Speegle <[EMAIL PROTECTED]>: > > > Peter T Mount wrote: > > > 7.1 has the beginings of an UpdateableResultSet. When I can work out > how to > > solve a few fundamental problems it shouldn't take long. > > > > Here's a fe

[JDBC] Re: [BUGS] 7.1beta4 jdbc problem on freebsd 4.2 with JSDK 1.1.8.

2001-02-07 Thread Peter T Mount
Quoting Nat Howard <[EMAIL PROTECTED]>: > Using java SDK 1.1.8, which is the current "real" java in the > freebsd ports tree, one can't compile the jdbc driver. The Implementation > file mentions that "ant" has not been tested with 1.1.X, and suggests > that the deprecated makefile will work.

Re: [JDBC] Xn block abort exceptions: BUG+PATCH

2001-02-12 Thread Peter T Mount
Quoting KB Sriram <[EMAIL PROTECTED]>: > I'm using the 7.0.3 release JDBC driver, and observed that when > Postgres aborts the transaction because of a problem within a > transaction block, SQLExceptions are not always thrown from the > driver on further queries within that block. > > For exampl

[JDBC] Status of JDBC web site

2001-02-12 Thread Peter T Mount
Before anyone else emails me saying that the links are broken, I know. I was in the middle of updating the site when I got interrupted, and haven't had chance to fix it yet (problem with a Dreamweaver template). It's doubtful I'll get chance to fix it before tomorrow (due to getting back from

Re: [JDBC]

2001-02-12 Thread Peter T Mount
Quoting KB Sriram <[EMAIL PROTECTED]>: > I'm using the 7.0.3 release JDBC driver, and observed that when > Postgres aborts the transaction because of a problem within a > transaction block, SQLExceptions are not always thrown from the > driver on further queries. [snip] > Looking into the code,

[JDBC] Re: [INTERFACES] jdbc fastpath error & Z error (URGENT NEED!!!)

2001-02-13 Thread Peter T Mount
Quoting Mark <[EMAIL PROTECTED]>: redirecting to jdbc list... > Hy, Postgresql community! > > I'm using: > Linux RedHat6.2, > PostgreSql6.5.3+jdbc6.5-1.2, > jdk1.2.2 > (AND I CAN'T CHANGE THIS "KIT") Tricky. It's fixed in 7.0. The only thing I can advise is to use the web frontend of cvs, and

[JDBC] Re: [INTERFACES] data trnsfer through Web.

2001-02-16 Thread Peter T Mount
Quoting Manika dey <[EMAIL PROTECTED]>: redirecting to jdbc list: > > Hi, > > I want to transfer data files to database(postgresql) > through Web,I am using java servlets for server-side > programming . > When i transfer the data files from users > directory on database server mac

Re: [JDBC] Trouble With JDBC

2001-02-16 Thread Peter T Mount
Quoting Corey Mosher <[EMAIL PROTECTED]>: > Hi, > > I am trying to test out the postgres-JDBC driver. I have a > file called sample.java. It compiles fine, but when I run it > I get the following error: > > Exception in thread "main" java.lang.NoClassDefFoundError: sample/java > > This is

Re: [JDBC] newbie: retep wants to have username?

2001-02-16 Thread Peter T Mount
Quoting Mirko Zeibig <[EMAIL PROTECTED]>: > Hello everybody, > > I am not that deep in Java, just playing a bit with it, using PG7.1beta > from > CVS on RedHat 7.0. Going to contrib/retep/jars I tried: > > [mirko@romulan jars]$ java -cp ./retepTools.jar \ > uk.org.retep.xml.test.XMLExport \ > -

[JDBC] Re: [INTERFACES] First-time JDBC setup with Jakarta! Whee!

2001-02-20 Thread Peter T Mount
Quoting Adam Haberlach <[EMAIL PROTECTED]>: > I could have sworn that we were splitting this list up, > to move the PHP and JDBC stuff somewhere else, but I can't > seem to find any reference to that on the web pages, so here > goes. [EMAIL PROTECTED] is the list. I'm cc'ing that list now.

Re: [JDBC] No pg_hba.conf entry

2001-02-22 Thread Peter T Mount
Quoting George Koras <[EMAIL PROTECTED]>: > Hello, > > When I try to connect via JDBC to PostgreSQL I get the following error > message: > > Error -- Something unusual has occured to cause the driver to fail. > Please report this exception: > java.sql.SQLException: No pg_hba.conf entry for host

Re: [JDBC] JDBC Timestamp problem

2001-02-22 Thread Peter T Mount
Quoting Antonio Fiol <[EMAIL PROTECTED]>: > Hello, > > I have an application that worked well woth Postgresql 6.5. > > Now I am on 7.0, and I get this exception when I execute an > rs.getTimestamp("reftime"): > > Bad Timestamp Format at 0 in 1970-01-01 01:26:56.99+01 > at > org.postgre

Re: [JDBC] reteptools.jar

2001-02-23 Thread Peter T Mount
Quoting Mike Cannon-Brookes <[EMAIL PROTECTED]>: > What is this for? Anything useful in it Peter? > > I assume some purpose but it just seems to compile and sit around ? ;) It's my own in house suite of tools for JDBC (both using & developing). I decided at the start of the year to release th

Re: [JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-23 Thread Peter T Mount
Quoting Antonio Fiol <[EMAIL PROTECTED]>: > Joseph Shraibman wrote: > > > jdbc version don't follow postgres versions, so the jdbc drivers from > > the 7.1 codebase should work with a 7.0 server. Provided there > aren't any bugs in those jdbc drivers, of course. Why are you using 7.0 > when 7.

Re: [JDBC] reteptools.jar

2001-02-23 Thread Peter T Mount
Quoting Travis Bauer <[EMAIL PROTECTED]>: > Peter T Mount ([EMAIL PROTECTED]) wrote: > > [deleted text] > > > > Now why put them into PostgreSQL rather than separately? Well it's > because 90% > > of them were written specifically for PostgreSQL (

[JDBC] Re: [Patch] Implementation of DatabaseMetaData.getIndexInfo()

2001-03-02 Thread Peter T Mount
Quoting William Webber <[EMAIL PROTECTED]>: > Hi all! > > I'm reposting this from postgresql-patches, where it didn't seem to > get picked up. It's a patch implementing It's probably in my todo folder. It's quite easy to miss the odd patch or two with the amount of email I get, which was one

Re: [JDBC] driver error

2001-03-02 Thread Peter T Mount
Quoting Gabriel Mihalache <[EMAIL PROTECTED]>: > Hi! > I have a problem with the driver. > The jar file is in my class path but the org.postgres.Driver object is > unavailable... Are you loading the driver? ie: Class.forName("org.postgresql.Driver"); Peter > any ideas? > > I want to use it

Re: [JDBC] Problems with JDB Driver.

2001-03-02 Thread Peter T Mount
Quoting Igor Hribik <[EMAIL PROTECTED]>: snip > Is there any new driver available now ? 7.1 is in beta now, and should be fully released in 2 weeks or so. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://w

Re: [JDBC] JDBC : problem to update DECIMAL column.

2001-03-05 Thread Peter T Mount
Quoting Igor Hribik <[EMAIL PROTECTED]>: > Please could you inform us, if this issue will be solved by you or if > there is new version of driver. 7.1 is currently in beta, and is the most complete driver to date. -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk

[JDBC] Re: [INTERFACES] 'Unknown Result Type' - JDBC Driver

2001-03-05 Thread Peter T Mount
Quoting Rini Dutta <[EMAIL PROTECTED]>: redirecting to the JDBC list: > I am using the JDBC interface. Does anybody know what > could lead to the following two errors I ran into - > This seems to have been followed by a whole lot of > occurences of - > > 2. Unknown Response Type ^@ Look

Re: [JDBC] JBuilder4 ...

2001-03-06 Thread Peter T Mount
Quoting Catalin CIOCOIU <[EMAIL PROTECTED]>: > I have a problem when I use JDBC Explorer. In some cases it don't > return > the errors. > par example: > select * frum table > ^^ > > It is a bug or a feature ? I'll try it from here in a moment, but I'd say it's a JBuilder bug. The b

Re: [JDBC] Re: [COMMITTERS] pgsql/ /aclocal.m4 /build.xml /configure /conf ...

2001-03-06 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Peter Mount writes: > > > What it does is add a new option to configure: --with-java > > > > This option tells configure to look for ant (our build tool of > choice) and > > if found, it then compiles both the JDBC driver and the new to

Re: [JDBC] JBuilder4 ...

2001-03-06 Thread Peter T Mount
Quoting The Hermit Hacker <[EMAIL PROTECTED]>: > On Tue, 6 Mar 2001, Peter T Mount wrote: > > > Quoting Catalin CIOCOIU <[EMAIL PROTECTED]>: > > > > > I have a problem when I use JDBC Explorer. In some cases it don't > > > return > > &

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

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 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 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

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

2001-03-21 Thread Peter T Mount
Quoting Barry Lind <[EMAIL PROTECTED]>: > 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 w

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

2001-03-21 Thread Peter T Mount
se select. Peter > > Regards, > > Selvam > > > > > > > Peter T Mount >

[JDBC] Re: patches for jdbc1 (fwd)

2001-03-22 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Peter M., can you examine this patch? Hmmm, looks ok although I'm not sure by reading this if the warning target gets executed if jdk1.2+ is not set, because of the if="jdk1.2+" in the compile target. I'll have to try it with ant, but I think an

Re: [JDBC] I can't connect

2001-03-22 Thread Peter T Mount
Quoting Bart <[EMAIL PROTECTED]>: > Hi, > > I installed debian 2.2r2 with _all_ the postgres-packages, I created a > database and via psql I can do whatever I want with the DB. Now I'm > trying to make a connection via a Java-program. I downloaded the > jdbc-6.5-1.2.jar file and renamed it to

Re: [JDBC] RE: Compiling

2001-04-02 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Marko Kreen writes: > > > On Thu, Mar 29, 2001 at 09:50:04AM +0100, Peter Mount wrote: > > > At 13:04 27/03/01 +0200, Marko Kreen wrote: > > > >On Tue, Mar 27, 2001 at 07:54:15AM +1000, Mike Cannon-Brookes > wrote: > > > > > 3) currently we seem to

Re: [JDBC] Jdbc driver

2001-04-02 Thread Peter T Mount
Quoting sugumar <[EMAIL PROTECTED]>: > Connection con=DriverManager.getConnection ("jdbc:postgresql://192.168.230.148/meeting,postgres,postgres"); Your url is wrong, it should read > Connection con=DriverManager.getConnection ("jdbc:postgresql://192.168.230.148/meeting","postgres","postgres");

Re: [JDBC] JDBC2.0 Support

2001-04-02 Thread Peter T Mount
Quoting Pattabi Raman <[EMAIL PROTECTED]>: > We have Postgres 7.0.3 running on Red Hat 7.0. The JVM installed is from > Blackdown.org. We are using jdbc7.1_1.2.jar driver. > > We are unable to use the JDBC2.0 methods. > For example: > we tried calling > DatabaseMetaData.supportsResultSetType(in

Re: [JDBC] RE: Problem connecting to JDBC 7.0-1.2 driver

2001-04-02 Thread Peter T Mount
Quoting "B.N.V. Raman" <[EMAIL PROTECTED]>: > I tried both methods: > > 1. Class.forName("postgresql.Driver"); (in the code) 7.0 and later it's "org.postgresql.Driver" > 2. omitting the above code and trying: java > -Djdbc.drivers=postgresql.jar Nope, -Djdbc.drivers=org.postgresql.Driver Pet

Re: [JDBC] Couple of patches for jdbc driver

2001-08-22 Thread Peter T Mount
* Bruce Momjian <[EMAIL PROTECTED]> wrote: | | This issue came up recently in relation to backpatching a python fix, | and the conclusion was that jdbc 7.1.X is "a hopeless cause" and I tend | to agree. I had >6 unapplied jdbc patches at the time we released 7.1. | They are all now in CVS. > I'v

Re: [JDBC] Couple of patches for jdbc driver

2001-08-22 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Tom Lane writes: > > > IIRC, at one time ODBC *was* a separate project, and we decided that > > that wasn't working too well. Anyone recall the reasons we pulled it > > into the main CVS tree? Wouldn't do to make the same mistakes > twice... > >

Re: [JDBC] jdbc "proxy" server ...

2001-08-23 Thread Peter T Mount
Quoting "Marc G. Fournier" <[EMAIL PROTECTED]>: > > have a database behind a firewall ... we'd like to make connections > available to that machine through a machine outside of the firewall, so > that its a secure connection to the "proxy", and in-secure from > proxy->database ... > > the 'clie

Re: [JDBC] Re: Couple of patches for jdbc driver

2001-08-23 Thread Peter T Mount
Quoting Bruce Momjian <[EMAIL PROTECTED]>: > > The other reason for telling people who are experiencing problems > with > > the driver to get the latest version is that their bug has probably > > already been fixed. > > > > However a certain degree of caution should probably be exercised > here

[JDBC] Fw: JDBC Bug Report

2001-09-14 Thread Peter T Mount
Hi guys, this has been sent direct to me. Peter --- Hi, I have a table with those column name "position" and "local" and I use the JDBC for PostgreSQL as you provided. But when I run the my Java Application. I t prompts up SQLException: parser: parse error at or near "position"("lo

[JDBC] Fwd: Large Objects (please help)

2001-10-08 Thread Peter T Mount
I'm forwarding this to the jdbc list. Peter >Hi Peter, > >I am trying to insert and/or select from Postgres a gif image by using >the Large Object type. I am writing a Java client and middle tier to a >Postgres db backend using your JDBC driver and I have hit an issue with >what your documanta