title: ORA-00933: SQL command not properly ended In Spring batch Item Writer
body: <p>I am writing one spring batch based application in which i have to write a consolidated xml file data into multiple tables of database.</p>
  
  <pre><code>bean id="mysqlItemWriter"
      class="org.springframework.batch.item.database.JdbcBatchItemWriter"&gt;
      &lt;property name="dataSource" ref="dataSource" /&gt;
      &lt;property name="sql"&gt;
        &lt;value&gt;
  
               &lt;![CDATA[  
                INSERT INTO LEASE (LEASE_ID, CONTRACT_TYPE, CONTRACT_NUMBER, LEASE_AMOUNT, DESCRIPTION, CREATE_DATE, REGISTER_DATE)
             VALUES ( :leaseId, :contractType, :contactNumber, :leaseAmount, :description, :leaseCreateDate, :leaseUpdateDate)
  
                    INSERT INTO CUSTOMER  (CUSTOMER_ID ,FIRST_NAME,  LAST_NAME,  SURNAME, CUSTOMER_NUMBER, RECORD_CODE,
               SOURCE_SYSTEM,  BIRTH_DATE,CREATE_DATE, UPDATE_DATE,ADDRESS,STREET,HOUSE_NUMBER,
               STATE,  POSTAL_CODE,  COUNTRY_CODE )
                VALUES ( :customerId , :firstname, :lastName ,:surname, :customerNumber, :recordCode, :SourceSystem,
                :birthDate, :leaseCreateDate, :leaseUpdateDate, :address, :houseNumber, :city, :state, :postalcode,
                :countryCode)
  
              ]]&gt;
            &lt;/value&gt;
  </code></pre>
  
  <p>In the above code when only one SQL statement is there it is working fine but for two insert statements it is not working fine. It is giving the error as 
      "ORA-00933: SQL command not properly ended" .
  When i am inserting ; after first insert statement it is showing the same error
  I am not able to resolve this..</p>