<jdbc:initialize-database data-source="dataSource">
    <jdbc:script location="classpath:rubrica.sql" />
    <jdbc:script location="org/springframework/batch/core/schema-drop-hsqldb.sql" />
    <jdbc:script location="org/springframework/batch/core/schema-hsqldb.sql" />
</jdbc:initialize-database>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
    <property name="driverClassName" value="org.hsqldb.jdbc.JDBCDriver" />
    <property name="url" value="jdbc:hsqldb:file:C:UsersU390902Documentsworkspace-sts-3.8.4.RELEASEixpg0-statsloadersrcmainresourcesinputTestDataBase;user=sa;password=sa" />
</bean>

<job>
<step 1> Read a flat file and write it in the HSQL DB </step 1>
<step 2> Read a CSV file and join it with the HSQL DB</step 1>
</job>

INSERT INTO EMPLOYEE VALUES('123456','PIPPO','PLUTO')
COMMIT
/*C4*/SET SCHEMA PUBLIC
DISCONNECT
/*C5*/SET SCHEMA PUBLIC
DROP TABLE EMPLOYEE IF EXISTS
CREATE TABLE EMPLOYEE ( ID VARCHAR(6), FIRSTNAME VARCHAR(100), LASTNAME VARCHAR(100) )