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: [email protected]
To: [email protected]
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, [email protected] 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 


"