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 few questions for people to see if they can figure it out: > >

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

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

2001-02-07 Thread Greg Speegle
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 few questions for people to see if they can figure it out: > > * How to detect what table a column belongs so. Required if t

[JDBC] Re: [ADMIN]

2001-02-07 Thread Barry Lind
I have a question/concern with the proposed patch here. The assumption that a column of type oid is a BLOB I think is incorrect. OIDs can also be used as a simple FK reference from one table to another since they are unique. I think the current behavior with regards to OIDs is more correct in m

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

2001-02-07 Thread Dror Matalon
Here's the code that I'm currently using. For Postgres, since there's no tablename I pass it as an argument to the method (you can ignore that part), for mysql I just check and see that all the table names are the same. Once I figure out that they're all in one table I check to see that the res

[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

[JDBC] Callable Statements

2001-02-07 Thread Gregory Bittar
My team is engaged in work that is anticipating that Postgres 7.1's JDBC driver will include bare CallableStatement functionality. We are writing Java classes with SQL stored procedure invocation code, expecting to receive integer result values from the database. The last I heard, the Postgres