Problem with special character "_" in datasource password.

[khensel]

I have been having this issue lately and it may very well be a bug.  If there is another discussion on this, I haven't seen it.

I have an oracle datasource configured and there are two users that I use.  One user has a password that contains a dollar sign and it works just fine.

The other user has a password that contains underscore (_) and when I try to login using it, there is nothing in the log at all.  It simply dies.  I replaced the password with "xxxxx" and got a response in the log:

Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

This indicates to me that the password with "_" is causing a problem.  I am having the DBAs change the password to get rid of the underscore.  Until then, I'm going to assume it causes a problem in the configuration.  I am using jboss-as-7.1.3.Final built from source.

Any response would be appreciated.  if this is a not a known bug, then a ticket may need to be opened.  I'll put more information here when the DBAs reset the password.

Thanks, Ken Hensel

[jaysensharma]

Oracle password rules:   http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm  
In the above link see the "BY password" para

Are you using Oracle 11g ?    as the following link says "Pre Oracle 11g"  ==>   Include symbols (pre-Oracle Database 11g allows "_", "$" and "#")

http://www.oracle.com/technetwork/database/security/secure-passwords-082531.html

[khensel]

This apparently wasn't a password problem.  The DBA changed the password and it still doesn't work.  He sees nothing on his side trying to get through the firewall.  I also can't connect using the same userid on the QA side.

I think it may be a server config or SELinux issue on my side. 

This discussion can probably be disregarded, but I'll leave it open until I get an answer from our unix server people.

K