Spring application connecting to Database

Any one tell me how to connect to database us开发者_运维知识库ing spring application.

---

Use Hibernate as ORM tool, and use Spring ORM support that would be a good design.

See also :

• Object Relational Mapping (ORM) data access
• Sample application

---

Check out Spring JDBC and the JdbcTemplate which is probably the fastest and simplest route.

Agreed with above to look at an ORM solution for anything beyond the basics.

---

First You have to make enteries for Data Source in application context.xml.

Then we have to make a entry in context.xml and we have to provide the database credentials and location in context.xml

I am attaching both the files of my project.

Hope it may help you.

Code For Application Context.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context">

        <bean id="messageSource"
         class="org.springframework.context.support.ResourceBundleMessageSource">
                <property name="basenames">
                        <list>
                                <value>report/cobReports_message</value>
                        </list>
                </property>
        </bean>

        <context:component-scan
                base-package="com.jpmc.am.architecture.emailaddrutil, com.jpmc.am.architecture.cob" />

        <bean id="multipartResolver"
         class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
                <property name="maxUploadSize" value="200000" />
        </bean>


        <bean id="sqlMapClientTemplate" 
         class="org.springframework.orm.ibatis.SqlMapClientTemplate">
                <property name="sqlMapClient" ref="sqlMapClient" />
        </bean>

        <bean id="sqlMapClient" 
         class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
                <property name="configLocation"
                 value="classpath:sqlMap/cobSqlMapConfig.xml" />
                <property name="dataSource" ref="cobDataSource" />
                <property name="useTransactionAwareDataSource" value="true" />
                <property name="sqlMapClientProperties">
                 <value>COB_SCHEMA=CLTAPPMGR //////// Database Schema Name</value>
                </property>
        </bean>

        /// Data Source Name
        <bean id="cobDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
          <property name="jndiName" value="java:comp/env/jdbc/cob" />
        </bean>
</beans>

Code For Context.xml

<Context>

 <Resource name="jdbc/cob" auth="Container" type="javax.sql.DataSource" 
 factory="org.apache.commons.dbcp.BasicDataSourceFactory"
 driverClassName="oracle.jdbc.driver.OracleDriver"
 url="database location:databasename"
 username="username"
 password="password"
 />




</Context>