I am working on a simple spring application where I am trying to create and insert data into a database table. I have the create table and insert statements in a data.sql file in the classpath. The code does access this file, but when I connect to the database, I do not find the tables in there. My hunch is the db.properties file that I am using (also in the classpath) is not being accessed by the program. I am using a H2 database and am accessing it via the H2 console. What details am I missing here? How do I link up my spring project to the local database? This is my application context

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schem...g-jdbc-3.0.xsd
Index of /schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

<jdbc:embedded-database id="dataSource" type="H2">
<jdbc:script location="classpath:schema.sql" />
<jdbc:script location="classpath:data.sql" />

<!-- <start id="bean.jdbcTemplate" /> -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.simple.Simple JdbcTemplate">
<constructor-arg ref="dataSource" />

<bean id="jdbcSpitter" class="com.habuma.spitter.persistence.JdbcSpitterD ao">
<property name="jdbcTemplate" ref="jdbcTemplate" />

<!-- <end id="bean.jdbcTemplate" /> -->