Message-ID: <gh-pgjdbc-pgjdbc-3921-c3828868550@github.com>
From: "yamert89 (@yamert89)" <noreply+yamert89@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Sat, 31 Jan 2026 17:24:26 +0000
Subject: Re: [pgjdbc/pgjdbc] PR #3921: Support test.url.* properties in osgi tests
In-Reply-To: <gh-pgjdbc-pgjdbc-3921@github.com>
References: <gh-pgjdbc-pgjdbc-3921@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: yamert89
X-GitHub-Comment-Id: 3828868550
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3921
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/3921#issuecomment-3828868550
Content-Type: text/plain; charset=utf-8

@davecramer of course. 
This is my **build.local.properties**
```
test.url.PGHOST=localhost
test.url.PGPORT=7777
secondaryServer1=localhost
secondaryPort1=7778
secondaryServer2=localhost
secondaryPort2=7779
test.url.PGDBNAME=test
user=test
password=test
privilegedUser=postgres
privilegedPassword=
sspiusername=testsspi
preparethreshold=5
sslpassword=sslpwd
```
and  **docker-compose.yml**
```
services:
  pgdb:
    image: postgres:${PGV:-latest}
    ports:
      - 7777:5432
      - 7778:5433
      - 7779:5434
      ...
```

When I run the tests, I get:

```
FATAL: role "test" does not exist
org.postgresql.util.PSQLException: FATAL: role "test" does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2875)
	at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:3000)
	at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:235)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:344)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:57)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:290)
	at org.postgresql.Driver.makeConnection(Driver.java:448)
	at org.postgresql.Driver.connect(Driver.java:298)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:683)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230)
	at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:104)
	at org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:52)
	at org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:37)
	at org.postgresql.test.osgi.DataSourceFactoryTest.createXADataSource(DataSourceFactoryTest.java:96)
```
This happens because `DataSourceFactoryTest.getProperties()` drops any non-standard properties.