Forum Discussion

jonathon's avatar
jonathon
Contributor
5 years ago

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...
  • jonathon's avatar
    jonathon
    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

jonathon's avatar
jonathon
Contributor

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

richie's avatar
richie
Community Hero
5 years ago
Sorry i should of been clear.
Special chars yes....ive tested plenty of apps with special alpha chars in username/password for a db..e.g. ,£^ etc., but NOT reserved HTTP chars.

This will never work with reserved http chars because...well...theyre reserved and have specific meanings in a URL which is why theyre reserved.

If you think back to your previous experience you wont be able to think of a connection string that used reserved http chars.

Nice one fella,

Rich