glassfish
  1. glassfish
  2. GLASSFISH-191

The data type for BLOB and CLOB in the generated DDL is VARCHAR(255)

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 9.0pe
    • Fix Version/s: 9.0pe_dev
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      191

      Description

      9.0 beta build 32d.

      The table creation DDL generated in Java2DB mode for BLOB/CLOB testing is:
      CREATE TABLE DATATYPES (ID INTEGER NOT NULL, CHARACTERDATA CHAR(1),
      UTILDATEDATA TIMESTAMP, SHORTDATA SMALLINT, SQLDATEDATA TIMESTAMP, INTEGERDATA
      INTEGER, FLOATDATA FLOAT, BYTEDATA SMALLINT, TIMESTAMPDATA TIMESTAMP,
      BOOLEANDATA SMALLINT DEFAULT 0, BLOBDATA VARCHAR(255), LONGDATA INTEGER,
      CLOBDATA VARCHAR(255), PRIMARY KEY (ID))

      This causes the failure of inserting the blob/clob data to the table.

        Activity

        Hide
        marina vatkina added a comment -

        Assigned

        Show
        marina vatkina added a comment - Assigned
        Hide
        pramodgo added a comment -

        Have sent code for review

        Show
        pramodgo added a comment - Have sent code for review
        Hide
        pramodgo added a comment -

        Have checked in the code changes to resolve this issue.

        Show
        pramodgo added a comment - Have checked in the code changes to resolve this issue.

          People

          • Assignee:
            pramodgo
            Reporter:
            mzh777
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: