Page 1 of 1

[Solved] PosgreSQL sdbc error during installation

PostPosted: Tue Mar 15, 2011 4:24 am
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?

Re: PosgreSQL sdbc error during installation

PostPosted: Thu Mar 17, 2011 10:28 am
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.

Re: PosgreSQL sdbc error during installation

PostPosted: Sun Mar 20, 2011 11:49 pm
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.

Re: PosgreSQL sdbc error during installation

PostPosted: Mon Mar 21, 2011 8:28 am
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.

Re: PosgreSQL sdbc error during installation

PostPosted: Sun Jun 26, 2011 6:50 pm
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.