Re: Schema name in Java EE app server datasource configuration?

That's what I'd normally do, however in this case I'm supposed to use data
source properties serverName, databaseName, portNumber instead of the URL
(see https://jdbc.postgresql.org/documentation/head/ds-cpds.html ) so it has
to be done differently (if there's a chance to specify it this way at all).

---------- Original Message ----------
From: pm(at)netcetera(dot)ch
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Sent: 22. 1. 2019 15:01:06
Subject: Re: Schema name in Java EE app server datasource configuration?
"Hello Petr

Have you tried adding currentSchema=SCHEMA_NAME to the connection URL
[1]? either prefixed by ? or & depending on whether it is the first
query parameter.

[1] https://jdbc.postgresql.org/documentation/head/connect.html

Cheers
Philippe

On 22.01.19 14:08, hostalp(at)post(dot)cz wrote:
> Hello,
> I'm trying to configure a PostgreSQL data source at WebSphere
> Application Server.
> I defined a custom JDBC provider type and data source based on the
> following description:
> https://jdbc.postgresql.org/documentation/head/ds-cpds.html
>
> Now I need to specify a schema name in addition to all of that, but that
> isn't documented there. I know there's a connection property
> currentSchema, however is it possible to configure it for the JEE data
> source? I may try some trial & error attempts to configure it somehow,
> but perhaps you know how to do it properly right from the start?
>
> And in such case it would be useful to add it to the documentation.
>
> Best regards.
> Petr

"