[Solved] PosgreSQL sdbc error during installation

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

[Solved] PosgreSQL sdbc error during installation

Postby sylcote26 » Tue Mar 15, 2011 4:24 am

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
sylcote26
 
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm

Re: PosgreSQL sdbc error during installation

Postby r4zoli » Thu Mar 17, 2011 10:28 am

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
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: PosgreSQL sdbc error during installation

Postby sylcote26 » Sun Mar 20, 2011 11:49 pm

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
sylcote26
 
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm

Re: PosgreSQL sdbc error during installation

Postby r4zoli » Mon Mar 21, 2011 8:28 am

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
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: PosgreSQL sdbc error during installation

Postby sylcote26 » Sun Jun 26, 2011 6:50 pm

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
sylcote26
 
Posts: 4
Joined: Wed Apr 14, 2010 4:45 pm


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 0 guests