I'm submitting a potential issue
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
I'm submitting a potential issue
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