Issue 66539 - JDBC access should support connection parameters
Summary: JDBC access should support connection parameters
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-06-18 22:34 UTC by klute
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description klute 2006-06-18 22:34:10 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
<> for documentation and
an example. The current GUI does not permit to enter additional parameters.
Comment 1 christoph.lukasiak 2006-06-19 12:33:48 UTC
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
Comment 2 klute 2006-06-19 12:50:42 UTC
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.
Comment 3 Frank Schönheit 2006-06-19 13:10:50 UTC
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 ....
Comment 4 klute 2006-06-19 13:27:59 UTC
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.
Comment 5 Frank Schönheit 2006-06-19 13:39:30 UTC
jdbc:postgresql://localhost/mydatabase;ssl=true would do, IIRC
Comment 6 klute 2006-06-19 13:46:04 UTC
No, it doesn't work. The JDBC driver want to open database "mydatabase;ssl=true"
without SSL instead of "mydatabase" with SSL. :-(
Comment 7 klute 2006-06-19 14:04:12 UTC
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.
Comment 8 Mechtilde 2009-07-19 18:22:10 UTC
does it works with the native pgsql driver?
Comment 9 klute 2009-07-19 18:34:03 UTC
I don't understand what you consider to be the "native" PostgreSQL driver and I
don't know what you mean by "it".
Comment 10 Mechtilde 2009-09-30 09:49:18 UTC
@ klute

you know ?