Apache OpenOffice (AOO) Bugzilla – Issue 66539
JDBC access should support connection parameters
Last modified: 2013-08-07 15:45:17 UTC
When connecting to a database via JDBC it should be possible to specify arbitrary parameters in addition to username and passwort. This is particularly needed if you want to connect to a PostgreSQL database via SSL - see <http://jdbc.postgresql.org/documentation/80/connect.html> for documentation and an example. The current GUI does not permit to enter additional parameters.
you can specify several parameters in menue: 'edit/database/advanced settings ..' but especially for postgres (not only) this area could be improved => send further to the requirements team
Yes, but that dialog does not allow for arbitrary name/value pairs. For example, in order to establish an SSL connection the PostgreSQL JDBC driver wants to see a property named "ssl" with a value of "true". Other applications might have other needs and JDBC drivers might require any other unforseeable property names and values. Thus I'd like to see an extension of that dialog allowing to type such name/value pairs, e.g. a two-column table. This would be a generic solution for the power user and wouldn't exclude anything for comfortable.
can't you just append those additional name/value pairs to the "Datasource URL"? If I'm not completely mistaken, this should work. If not, I'd consider it a bug ....
How would I have to do that? How should my URL look like if it now reads "jdbc:postgresql://localhost/mydatabase"? If appending some string to the URL would help, I'd be happy, because I could use it right now. But I'd still regard it totally unintuitive and not suited for Joe User.
jdbc:postgresql://localhost/mydatabase;ssl=true would do, IIRC
No, it doesn't work. The JDBC driver want to open database "mydatabase;ssl=true" without SSL instead of "mydatabase" with SSL. :-(
Ha, I've got it: jdbc:postgresql://localhost/mydatabase?ssl=true does the trick. Further parameters have to be separated by a '&'. However, still I think some GUI support would be nice.
does it works with the native pgsql driver?
I don't understand what you consider to be the "native" PostgreSQL driver and I don't know what you mean by "it".
@ klute you know http://dba.openoffice.org/drivers/postgresql/index.html ?