title: Cannot connect to Oracle using SID
body: <p>I m having web application where i connect with oracle with spring
  my application is not working if i give SID in xml file</p>
  
  <p>xml file entry is</p>
  
  <pre><code>&lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
      destroy-method="close"&gt;
      &lt;property name="driverClass"&gt;&lt;value&gt;oracle.jdbc.driver.OracleDriver&lt;/value&gt; 
      &lt;/property&gt;
      &lt;property name="jdbcUrl"&gt;
          &lt;value&gt;jdbc:oracle:thin:@x.x.x.x:1521:XXX&lt;/value&gt;
      &lt;/property&gt;
      &lt;property name="user"&gt;
          &lt;value&gt;xx&lt;/value&gt;
      &lt;/property&gt;
      &lt;property name="password"&gt;
          &lt;value&gt;xx&lt;/value&gt;
      &lt;/property&gt;&lt;/bean&gt;
  </code></pre>
  
  <p></p>
  
  <p>Even i am unable to connect using Oracle SQL Developer with SID. but if i give service name it is working properly.</p>
  
  <p>Can you plz help me out.</p>