jonathon
5 years agoContributor
JDBC connections string with special chars
I am migrating a project and trying to connect a datasource, the password for this system has a colon in it and I believe this is breaking the url, because a regular alpha password returns an invalid...
- 5 years ago
Yeah, I'm not really sure I agree with this. The URL scheme is one thing, I've worked with plenty of Oracle DBs with special chars and multiple systems easily allow connection via a url string that has special chars. For instance my PyCharm connects easily.
It seems the answer is that you need to double quote the password to escape the characters in the datasource manager , as in:
"mypassword:@"
rather than mypassword:@
Thanks
Jonathon