Message-ID: <gh-pgjdbc-pgjdbc-2694@github.com>
From: "ivostoykov (@ivostoykov)" <noreply+ivostoykov@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 05 Dec 2022 22:21:04 +0000
Subject: [pgjdbc/pgjdbc] issue #2694: the url is invalid
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Id: 889184
X-GitHub-Author-Login: ivostoykov
X-GitHub-Issue: 2694
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2694
Content-Type: text/plain; charset=utf-8

**I'm submitting a potential issue**

  <!--- What kind of an issue is this? Put an `x` in all the boxes that apply: -->
- [x] bug report
- [ ] feature request
    

**Describe the issue**
Trying to connect the free db hosting located on db.bit.io using a SQL IDE client.  I've got a connection string error.

**Driver Version?**  42.5.1

**Java Version?** 11.0.11+9-Ubuntu-0ubuntu2.18.04

**OS Version?** Linux Ubuntu 22.04 LTS

**PostgreSQL Version?** 14

**To Reproduce**
Using a connection string URL like postgresql://aaa:complex_password_with_special_symbols@db.bit.io/aaa/bbb
**aaa/bbb** is the name of the database. At the same time **aaa** is the username as well

**Expected behaviour**
to connect aaa/bbb databse
But got an error "_According to the driver "PostgreSQL", the URL "postgresql://aaa:complex_password_with_special_symbols@db.bit.io/aaa/bbb" is invalid._"

This text of the error is reported by the Squirrel SQL client I'm using to connect
Tried to set the driver properties individually, bypassing the query string parsing. But the connection still fails.
No problem to connect using **pg** library in NodeJs with the same credentials. 

**Logs**
no PostgreSQL logs are available