OpenJPA
  1. OpenJPA
  2. OPENJPA-594

Incorrect schema separator used for Informix tables

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.1, 1.0.2
    • Fix Version/s: 1.0.4, 1.1.0, 1.2.0
    • Component/s: jdbc
    • Labels:
      None

      Description

      With Informix IDS 9.4 (or 10.0), when a schema is specified in the table annotation or in the openjpa.jdbc.schema property, a SQL for CREATE TABLE with invalid syntax is generated:

      CREATE TABLE MYSCHEMA:MYTABLE (...);

      The correct separator between the schema and the table is "dot".

      1. patch-594.txt
        0.9 kB
        Dinkar Rao
      2. OpenJPA_1.0.x_OPENJPA-594.patch
        0.7 kB
        Jody Grassel

        Activity

        Hide
        Jody Grassel added a comment -

        Built a version of the patch for OPENJPA-594 for 1.0.x

        Show
        Jody Grassel added a comment - Built a version of the patch for OPENJPA-594 for 1.0.x
        Hide
        Patrick Linskey added a comment -

        Applied to 1.1.x branch.

        Show
        Patrick Linskey added a comment - Applied to 1.1.x branch.
        Hide
        Pinaki Poddar added a comment -

        The properties of a database dictionary are highly configurable and hence the following persistence.xml configuration may attain the the same effect without any code change

        <property name="openjpa.jdbc.DBDictionary" value="informix(CatalogSeparator='.'")/>

        Show
        Pinaki Poddar added a comment - The properties of a database dictionary are highly configurable and hence the following persistence.xml configuration may attain the the same effect without any code change <property name="openjpa.jdbc.DBDictionary" value="informix(CatalogSeparator='.'")/>
        Hide
        Dinkar Rao added a comment -

        In this patch, I took out the override for catalogSeparator, so it will default to "dot".

        Show
        Dinkar Rao added a comment - In this patch, I took out the override for catalogSeparator, so it will default to "dot".
        Hide
        Michael Dick added a comment -

        Looks like this is true for Informix 9.3 as well (which is the oldest version supported by OpenJPA). From the SQL guide (page 4-46) the syntax looks something like this :

        CREATE TABLE [database@[dbservername]]:[schemaname].tablename . . .

        Show
        Michael Dick added a comment - Looks like this is true for Informix 9.3 as well (which is the oldest version supported by OpenJPA). From the SQL guide (page 4-46) the syntax looks something like this : CREATE TABLE [database@ [dbservername] ]: [schemaname] .tablename . . .

          People

          • Assignee:
            Michael Dick
            Reporter:
            Dinkar Rao
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development