Обсуждение: JDBC driver does not accept good md5 passwords

I'm using very often OpenOffice to administrate databases (It has
options, wchich are not present in pgadmin3).
If I use JDBC connection and server don't requiers md5 passwords, I can
edit and administrate the databases/tables via OpenOffice and JDBC. I
can only read the tables. When server requiers md5 passwords I can't. Of
course, I want to have possibility to edit tables via OpenOffice :-).
Has anybody any idea, how to do this ?
I'm using "postgresql-8.2-504.jdbc3.jar" and "jre1.5.0_06". Server 8.0.7
compiled/using on FC3 or binary installation 8.0.6 on Win2003. I've
tried older *.jar version with this same result. OpenOffice 2.0.3 or 1.4.1.
Greetings
Adam

Dear Adam,

I usualy do use the native driver for OpenOffice from
http://dba.openoffice.org/drivers/postgresql/index.html.
With this driver a lot of things do work out of the box which do need tweeking
with the JDBC driver.

Best regards
Ivo Rossacher

Am Dienstag, 5. Dezember 2006 12.09 schrieb Adam Radlowski:
> I'm using very often OpenOffice to administrate databases (It has
> options, wchich are not present in pgadmin3).
> If I use JDBC connection and server don't requiers md5 passwords, I can
> edit and administrate the databases/tables via OpenOffice and JDBC. I
> can only read the tables. When server requiers md5 passwords I can't. Of
> course, I want to have possibility to edit tables via OpenOffice :-).
> Has anybody any idea, how to do this ?
> I'm using "postgresql-8.2-504.jdbc3.jar" and "jre1.5.0_06". Server 8.0.7
> compiled/using on FC3 or binary installation 8.0.6 on Win2003. I've
> tried older *.jar version with this same result. OpenOffice 2.0.3 or 1.4.1.
> Greetings
> Adam
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

The problem is resolved. OpenOffice doesn't edit tables without primary
key with any driver (I've tried JDBC,native OpenOffice, ODBC). But - the
primary key can't be ignored, when it is made on OID.
Greetings
Adam

Adam Radlowski wrote:

> I'm using very often OpenOffice to administrate databases (It has
> options, wchich are not present in pgadmin3).
> If I use JDBC connection and server don't requiers md5 passwords, I
> can edit and administrate the databases/tables via OpenOffice and
> JDBC. I can only read the tables. When server requiers md5 passwords I
> can't. Of course, I want to have possibility to edit tables via
> OpenOffice :-). Has anybody any idea, how to do this ?
> I'm using "postgresql-8.2-504.jdbc3.jar" and "jre1.5.0_06". Server
> 8.0.7 compiled/using on FC3 or binary installation 8.0.6 on Win2003.
> I've tried older *.jar version with this same result. OpenOffice 2.0.3
> or 1.4.1.
> Greetings
> Adam
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>