};
}
@Before
public void setUp() throws Exception {
DriverManagerDataSource dataSource = new SingleConnectionDataSource(url, user, password, true);
dataSource.setDriverClassName(driverClass);
ds = dataSource;
JdbcTemplate jdbc = new JdbcTemplate(ds);
jdbc.execute("create table customer (id varchar(15) PRIMARY KEY, name varchar(10))");
jdbc.execute("insert into customer values('cust1','jstrachan')");