title: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Invalid Oracle URL specified
body: <p>I am getting this error when running my spring boot application. It is a CRUD API that I am trying to connect to my table data in SQL developer. I would really appreciate some help.</p>
  <p>Application Properties</p>
  <pre><code>spring.datasource.url = jdbc:oracle:DIP:@localhost:1521:orcl
  spring.datasource.username = DIP
  spring.datasource.password = DIP
  spring.datasource.driver-class-name = oracle.jdbc.driver.OracleDriver
  server.port = 8080
  </code></pre>
  <p>Code That Generated Exception</p>
  <pre><code>    private EmployeeDAO dao;
  @BeforeEach
  void setUp() throws Exception {
      DriverManagerDataSource dataSource = new DriverManagerDataSource();
      dataSource.setUrl(&quot;jdbc:oracle:DIP:@localhost:1521:orcl&quot;);
      dataSource.setUsername(&quot;DIP&quot;);
      dataSource.setPassword(&quot;DIP&quot;);
      dataSource.setDriverClassName(&quot;oracle.jdbc.driver.OracleDriver&quot;);
  
      dao = new EmployeeDAO(new JdbcTemplate(dataSource));
  }
  </code></pre>
  <p>Oracle Driver System Path Pom.xml</p>
  <pre><code>        &lt;dependency&gt;
          &lt;groupId&gt;com.oracle.database.jdbc&lt;/groupId&gt;
          &lt;artifactId&gt;ojdbc8&lt;/artifactId&gt;
          &lt;version&gt;2.3.0&lt;/version&gt;
          &lt;scope&gt;system&lt;/scope&gt;
          &lt;systemPath&gt;C:/ojdbc8.jar&lt;/systemPath&gt;
      &lt;/dependency&gt;
  </code></pre>