Uploaded image for project: 'Hibernate ORM'
  1. HHH-10473

Test NationalizedLobFieldTest.testNationalization fails on some databases that don't support nclob type

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.0.7
    • Fix Version/s: 5.0.8
    • Component/s: testsuite
    • Labels:
      None
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      test NationalizedLobFieldTest#testNationalization fails on DB2, MariaDB, MySQL, PostgreSql and Sybase

      DB2:
      jdbc driver doesn't support getNClob method

      Caused by: com.ibm.db2.jcc.am.SqlFeatureNotSupportedException: [jcc][t4][10181][12264][4.19.26] Method getNClob is not supported. ERRORCODE=-4450, SQLSTATE=0A504
      

      MariaDB:

      16:53:10,779 ERROR SchemaExport:483 - HHH000389: Unsuccessful: create table my_entity (id bigint not null, state nclob, primary key (id)) ENGINE=InnoDB
      16:53:10,779 ERROR SchemaExport:484 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'nclob,
              primary key (id)
          ) ENGINE=InnoDB' at line 3
      

      Also MariaDB Connector doesn't support getNClob: https://github.com/MariaDB/mariadb-connector-j/blob/master/src/main/java/org/mariadb/jdbc/MariaDbResultSet.java#L3245

      MySQL:
      the same as MariaDB

      PostgreSQL:
      PostgreSQL hasn't NCLOB/CLOB types, but is has TEXT

      17:11:23,253 ERROR SchemaExport:483 - HHH000389: Unsuccessful: create table my_entity (id int8 not null, state nclob, primary key (id))
      17:11:23,253 ERROR SchemaExport:484 - ERROR: type "nclob" does not exist
      

      Sybase:

      17:09:36,546 ERROR SchemaExport:483 - HHH000389: Unsuccessful: create table my_entity (id bigint not null, state nclob null, primary key (id)) lock datarows
      17:09:36,546 ERROR SchemaExport:484 - Can't find type 'nclob'.
      

      also JDBC driver doesn't support getNClob

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: