Issue 66539

Summary:	JDBC access should support connection parameters
Product:	Base	Reporter:	klute <klute>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.0.2
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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
<http://jdbc.postgresql.org/documentation/80/connect.html> 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 http://dba.openoffice.org/drivers/postgresql/index.html ?