Connecting to Database using JDBC template (Spring)

[Nimu Chox]

         

I am getting an error "Top level element is not comepleted"  in this line: bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

Please see the XML code (I have not set all the JDBC properties yet):

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    <!--<bean/> definitions here-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> ---------"Top level element is not completed"
        <property name= "driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
    </bean>
</beans>

[Anayonkar Shivalkar]

Hi Nimu Chox,

Welcome to CodeRanch!

Please TellTheDetails. What this xml file is about? Are you deploying any web application? Is it servlet/jsp or ejb? Either way, it does not seem to be 'beginning java' question.

We have dedicated forums for servlet, jsp, jdbc and ejb. You can request moderator to move this topic to appropriate forum.

[Nimu Chox]

Aim: In this XML file, I am configuring the data source, I will use the database instance in class "CityDaoImpl" - please see the code


I am getting an error "Top level element is not comepleted/Valid XML must have a root tag" in this line:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    <!--<bean/> definitions here-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name= "driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
    </bean>
</beans>



CityDaoImpl

package com.springtry;

import com.sun.org.apache.bcel.internal.generic.Select;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.security.ldap.userdetails.Person;


public class CityDaoImpl implements CityDao{



    private JdbcTemplate jdbcTemplate;

    @Override
    public void CreateCity(City city) {
        String sql= "insert into city" +
                "(CountryCode, District, Name, Population) VALUES (?, ?, ?)";
        Object params= new Object[]{city.getCountryCode(), city.getDistrict(), city.getName(), city.getPopulation()};
        this.jdbcTemplate.update(sql,params);
        System.out.println("City added successfully....");
    }

    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
}

[Rob Spoor]

Recreated at http://www.coderanch.com/t/572956/JDBC/java/Connecting-Database-JDBC-template-Spring.