Not able to connect to oracle database using JDBC if password is having special characters

Question

I am trying to connect to oracle database using JDBC. following is the code:: ``` public class OraclePwdTest { static{ try { Class.forName("oracle.jdbc.OracleDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public static void main(String[] args) { // TODO Auto-generated method stub String ip ="192.168.20.145"; String sid = "oradg"; int port = 1521; String user = "sys"; String pwd = "s@novi123"; Connection conn = null; String url = "jdbc:oracle:thin:"+"(DESCRIPTION =" + "(ADDRESS_LIST =" + "(ADDRESS = (PROTOCOL = TCP)(HOST = "+ ip +")" + "(PORT = " + port + "))" + ")" + "(CONNECT_DATA = (SRVR=DEDICATED) " + "(SID = " + sid + "))" + ")"; java.util.Properties prop = new java.util.Properties (); prop.put ("user", user); prop.put ("password", pwd); prop.put ("internal_logon", "sysdba"); try { conn = DriverManager.getConnection(url,prop); System.out.println("Connected"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } ``` } If pa…

Accepted Answer

When special characters are there in username, password or connection string like `@`, `/` etc., we have to include it within double quoted, for example, if the password is `p@ssword` we connect in sqlplus as `username/"p@ssword"@database`

You can try the same in java by enclosing your password in double quotes using escape characters, try changing

```
String pwd = "s@novi123";
```

to

```
String pwd = "\"s@novi123\"";
```

I am not a java expert, just guessed the scape character should be `\` ;-)

Not able to connect to oracle database using JDBC if password is having special characters

Solution

Problem