Monday, 7 May 2012

link to configuring jdbc.properties for different DB's

configure a dataSource in tomcat server

This is the dataSouce bean:
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
      <property name="jndiName" value="java:comp/env/ig/jdbc/rtfdatasource"/>
      <property name="resourceRef" value="true" />
     </bean>

change the context.xml file which looks like:

<Loader loaderClass="org.springframework.instrument.classloading.tomcat.TomcatInstrumentableClassLoader" />

<Resource name="ig/jdbc/rtfdatasource" auth="Container" type="javax.sql.DataSource" username="rtf_uat" password="************" driverClassName="oracle.jdbc.OracleDriver"
             url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vrdevora003.iggroup.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=RTF.DEV.IGGROUP.LOCAL)))" maxActive="20" maxIdle="2" minIdle="1" initialSize="2" />