title: Getting MappingException when reading TINYINT value from H2 database as boolean/Boolean
body: <p>I am using R2DBC H2 for integration testing my reactive application (which is based on Spring Webflux , Java).</p>
  <p>Versions</p>
  <ul>
  <li>Driver: io.r2dbc:r2dbc-h2:0.8.4.RELEASE (Spring boot 2.3.2.RELEASE)</li>
  <li>Java: 11</li>
  <li>OS: Mac</li>
  </ul>
  <p>I have a table defined like this:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE `prep_task` (
    `id` SERIAL,
    `external_id` VARCHAR(45) NOT NULL,
    `name` VARCHAR(45) NOT NULL,
    `description` VARCHAR(100) NULL,
    `is_active` TINYINT,
    PRIMARY KEY (`id`)
  );
  </code></pre>
  <p>And corresponding entity:</p>
  <pre class="lang-java prettyprint-override"><code>@Table(&quot;prep_task&quot;)
  public class PrepTaskEntity implements Persistable&lt;Long&gt; {
    @Id
    @Column(&quot;id&quot;)
    private Long id;
  
    @Column(&quot;external_id&quot;)
    private String externalId;
  
    @Column(&quot;name&quot;)
    private String name;
  
    @Column(&quot;description&quot;)
    private String description;
  
    @Column(&quot;is_active&quot;)
    private boolean isActive;
  
    public Long getId() {
      return id;
    }
  
    public void setId(Long id) {
      this.id = id;
    }
  
    public String getExternalId() {
      return externalId;
    }
  
    public void setExternalId(String externalId) {
      this.externalId = externalId;
    }
  
    public String getName() {
      return name;
    }
  
    public void setName(String name) {
      this.name = name;
    }
  
    public String getDescription() {
      return description;
    }
  
    public void setDescription(String description) {
      this.description = description;
    }
  
    public boolean isActive() {
      return isActive;
    }
  
    public void setActive(boolean active) {
      isActive = active;
    }
  
    @Override
    public boolean isNew() {
      return id == null;
    }
  
  
  }
  </code></pre>
  <p><strong>No issue when saving <code>PrepTaskEntity</code> but when trying to read, getting the following error</strong>:</p>
  <pre><code>org.springframework.data.mapping.MappingException: Could not read property @org.springframework.data.relational.core.mapping.Column(value=&quot;is_active&quot;)private java.lang.Boolean com.example.demosvc.persistence.entities.PrepTaskEntity.isActive from result set!
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.readFrom(MappingR2dbcConverter.java:172) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: 
  Error has been observed at the following site(s):
      |_ checkpoint ⇢ Handler com.example.demosvc.controllers.PrepTaskController#getPrepTasksForGivenBU(String) [DispatcherHandler]
      |_ checkpoint ⇢ com.example.demosvc.filters.TenancyContextFilter [DefaultWebFilterChain]
      |_ checkpoint ⇢ HTTP GET &quot;/sites/BU-002/prepTasks&quot; [ExceptionHandlingWebHandler]
  Stack trace:
          at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.readFrom(MappingR2dbcConverter.java:172) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
          at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.read(MappingR2dbcConverter.java:133) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
          at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.read(MappingR2dbcConverter.java:116) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
          at org.springframework.data.r2dbc.convert.EntityRowMapper.apply(EntityRowMapper.java:46) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
          at org.springframework.data.r2dbc.convert.EntityRowMapper.apply(EntityRowMapper.java:29) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
          at io.r2dbc.h2.H2Result.lambda$map$0(H2Result.java:67) ~[r2dbc-h2-0.8.4.RELEASE.jar:0.8.4.RELEASE]
          at reactor.core.publisher.FluxMap$MapSubscriber.onNext(FluxMap.java:100) ~[reactor-core-3.3.8.RELEASE.jar:3.3.8.RELEASE]
          at reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:73) ~[reactor-core-3.3.8.RELEASE.jar:3.3.8.RELEASE]
  ...
  Caused by: org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.Byte] to type [java.lang.Boolean]
      at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:321) ~[spring-core-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:194) ~[spring-core-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:174) ~[spring-core-5.2.8.RELEASE.jar:5.2.8.RELEASE]
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.getPotentiallyConvertedSimpleRead(MappingR2dbcConverter.java:263) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.readValue(MappingR2dbcConverter.java:187) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.readFrom(MappingR2dbcConverter.java:169) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.read(MappingR2dbcConverter.java:133) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.MappingR2dbcConverter.read(MappingR2dbcConverter.java:116) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.EntityRowMapper.apply(EntityRowMapper.java:46) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at org.springframework.data.r2dbc.convert.EntityRowMapper.apply(EntityRowMapper.java:29) ~[spring-data-r2dbc-1.1.2.RELEASE.jar:1.1.2.RELEASE]
      at io.r2dbc.h2.H2Result.lambda$map$0(H2Result.java:67) ~[r2dbc-h2-0.8.4.RELEASE.jar:0.8.4.RELEASE]
  </code></pre>
  <p>Just FYI I am using MySQL as connection mode for H2.</p>
  <pre class="lang-java prettyprint-override"><code>@Configuration
  @Profile(Application.Profiles.INTEGRATION_TEST)
  public class H2ConnectionConfig extends AbstractR2dbcConfiguration {
  
    private final R2dbcConfigProperties r2dbcConfigProperties;
  
    @Autowired
    public H2ConnectionConfig(R2dbcConfigProperties r2dbcConfigProperties) {
      this.r2dbcConfigProperties = r2dbcConfigProperties;
    }
  
    @Override
    @Bean
    public ConnectionFactory connectionFactory() {
      RoutingConnectionFactory connectionFactory = new RoutingConnectionFactory();
      Map&lt;String, ConnectionFactory&gt; factories = new HashMap&lt;&gt;();
      H2ConnectionConfiguration.Builder configurationBuilder = H2ConnectionConfiguration.builder()
          .property(H2ConnectionOption.MODE, &quot;MySQL&quot;)
          .property(H2ConnectionOption.DB_CLOSE_DELAY, &quot;-1&quot;)
          .property(H2ConnectionOption.DB_CLOSE_ON_EXIT, &quot;false&quot;);
      for (String tenant : r2dbcConfigProperties.getTenants()) {
        String databaseName = r2dbcConfigProperties.getDbPrefix() + tenant;
        factories.put(tenant, new H2ConnectionFactory(configurationBuilder.inMemory(databaseName).build()));
      }
      connectionFactory.setTargetConnectionFactories(factories);
      connectionFactory.setDefaultTargetConnectionFactory(factories.get(&quot;default&quot;));
      return connectionFactory;
    }
  
  }
  </code></pre>