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

2001-02-07 Thread Peter Mount
At 14:12 07/02/01 -0500, Bruce Momjian wrote: >Thies, we talked at LinuxWorld about improving the reliability of >persistent PostgreSQL connections in PHP. > >I believe the problem is that persistent connections sometime do not >pass clean sessions because of open transactions and SET changes to t

Re: [JDBC] Fw: jdbc.postgresql.org/docs/

2001-02-24 Thread Peter Mount
At 12:18 22/02/01 +0200, Lajos Malozsak wrote: >Hello, > >The JDBC documentation page cannot be found. The same thing was happend >when I tried to access the development and the tutorial pages. >Are those in construction or is a mistake ? Under construction ;-) I'm actually working on them a

[JDBC] Re: [DOCS] Java class documentation

2001-02-24 Thread Peter Mount
At 22:07 22/02/01 +0100, Peter Eisentraut wrote: >I've started to finish up the not-marked-up-yet parts of the JDBC >documentation, but most of this seems to have once been generated by >javadoc, and I feel like it is probably a wasted effort to try to manually >convert this to DocBook. Actually

[JDBC] Re: [DOCS] Java class documentation

2001-02-24 Thread Peter Mount
At 16:00 23/02/01 +, Thomas Lockhart wrote: > > Could we for now remove the formal class documentation from the DocBook > > source, while keeping the narrative parts, and instead point people to the > > JavaDoc? Could we make prebuild class documentation in HTML available to > > users, maybe

Re: [JDBC] f is not a valid bitstring

2001-02-24 Thread Peter Mount
At 09:00 23/02/01 -0800, Skidmore, Walt wrote: >I have an entity bean that uses a boolean for a field, and that boolean >maps to a bit field in the database. Is this the proper field I should be >mapping to? Under Sybase and MSSQL 7, there were no problems with sending >"true" or "false" thr

[JDBC] Re: [INTERFACES] unable to find postgresql.jar

2001-02-24 Thread Peter Mount
At 22:49 21/02/01 -0800, Shankar Gowda wrote: >Hello sir/madam, > i have install postgresql 6.5.3 and unable to >configure the jdbc to it. >i have installed jdbc rpms and it gave me >/usr/lib/pgsql/jdbc6.5-1.1.jar and >/usr/lib/pgsql/jdbc6.5-1.2.jar. but, i could not find >where is postgresql.j

Re: [JDBC] RE: f is not a valid bitstring

2001-02-24 Thread Peter Mount
At 15:17 23/02/01 -0800, Skidmore, Walt wrote: >An update: I looked through the documentation, and found that the bool >type might be better suited. So, after changing the field type, I'm >getting a new error: > >java.sql.SQLException: ERROR: pg_atoi: error in "f": can't parse "f" Hmm, its tr

Re: [JDBC] Concurrency supported?

2001-03-01 Thread Peter Mount
At 02:20 25/02/01 +0100, Ingo Luetkebohle wrote: >Hiya, > >how good is concurrency supported in the JDBC driver? For example, if >I have a small process with about 50 threads, some of them requesting >large objects, will one JDBC connection suffice? If one thread is >executing a large select which

[JDBC] Re: [DOCS] Java class documentation

2001-03-01 Thread Peter Mount
At 00:28 25/02/01 +0100, Peter Eisentraut wrote: >Peter Mount writes: > > > Actually I was waiting until 7.1 was out before rewriting the jdbc docs > > >from scratch (so much has changed since those were written). > >I can see that. However, 7.1 users should still get

Re: [JDBC] PATCH to org/postgresql/jdbc2/DatabaseMetaData.java

2001-03-01 Thread Peter Mount
I'll take a look at this patch shortly. Sorry for the delay, work has been hectic this week so I'm about 4 days behind with emails. Peter At 17:22 25/02/01 -0500, Ola Sundell wrote: >--- >postgresql-7.1beta4/src/interfaces/jdbc/org/postgresql/jdbc2/DatabaseMetaData.java >Mon Jan 29 03:53:56 20

Re: [JDBC] Re: Concurrency supported?

2001-03-01 Thread Peter Mount
At 19:44 26/02/01 -0500, Joseph Shraibman wrote: >Peter Eisentraut wrote: > > > > Ingo Luetkebohle writes: > > > > > how good is concurrency supported in the JDBC driver? For example, if > > > I have a small process with about 50 threads, some of them requesting > > > large objects, will one JDBC

Re: [JDBC] PostgresqlDataSource

2001-03-01 Thread Peter Mount
At 13:50 27/02/01 -0800, Peter T. Brown wrote: >I am trying to use Castor (castor.exolab.org). It requires that I use JDBC >(and specifically the postgresqldatasource class). I have downloaded the >postgresql-7.1beta5 src. Whenever I try to build the postgresql.jar using >ant I get: snip /home/p

Re: [JDBC] JBuilder4

2001-03-01 Thread Peter Mount
At 10:31 01/03/01 +0100, Catalin CIOCOIU wrote: > I have installed the driver JDBC for postgres in JBuilder. > I have a problem when I use JDBC Explorer. I can't see the folder >TABLES when I open a Postgres Database. I see other folders (procedures >etc). The querys works fine. >C

Re: [JDBC] Blobs and length +- 1

2001-03-01 Thread Peter Mount
At 09:31 01/03/01 -0500, Philip Crotwell wrote: >Hi > >I am using Blobs with jdbc and postgres7.0.3 and noticed that my blobs >were coming out of the database 1 byte shorter than they went in! The >problem was that I was using >byte[] b = blob.getBytes(1, (int)blob.length()); >instead of >byte[]

Re: [JDBC]

