Oracle data-source configuration for Spring

oracle spring datasource
mauryat picture mauryat · Nov 14, 2012 · Viewed 54.1k times · Source

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

Answer

mauryat picture mauryat · Nov 14, 2012

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

Related questions

No more data to read from socket error

We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error. Caused by: java.sql.SQLRecoverableException: No more data to …

Read More
SQL state [99999]; error code [17004]; Invalid column type: 1111 With Spring SimpleJdbcCall

Hi All I am using spring simple JDBC template to call the oracle procedure the below are my code. The procedure create or replace PROCEDURE get_all_system_users( pi_client_code IN VARCHAR2, po_system_users OUT T_SYSTEM_…

Read More
Spring JDBC Could not load JDBC driver class [oracle.jdbc.driver.OracleDriver]

I wonder if any one could help me with this. I encountered an issue when I tried writing code with Spring JDBC. When I ran the server, I got the message like I mentioned in the title. I have google …

Read More