[Solved] PosgreSQL sdbc error during installation

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
sylcote26
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm

[Solved] PosgreSQL sdbc error during installation

Post by sylcote26 »

I have upgraded from 3.2.1 to 3.3.0 on Windows 7 and I have upgraded the sdbc extension to connect a Postgresql database server. In the extension list dialog box, this extension is not activated. When I try to activate it, this results in error.



Can someone help me?
Attachments
Error_installing_postgresql_sdbc.PNG
Last edited by sylcote26 on Sun Jun 26, 2011 6:57 pm, edited 2 times in total.
OpenOffice 3.3.0 on Windows 7 and also on Linux Slackware 13.1
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: PosgreSQL sdbc error during installation

Post by r4zoli »

I installed it without problem, try to remove, restart OOo, reinstall it.
Use other driver (ODBC or JDBC) to postresql connection,the sdbc driver provides read only tables, which is know bug.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
sylcote26
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm

Re: PosgreSQL sdbc error during installation

Post by sylcote26 »

Thank you, r4zoli.

It is not a viable solution to me to just have read-only tables. I have used sdbc on older version such as 3.2.1. I use this connection interface thinking that the communication is more native than JDBC or ODBC and fastest. Maybe I am wrong.

I have tried JDBC and have trouble with the existing forms/subforms links. Is it necessary to recreate my forms?

I will try to recreate one set this week. I will report my results.
OpenOffice 3.3.0 on Windows 7 and also on Linux Slackware 13.1
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: PosgreSQL sdbc error during installation

Post by r4zoli »

sylcote26 wrote: It is not a viable solution to me to just have read-only tables. I have used sdbc on older version such as 3.2.1. I use this connection interface thinking that the communication is more native than JDBC or ODBC and fastest. Maybe I am wrong.
The sdbc is a fastest connection, jdbc slower.
sylcote26 wrote:I have tried JDBC and have trouble with the existing forms/subforms links. Is it necessary to recreate my forms?
I think the forms must work in same way in all connections.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
sylcote26
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm

Re: PosgreSQL sdbc error during installation

Post by sylcote26 »

I have found why I was not able to work with subform when using JDBC. Just check the setting "Replace named params with '?' " in Edit/Database/Advanced Settings...

Effectively, the communication is more slower than SDBC that I have experimented in OO 3.2.1. Just hope that SDBC will be corrected soon for OO 3.3.
Attachments
Capture.PNG
OpenOffice 3.3.0 on Windows 7 and also on Linux Slackware 13.1
Post Reply