Forum Discussion

nkdogra90's avatar
nkdogra90
Occasional Contributor
5 years ago

Spacial Characters in JDBC STEP in password

Not able to connect with SQL using JDBC step as the password contains the below special char:- ( ) { } password Example:- INV-Q%+g@a>Az}q{R(axis?H6e#
Assertions
Automation Environments
Data-Driven Testing
Editors
JDBC
Reporting
REST
Scripting
SOAP
  • richie's avatar
    richie
    5 years ago
    Hi nkdogra90

    You say youre using jdbc connection string to connect to SQL DB, but all relational database management systems use SQL.
    What is the vendor.....Oracle? MS SQL SERVER, IBM DB2? From what ive read trying to escape may differ between vendors. They all use ANSI standard SQL, but they all include propietary differences.

    I couldnt see the embedded image at all to indicate what the error response was. Could you please paste in the error response message if you answer this message? Just remove the hostname details (no one will be able to hack without that) but include password when you post the error....i need to see the whole error text please if possible.

    Ta

    Rich
richie's avatar
richie
Community Hero
5 years ago
Hi nkdogra90

What RDBMS are you trying to connect to? Sqlserver? Oracle? Etc.
I "think" they could use different escape chars depending on the db youre connecting to.

I know oracle uses \ to escape a special character and ive seen contradictory info around if your password includes reserved http and sql chars.

As Rao said....you can either change the password but you might be able to escape the special chars in the password.

So, you need to escape each special character by inserting a '\' before each instance of special char in your password.

If your password was 'pa((word' instead use 'pa\(\(word'

Cheers,

Rich
  • nkdogra90's avatar
    nkdogra90
    Occasional Contributor
    5 years ago

    Its not working, I have already tried.

     

     

    • nkdogra90's avatar
      nkdogra90
      Occasional Contributor
      5 years ago

      I am using SQL DB and trying to connect with the help of connection string from parameters.

      • richie's avatar
        richie
        Community Hero
        5 years ago
        Hi nkdogra90

        You say youre using jdbc connection string to connect to SQL DB, but all relational database management systems use SQL.
        What is the vendor.....Oracle? MS SQL SERVER, IBM DB2? From what ive read trying to escape may differ between vendors. They all use ANSI standard SQL, but they all include propietary differences.

        I couldnt see the embedded image at all to indicate what the error response was. Could you please paste in the error response message if you answer this message? Just remove the hostname details (no one will be able to hack without that) but include password when you post the error....i need to see the whole error text please if possible.

        Ta

        Rich