2001-03-12 Thread Peter Mount
At 11:09 08/03/01 -0600, Dax Duskin wrote: >Hello all. > >I was hoping someone could help me with the following: > >I am trying to install jdbc and I am having some trouble. I am using the >Linux-Mandrake Distribution (7.2). > >First I installed the postgresql-jdbc rpm, but I couldn't find my >

Re: [JDBC] DatabaseMetaData and ResultSetMetaData

2001-03-12 Thread Peter Mount
At 20:22 09/03/01 +0100, Alberto Otero GarcĂ­a wrote: >Hello everybody, > > I'm planning to do a tool in order to reverse engineer from a > database >already created to a UML diagram. I'd like to do the test with a PostgreSQL >database, but I've found that DatabaseMetaData and ResultSetMet

Re: [JDBC] JDBC build patches

2001-03-12 Thread Peter Mount
At 23:42 09/03/01 +0100, Peter Eisentraut wrote: >These are the follow-up patches to Peter Mount's recent Java build >improvements. > >* implement 'make uninstall' for the java directories What's the difference between uninstall and clean? >* pick up the version information from Makefile.global

Re: [JDBC] getTables is this right?

2001-03-12 Thread Peter Mount
At 23:39 09/03/01 -0800, Eric Frazier wrote: >Hi, > >I am having problems getting info on tables with getTables. I get null >returned all of the time. Where is it returning null? It should always return a result set. >I was using this code > >snip: > >//String [] onlytables = new String[3]; >

Re: [JDBC] callable statements, latest snapshot

2001-03-12 Thread Peter Mount
At 19:46 11/03/01 -0500, Gregory Bittar wrote: >The last I heard, CallableStatements were going to be >part of the 7.1 release. I downloaded the latest 7.1 >snapshot (March 10th's) and was surprised to find that >the Connection objects for both JDBC1 and JDBC2 drivers >are hardcoded to throw an e

Re: [JDBC] JDBC build patches

2001-03-12 Thread Peter Mount
At 17:47 12/03/01 +0100, Peter Eisentraut wrote: >Peter Mount writes: > > > What's the difference between uninstall and clean? > >'clean' undoes 'all', 'uninstall' undoes 'install'. Ah ok. > > >* honour the default port a

[JDBC] Re: [INTERFACES] object id

2001-03-12 Thread Peter Mount
At 19:22 12/03/01 +0100, [EMAIL PROTECTED] wrote: > >Hmm, not really. The only oid you can get is one from an Insert, but thats > >for the most recent row inserted. > > >How do i get the oid from the blob of the most recent row inserted? The only way is to re-query the row as only the oid of the

[JDBC] Re: [INTERFACES] JDBC: can't set transaction isolation level

2001-03-12 Thread Peter Mount
At 14:29 12/03/01 -0300, [EMAIL PROTECTED] wrote: redirecting to jdbc list: > Hi, > > I need to set transaction isolation level to SERIALIZABLE in a java > program. >Calling the method setTransationIsolation of class Connection has no >effect: the >isolation level still remains READ_COMM

Re: [JDBC] Compiling

2001-03-25 Thread Peter Mount
At 14:21 25/03/01 +0200, Peter Eisentraut wrote: >Mike Cannon-Brookes writes: > > > tried to pull down the latest src and compile it but I can't. The build > file > > seems to filter properties like MAJORVERISON, MINORVERSION etc with ant > > properties that don't exist? > >You aren't running 'an

Re: [JDBC] RE: Compiling

2001-03-29 Thread Peter Mount
At 18:56 27/03/01 +0200, Peter Eisentraut wrote: >Mike Cannon-Brookes writes: > > > 1) ant files are quickly becoming a standard for compiling almost all open > > source java projects > >The nice thing about standards is that there are so many to choose from. >At PostgreSQL, we use the GNU-style b

[JDBC] RE: Compiling

2001-03-29 Thread Peter Mount
At 10:47 26/03/01 +1000, Mike Cannon-Brookes wrote: >IMHO make should not be needed at all? > >I've hard coded the numbers into the Ant script now and it works fine. Java >users like myself have brains that go "ooh, build.xml, let me run ant" to >compile things. > >Why do we need make? (I'm sure t

Re: [JDBC] Compiling

2001-03-29 Thread Peter Mount
At 22:35 25/03/01 +0200, Peter Eisentraut wrote: >Peter Mount writes: > > > At 14:21 25/03/01 +0200, Peter Eisentraut wrote: > > >Mike Cannon-Brookes writes: > > > > > > > tried to pull down the latest src and compile it but I can't. The build >

Re: [JDBC] RE: Compiling

2001-03-29 Thread Peter Mount
At 13:04 27/03/01 +0200, Marko Kreen wrote: >On Tue, Mar 27, 2001 at 07:54:15AM +1000, Mike Cannon-Brookes wrote: > > Well Peter, I must say many would disagree with you there ;) > >* NSHO about ant deleted * > > > 3) currently we seem to have a build process that is 99% Ant and 1% make > > (for 4

Re: [JDBC] Possible large object bug?

2001-03-29 Thread Peter Mount
At 10:37 27/03/01 +1000, Joe Shevland wrote: >Hi, > >Semi-topical I hope ;) Yes semi ;-) > I've started using Postgres 7.1 (FreeBSD 4.2-S) and large objects via > JDBC. (postmaster (PostgreSQL) 7.1beta5) I'm forwarding this to the bugs list as it looks like something nasty in the back end.

Re: [JDBC] Logging Queries

2001-03-29 Thread Peter Mount
At 12:01 27/03/01 -0800, Hunter Hillegas wrote: >I'm having a problem with queries sent in from a Java program. > >Is there any way to have the server log the queries that are coming in so I >can see what's actually getting processed? From the server: Can't remember which, but -d1 or -d2 when yo