Can't connect to Oracle DB with a special character in pwd

General Discussion
1

Yes, i’m running from the command line. I did try single quotes, double quotes around the pwd, connection still fails if the pwd has special character. If it does not, it works ok. I’m running windows 7. per company security policy, the pwd needs to contain a special characters, and it becomes tricky.

2

The problem is with the windows command line. when running liquibase using .jar file, it works fine. :slight_smile:

 

Thanks for your help, Nathan.

3

Liquibase should just be passing it as it gets it to oracle. Are you running from the command prompt and need to quote the value so the shell doesn’t do strange things with it?

Nathan

4

I can’t connect to Oracle DB using Liquibase using a user with pwd that has a special character. In this case “!” in the pwd. Using different account with regular pwd, it works ok.

 

I can’t seem to get around the special character. Any idea how to resolve it?

 

I have Oracle client: 11.2.0 and jdk1.7.0 installed on my machine.

 

Thanks!

Cait

5

You could try setting the password in a properties file and passing it with the --defaultsFile=YOUR_FILE.properties parameter. Does that help?

Nathan

6

I created https://liquibase.jira.com/browse/CORE-1609 to track the issue


Nathan