[CONJ-1070] getBlob on TEXT columns throw Exception Created: 2023-04-12  Updated: 2023-05-03  Resolved: 2023-04-12

Status: Closed
Project: MariaDB Connector/J
Component/s: 2.7 compatibility, MySQL compatibility
Affects Version/s: 3.0.3, 3.0.4, 3.0.5, 3.0.6, 3.0.7, 3.0.8, 3.0.9, 3.1.0, 3.0.10, 3.1.1, 3.1.2, 3.1.3
Fix Version/s: 3.1.4

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

When decoding text as blob, connector 3.x throw an exeption like "Data type MEDIUMBLOB (not binary) cannot be decoded as Blob."
Even If corresponding to JDBC specification, this is too restrictive:

  • in certain cases, it can make sense to use it with Blob in place of Clob
  • previous 2.x and MySQL connector permit it.

 Comments   
Comment by Diego Dupin [ 2023-04-12 ]

corrected with https://app.travis-ci.com/github/mariadb-corporation/mariadb-connector-j/builds/262219609

correction available on SNAPSHOT version: 

<repositories>
 
    <repository>
 
        <id>sonatype-nexus-snapshots</id>
 
        <name>Sonatype Nexus Snapshots</name>
 
        <url>https://oss.sonatype.org/content/repositories/snapshots</url>
 
    </repository>
 
</repositories>
 
 
 
<dependencies>
 
    <dependency>
 
        <groupId>org.mariadb.jdbc</groupId>
 
        <artifactId>mariadb-java-client</artifactId>
 
        <version>3.1.4-SNAPSHOT</version>
 
    </dependency>
 
</dependencies>

Generated at Thu Feb 08 03:20:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.