Bug9Test.java

package com.googlecode.sqlsheet;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import org.junit.Assert;
import org.junit.Test;

/**
 * @author Klaus Hauschild
 */
public class Bug9Test {

  @Test
  public void testWithoutStreaming() throws Exception {
    Class.forName("com.googlecode.sqlsheet.Driver");
    final Connection connection = DriverManager.getConnection("jdbc:xls:file:"
        + ClassLoader.getSystemResource("bug9.xlsx").getFile() + "?readStreaming=false");
    final Statement statement = connection.createStatement();
    final ResultSet resultSet = statement.executeQuery("SELECT * FROM bug9");
    Assert.assertEquals(true, resultSet.next());
    Assert.assertEquals("9", resultSet.getString("BUG9"));
    connection.close();
  }

  @Test
  public void testWithStreaming() throws Exception {
    Class.forName("com.googlecode.sqlsheet.Driver");
    final Connection connection = DriverManager.getConnection("jdbc:xls:file:"
        + ClassLoader.getSystemResource("bug9.xlsx").getFile() + "?readStreaming=true");
    final Statement statement = connection.createStatement();
    final ResultSet resultSet = statement.executeQuery("SELECT * FROM bug9");
    Assert.assertEquals(true, resultSet.next());
    Assert.assertEquals("9", resultSet.getString("BUG9"));
    connection.close();
  }

}