title: Database name containd dot in jdbc url spring boot
body: <p>Dear all I am in the unfortunate sitution to connect to an sqlserver 2005 databae that was provided to me and contains o dot (.)</p>
  
  <p>I have setup a configuration for spring boot like</p>
  
  <pre><code>@Configuration
  public class CustomConfig {
  
  @Bean
  @Primary
  public DataSource dataSource() {
      return DataSourceBuilder
          .create()
          .username("myuname")
          .password("mypass")
          .url("jdbc:sqlserver://10.10.10.10:1433;databaseName=REALLY_BAD_NAME_V3.5;")
          .driverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
          .build();
    }
  
  }
  </code></pre>
  
  <p>And of course I get an exception stating <code>com.microsoft.sqlserver.jdbc.SQLServerException: Database '5' does not exist. Make sure that the name is entered correctly.</code></p>
  
  <p>I have tried in vain the following</p>
  
  <p><code>.url("jdbc:sqlserver://10.10.10.10:1433;databaseName={REALLY_BAD_NAME_V3.5};")</code></p>
  
  <p>that gives the same error and</p>
  
  <p><code>.url("jdbc:sqlserver://10.10.10.10:1433;databaseName=REALLY_BAD_NAME_V3{.}5;")</code></p>
  
  <p>And gives a malformed url exception after reading <a href="https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.90%29.aspx" rel="nofollow">these instructions</a>.</p>
  
  <p>Any ideas? </p>