Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2451

Warnings about existing longvarchar columns being incompatible

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 2.2.2
    • None
    • jdbc
    • OpenSUSE 12.3

    Description

      OpenJPA in Geronimo 4 produces a lot of warnings like these:

      2013-11-12 08:46:27,414 WARN [Schema] Existing column "Description" on table "Project" is incompatible with the same column in the given schema definition. Existing column:
      Full Name: Project.Description
      Type: longvarchar
      Size: 65535
      Default: null
      Not Null: false
      Given column:
      Full Name: Project.Description
      Type: varchar
      Size: 255
      Default: null
      Not Null: false

      For ordinary varchar columns they can be avoided by specifying length in the @Column annotation, but for longvarchar it is more problematic. Since different databases have different sizes for these columns, there is no single correct value for the length attribute if you want a single EAR to be usable with different database servers.

      The workaround in Geronimo is to add the line
      log4j.logger.openjpa.jdbc.Schema=ERROR
      to the log4j properties, but that will of course suppress other warnings as well.

      One solution could be for OpenmJPA to log mismatching longvarchar, clob, etc, sizes with level DEBUG instead.

      Attachments

        Activity

          People

            Unassigned Unassigned
            gugrim Gunnar Grim
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: