[JDBC] Postgresql 7.1.2 and StarOffice 5.2

2001-08-15 Thread Arnaud ESPANEL
Hello, I haven't managed to access POstgresql 7.1.2 databases using StarOffice 5.2 using jdbc or odbc. I read quite a good number of posts on the subject, and it appearts that nobody managed to do it using jdbc, but some managed with odbc. Using Debian package for Postgres 7.1.2 and Debian

Re: [JDBC] Postgresql 7.1.2 and StarOffice 5.2

2001-08-15 Thread Rene Pijlman
On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote: >Using Debian package for Postgres 7.1.2 and Debian >jdbc Driver, i managed to connect to the database >but the list of tables is empty ! I'm afraid you'll have to be more specific. What functionality in what piece of software are you us

Re: [JDBC] Postgresql 7.1.2 and StarOffice 5.2

2001-08-15 Thread Arnaud ESPANEL
> On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote: > >Using Debian package for Postgres 7.1.2 and Debian > >jdbc Driver, i managed to connect to the database > >but the list of tables is empty ! > > I'm afraid you'll have to be more specific. What functionality > in what piece of softw

RE: [JDBC] Postgresql 7.1.2 and StarOffice 5.2

2001-08-15 Thread Dave Cramer
Hi All, This is due to the current incompleteness of the jdbc driver; specifically the metadata functionality. Rene; a better piece of software to test for completeness is druid, which is a database design tool; it makes heavy use of the metadata features Dave -Original Message- From:

Re: [JDBC] hangs while getting large objects...

2001-08-15 Thread Rene Pijlman
On Wed, 15 Aug 2001 15:04:21 -0400, you wrote: >i am confident that this problem is a problem with my code and not postgres OK, so where is your code? A small isolated test case that reproduces the problem would be best. Since this appears to be JDBC-specific I did not cc pgsql-general. Regards

[JDBC] select on multiple tables

2001-08-15 Thread Carterette, Ben
I apologize in advance if this isn't the right place to ask this. I have a query like "SELECT * FROM table1, table2" and I want to read values out of a ResultSet. What if the two tables have column names in common and I can't predict the column numbers? Is there any way to get table1.id and tab

Re: [JDBC] select on multiple tables

2001-08-15 Thread Rene Pijlman
On Wed, 15 Aug 2001 16:43:31 -0500, Ben Carterette wrote: >I have a query like "SELECT * FROM table1, table2" and I want to read values >out of a ResultSet. What if the two tables have column names in common and >I can't predict the column numbers? Is there any way to get table1.id and >table2.i

RE: [JDBC] hangs while getting large objects...

2001-08-15 Thread chris markiewicz
While I can readily reproduce it on my application, I have so far been unsuccessful at writing a test case that reproduces the problem. Oh, I just tried the latest drivers - no luck - same problem. Equally unfortunate is the fact that all database processing is heavily abstracted in the applicat

[JDBC] Re: [PATCHES] patch for JDBC PreparedStatement

2001-08-15 Thread Barry Lind
Alexander, > Hello Barry, > > First of all, it is possible that this patch is no needed to be applied. > > I will try to explain the problem: > > Some times ago I have to insert some texts into filed with type text. > Everything was great until I have read the log file of postges: I was > sh

RE: [JDBC] hangs while getting large objects...

2001-08-15 Thread Dave Cramer
Chris, Try using the latest jar files from http://jdbc.fastcrypt.com DAve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of chris markiewicz Sent: August 15, 2001 3:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [JDBC] hang

[JDBC] hangs while getting large objects...

2001-08-15 Thread chris markiewicz
hello. i occasionally have problems getting large objects from postgres. i am confident that this problem is a problem with my code and not postgres because i cannot find similar complaints and no one responded to my question from earlier this month (appears later in this email). I have a scree