jdbc url is wrongly parsed

[fhrzn]

Describe the bug
In the pgjdbc.py there is a logic to parse sqlalchemy generated url to the one expected by jdbc. In the current implementation it causing the java.net.java.net.UnknownHostException error.

To Reproduce
Steps to reproduce the behavior:

1. Init sqlalchemy engine by putting standard sqlalchemy url or follow the given example
2. Run the code
3. See error

Expected behavior
The expected behavior should be connected successfully to the database.

Screenshots

Desktop (please complete the following information):

• OS: macOS Ventura
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

[fhrzn]

For manual workaround just insert url as jdbc expected format.
jdbc:postgresql://example.com:1521/db

Example in sqlalchemy:
engine = create_engine(f'jdbcapi+pgjdbc://{uname}:{pwd}@{host}:{port}/{dbname}')

[borgle]

@henrykp If your "uname" or "pwd" contains special characters, use urllib quote like this:

from urllib.parse import quote
uname=quote("Amy#clusterid")
pwd=quote("secert@123")

[daneshpatel]

https://github.com/daneshpatel/sqlalchemy-jdbcapi/releases/tag/v2.2.1