Oracle data-source configuration for Spring

Question

In the Spring framework, how is an Oracle data-source configured?

Answer 1

In the context.xml file:

<bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource">
    <property name="dataSourceName" value="ds"/>
    <property name="URL" value="jdbc:oracle:thin:@<hostname>:<port_num>:<SID>"/>
    <property name="user" value="dummy_user"/>
    <property name="password" value="dummy_pwd"/>
</bean>

Example of URL: jdbc:oracle:thin:@abc.def.ghi.com:1234:TEAM4