spring oracle a valid format is: "host:port:sid"

Question

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
     <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521：XE"/>
<property name="username" value="system"/>
<property name="password" value="oracle"/> 
     <property name="maxActive"> 
        <value>0</value> 
       </property> 
       <property name="maxIdle"> 
        <value>30</value> 
       </property> 
       <property name="maxWait"> 
        <value>10000</value> 
       </property> 
    </bean>

Answer 1

注意url的书写，最好拿sqldeveloper 测下